Function for CSV Generation/Export

+1 here, another feature that should be available soon.

1 Like

Hey there is a pack request for CSV - go add your votes to it!

2 Likes

Thanks for that! I’ll go do it!

1 Like

Hi @Michael_RnW,

You might wanna check out this too

Pack requests -Things I use that I desperately want to integrate with Coda 🤣

1 Like

+1 for built-in dead-simple way to download a table as a csv. I’d also love to connect this to an automation so that I could, say, download a new copy of a table as a csv every week.

4 Likes

+1
We really need this feature if we are to use Coda and replace databases across our Org.

3 Likes

Hi - welcome to the Coda community! We keep track of feature requests like this so our product team can review customer feedback as they plan. I’ll go ahead and add your vote to this suggestion. I appreciate you chiming in :+1:

5 Likes

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

1 Like

+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).

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

ezgif.com-gif-maker (24)

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

image

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)

5 Likes

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!

2 Likes

That’s nice @Courtney_Milligan1 !

1 Like

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

1 Like

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.

1 Like

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?

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

2 Likes

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?
CleanShot 2022-05-13 at 18.49.10

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

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 :smiley:

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!