Function for CSV Generation/Export

[Brandt_Smith1]

+1 This would be a great feature to have and would get used daily by me.

[Jason_Downey]

+1
A way to Share/Publish a URL with a CSV version of a table. The resulting URL could be used with Google Sheet’s ImportHtml or ImportData (and Excel’s equivalent).

[Paul_Danyliuk]

I was toying around with the idea of exporting CSV using some black magic and custom packs:

I even managed to get it to render as an attachment in the end:

It’s not as good as a native export would be but it could be an interim replacement. If there’s enough demand (e.g. if everyone who wants a template that does this subs to my Patreon for December) I’ll finish and publish it, just like I did it this month with the duplicate finder & merger template (btw I did this CSV export as a byproduct of that merger one)

[Courtney_Milligan1]

I also think this is an important feature that is missing from Coda so I made a tool that allows you to make a button in your Coda doc that will export a table to Excel or CSV. The website is codaexport.com. Hope this helps!

[Hendrik_TnB]

That’s nice @Courtney_Milligan1 !

[Courtney_Milligan1]

Thanks @Hendrik_TnB! If you end up using it and have any suggestion for it, let me know!

[Alexandru_Dan]

Hi,

I’ve used the site but there is only one problem for me. The CSV contain information written in a way that can’t be read by other apps, like the duration in hours or minutes. So for me it’s useless as I have a lot of duration columns… Thanks anyway for your work.

[Courtney_Milligan1]

Hi @Alexandru_Dan! Thanks for the feedback. I hadn’t tested it out with a duration column but I see what you mean now. The table data comes from the Coda API, so I’m guessing this issue is the same for others using the API. Personally, I agree that a duration that gets formatted as a String with hours and minutes is not useful as well. It would be great if the Coda API could have a parameter for desired output format for certain column types. Perhaps someone from Coda can provide input on this?

[Courtney_Milligan1]

Also, for anyone interested, I’ve created a Coda Pack that you can add to your doc to export tables to CSV or a few different Excel formats

[Tomislav_Mamic]

Hey Courtney, I was trying your pack, but it tells me there is a problem with docName although I put it in in quoatitions. Can you help me?

[Courtney_Milligan1]

Hey @Tomislav_Mamic! What is the error you’re getting exactly? Can you please screenshot it?

[Allan_Guis]

Thank you @Courtney_Milligan1 it’s working realy well!

One question: Why there is in the function docId? Because on my side it’s working without it and if add the doc ID it didn’t work.

Or maybe I’m not using it well

[Courtney_Milligan1]

The docId is just there if you want to export a table from a different doc, but by default, it uses the current doc. I realized this is a bit confusing though so I’m thinking of removing it altogether… Anyway, glad the pack is working for you!

[Devid_Smith]

you can follow this guide to to export airable to csv. How To Export Airtable To Excel

[Paul_Danyliuk]

For anyone finding this thread — this is natively available in Coda (and I only spotted it now. somehow must have missed the news)

Export your table data to a .csv

We understand working with people outside your Coda workspace is an important part of your workflow, so we added another opportunity to export information with a .csv. New sharing level unlocked. A .csv export is useful for sharing your table data with a vendor, contractor, or person you work with outside of Coda. If you are a doc maker or editor, you can export all visible data in a table or card, or what’s in the layout of a detail view, calendar, or timeline. [Export a csv.gif] The fun do…