Skip to content
The table options should then be displayed automatically, if not you can hover over the table and select ‘Edit’ or ‘Options’ then ‘Google Sheets Sheet’Once you’ve named your range go back to the sync tables options.Click into the Range option
Manage your sync
Setting a Range
Sometimes dragging and dropping a full Sheet into your Coda doc may not be ideal.
This could be for a variety of reasons; it may have multiple tables within it, or maybe it has summarization data that doesn’t make sense within your sync table. In these instances you’ll want to set the Range parameter to specify what parts of the table you want to pull.
Written Instructions
Video & Example:
People (Extra Header)
ID 1
First Name
Last Name
Birthdate
Full Name
Country
Department
3
Sandra
Mccarthy
1/10/2000
Sandra Mccarthy
China
People
4
Rocco
Hard
10/14/1978
Rocco Hard
UK
DevOps
5
Terrell
Burton
4/5/1978
Terrell Burton
US
Marketing
6
Kaila
Estrada
5/24/1995
Kaila Estrada
Spain
Marketing
7
Oliver
Hays
4/16/2000
Oliver Hays
France
Marketing
8
Kiera
Bradford
4/29/2000
Kiera Bradford
Norway
Marketing
9
Beckett
Butler
5/14/1970
Beckett Butler
France
Marketing
10
Gael
Tanner
11/26/1979
Gael Tanner
Norway
Engineering
11
Frankie
Quinn
9/4/2050
Frankie Quinn
China
Marketing
12
Lailah
Horne
4/26/2023
Lailah Horne
Norway
People
13
Brendan
Crane
12/26/2005
Brendan Crane
UK
People
14
Miriam
Richmond
2/22/1995
Miriam Richmond
China
People
15
Ayla
Montgomery
6/10/1955
Ayla Montgomery
UK
Sales
16
Finley
Grant
11/10/1989
Finley Grant
Norway
DevOps
17
Delilah
Best
12/8/1980
Delilah Best
Spain
Executive
There are no rows in this table
Horizontally Oriented Data
Sometimes data in a spreadsheet isn’t set up the way you would see it in Coda.
In Coda you’ll always have data set up in a vertically oriented matter in tables. Google Sheets does not have any rules about how you set up your data so you may find some cases where the Columns are the Major Dimension, meaning that the columns contain the most important information and the rows are used for organizing or categorizing that information.
For these cases we’ve added the parameter Transform simply check it on before you sync to get the data oriented correctly in Coda.
Best by Month (Extra Header)
Month
Person
Total Sales
January
Wesley Mccarthy
13527
February
Rocco Hardin
12897
March
Terrell Burton
13447
April
Kaila Estrada
14588
May
Oliver Hays
13768
June
Kiera Gay
14851
July
Beckett Butler
11801
August
Gael Tanner
14773
September
Frankie Quinn
9393
October
Lailah Horne
12504
November
Brendan Crane
12862
December
Miriam Richmond
14151
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.