I often have a coda table to which I want to add many new columns from another table (usually excel or sheets, but could be a coda table as well)
I can paste an example row of data or multiple to create all the columns fast, but then I have to manually click and rename all the columns. This is a big pain and a ton of clicking and typing.
How can I paste a COLUMN NAME (or even better multiple names)? Is there any trick to this? Like creating another table and pulling in the column names for example?
I know I can import csv to get the columns, but that does not work if I already have a table set up with lookups and formulas (also time consuming) and need to add 20 new columns to it…
Thanks for suggestions and saving clicks and carpal tunnels.