Function for CSV Generation/Export

This might be too specific, but I have found a use case already in our company.

At the moment, if you want to send the data of a Coda table in CSV you have to:

  • copy and paste data in another software
  • save the file as CSV
  • do whatever you want to do with the CSV file (in my case email to a partner)

A Coda function that generates a CSV would be useful in things like:

  • one click save csv
  • one click attach to email and send
  • pushing CSV data to future Coda packs

I honestly don’t want to deal with spreadsheets ever again now that I found Coda, but many business partners have their own bespoke/archaic software and the only way to exchange data is through a CSV.

Thanks so much for reading!

9 Likes

I’ve voted for this item as well. It would be very helpful to have a means of automating the export so that the data can be used in other tools. I need to use the data for reporting in another tool and this current manual process makes it impossible to automate the reporting. I suppose there may be a means to get a plug-in for my browser to do this via some keystoke playback, but it’s going to be very dicey and not very reliable.

Is there a way to know if export functionality appears anywhere on the Coda roadmap and when it’s scheduled?

1 Like

Since I’ve been using Coda religiously for many months now, I’d like to bump this suggestion up.

I think it would work really well if there was a button on each table, or something like that, that you can click and download a quick CSV of the table.

I now have 3 different apps that we use for work which require us to manually copy paste data in a spreadsheet so we can generate CSVs. One of these apps sends a CSV to our fulfilment centre for manual processing. The rest two create CSVs of transactions from OFX and LayBuy so they can be imported in Xero for reconciliation.

There is no way to automate this further, for example with Zapier. You just have to copy the data to a spreadsheet and save a CSV. Please let us save a CSV directly from Coda, I understand it sounds like a backwards solution but it will be a long time before we can automatically push data to all apps from within Coda (e.g. using Zapier). We can use CSVs until then and when the capability arrives we’ll update our docs to push the data automatically.

Here’s what I figured:

  • If you select the whole table (view etc), copy it via Ctrl/Cmd+C, and insert into a text file or a text field, you’ll get a valid TSV (Tab separated values) file.
  • You can use some online converter website, e.g. https://onlinetsvtools.com/convert-tsv-to-csv (not affiliated) to paste TSV and get CSV there.

I have a feeling that it should be possible and relatively easy to make a Chrome plugin that would add the button to Coda tables and do the conversion seamlessly. I’m not that comfortable with writing JS though.

2 Likes

That’s not a bad workaround, it’s a bit faster than going through GSheets. You can actually paste the table directly on the online converter and then save as on the right panel.

But I’d rather not paste customer and financial data on a random website, even if I know 99.9% it’s fine. :slight_smile: