Turn any Spreadsheet or CSV to Coda table

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

11 Likes

Looks really great!!

1 Like

Hugo let me play with a beta version and I can confirm this pack is totally awesome! It makes the workflow of importing data into Coda from CSV or XLS files a thousand times more user friendly, reliable, and less prone to human error.

If you’re building a doc with workflows that necessitate users import tabular data into your doc, and those users are regular people or customers who aren’t particularly competent with Coda, this pack will save you from a ton of support tickets and frustrated users.

Well done on the launch, @hugo_assuncao. Super proud of you!

1 Like

We have been able to use this pack for a couple of our clients at Simpladocs

It’s provided such an easy way to import data from old systems into new Coda documents and workflow

Love it

1 Like