One of the easiest ways to get started in Coda is with existing data from another app. The good news is that many applications support exporting data as a CSV file making it easy to import these files into Coda using our CSV import feature!
To import from a text file, type /import into the canvas. You'll see a list of other tools to import from including CSV.
If you want to import column names, toggle the CSV file has column names option on. Then, select the file containing your import data. Coda will load all data from the file and store it in a new table.
A CSV file is a simple text file with one line of data per row and commas to separate the field values. CSVs are by far the most common form of text data files and can be created easily by exporting data from your apps including Microsoft Excel, Google Sheets, and more.
Most, but not all, CSV files have the names of the columns in the first row so you can choose to use the first row as column names when you import with Coda's CSV import tool.
Other Text Import Options
You also have the ability to simply copy/paste content into Coda. This will work equally well for both tables and text. You can also create multiple pages in your Coda doc to keep everything organized.
If you imported the data and forgot to import the column names, you can easily make this change. Simply select the first row in your table and then bring up the row menu by right clicking (if you're using Windows) or by holding the control key and clicking on the row (if you're on a Mac).
Now select the Use as column headers menu option. This will take the selected row and use the data in that row to rename all columns in your table. Pretty cool right?