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, access the Import option under the + menu, then choose CSV from the prompt. If you want to import column names, select CSV file has column names. 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.
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?