Hey community!
I developed a pack to enable users to import XLS and CSV files into Coda tables in a more programatic way.
It enables you to create a map between the source file columns and your destination table, that you can then use to import files with the same structure more dynamically – no more XLS copy-and-paste or manually CSV importing.
There is also a sync table that extracts one file data as JSON and a companion formula that will turn any JSON (any JSON at all, not only those generated by the pack) into a Coda table, using the same mapping technique.
It is a nice helper to people that is constantly bringing new data from legacy systems and don’t want to rely on external tools to do it.
Get the pack here: Spreadsheet to Coda Pack, extend Coda with... - Coda
Check out the documentation: Spreadsheet to Coda