Inside this article
- Can I import a Table?
- Can I export a Table?
How to use Tables
Adding a new Table
- Add a Table - Click the plus icon in the upper-left of the menu bar, and select Table.
- Add a Row - Hover over the table and click the large + icon at the bottom-left corner of the Table. Or when hovering over the first column of any existing row, click the small + icon that appears at the bottom-left corner of the cell.
- Add a Column - Hover over the Table and click the large + icon that appears in the upper-right corner of the Table. Or, right-click the top of any column and select Insert Column Left or Insert Column Right from the dropdown menu.
Editing your Table
- Select a Row - Click the row handle that appears to the left of the row when you hover over it. Or, if you like keyboard shortcuts, click a cell and arrow all the way to the left to highlight the entire row.
- Select Multiple Rows - Select the first row, then press Shift or Command to select another row. If you're selecting an adjoining row, you can just arrow down or up while holding down Shift if you prefer.
- Delete a Row - Once you've selected a row(s), you can delete them by simply clicking delete on your keyboard. You can also delete one or more rows by using right-click to bring up the row menu and select "Delete row".
- Drag and Drop - Simply click the column or row heading, and drag it to where you want it to be. The best part? It will automatically take on the formatting of it's new place in your doc!
Watch a video about Tables
Why Tables matter
Tables in Coda
Coda Tables should feel a bit different to you from a spreadsheet. Some things will feel familiar - you’ll see grids where you can enter data, add and remove rows and columns, and sort data, but some things will feel different. For example, there’s no A2, B5 numbering scheme like you're used to in Google Sheets or Microsoft Excel. That's because there's a lot more going on under the hood to give you much more power and flexibility with your data.
Spreadsheets versus databases
Tables in Coda function more like databases than spreadsheets. While Coda tables behave more like databases, users can view and manipulate their data with ease like in a spreadsheet. So, how are spreadsheets and databases different? Well, spreadsheets are typically used to keep track of data and do calculations while databases, on the other hand, are used to store information that can be manipulated at a later time to answer particular questions you have.
When you create a Table, you can organize your data the way you think about and describe it. Rows generally represent “things” (people, tasks, inventory items, places to visit, grocery list items, etc), and the columns are generally “attributes” of those things (their gender, age, address, etc).
You can use meaningful names for columns, and then when you need it, you can ask for things like “give me the age of this person” instead of “give me what’s in B2”.
Can I import a Table?
If you're starting from data in a spreadsheet, simply select the specific table of data you want to import, copy it, and paste into Coda. If the spreadsheet has more than one table, copy each table one at at time. You can also use one of the import helpers from the + menu:
And, to help you out, Coda understands the structure of your data, and automatically detects column headers and column widths.
What's more, it detects the type of data in each column and picks the right format to make your data shine. For example, dates automatically show a calendar picker, true/false values display as checkboxes, and columns with repeated values offer convenient dropdown menus.
If you're starting from another app, see if it supports exporting to a spreadsheet format, then copy from the spreadsheet export before pasting into Coda.
Can I export a Table?
If you need to export data from Coda, our recommended approach is using copy and paste since it is the most straightforward. When Coda copies, the paste is then in a standard format that most apps understand.
If you need to export an entire table of data from Coda, first make sure that the the full table is visible in Coda by showing any hidden columns and removing any filters.