When creating a new table, if another table in the document already exists, one gets this very useful dialog:
// Image in code block, as "new users can only upload one media element"
However, if the document does not contain other tables, this dialog does not appear, and creating a table just inserts the usual placeholder data:
// Image in code block, as "new users can only upload one media element"
From there, the only way to import data from a CSV is to right click and select “Import CSV…”, which expects the CSV columns to be mapped to existing columns and does not even provide a way to create new columns when the existing columns are not sufficient:
The actual bug here should be pretty easy to fix: I imagine the reason the import dialog doesn’t appear for the first table is that in the past this dialog only served to import data from another table, and the conditional for displaying it has not been updated.
However, there are also some enhancements that could be made to the process of importing CSV data to an existing table to make the process smoother:
- “Create new column” option so that users don’t need to abort the process, create extra columns, then restart it.
- An attempt to guess the correct column names could save user time. Currently even column names that are identical or only differ in casing had to be matched manually.
PS: This is likely specific to my CSV, but when I tried to import it into a new table, Coda kept crashing, whereas importing it into an existing table worked fine.