Skip to main content

  1. There’s no API call for exporting a table as CSV right? (couldn’t find it in API documentation)

  2. Has anyone written a script that mimic that functionality by iterating through all the records, replacing linked record IDs with names, and then, generating said CSV? If not, I’ll work on writing one…

I suspect you could do a Google sheet export with one of those…

Maybe https://www.integromat.com has more advanced features. @Julian_Kirkness can probably tell us something about that. :slightly_smiling_face:


Thanks @Tuur, I took a look at integromat and there doesn’t really seem to be anything in terms of a daily csv report. I created a free acount and there are some triggers but those are in relation to records being updated in a view. Actions also don’t seem to have an option to download “.csv”. If @Julian_Kirkness has any insight that he could provide, it would be really appreciated.

Thanks @Tuur, I took a look at integromat and there doesn’t really seem to be anything in terms of a daily csv report. I created a free acount and there are some triggers but those are in relation to records being updated in a view. Actions also don’t seem to have an option to download “.csv”. If @Julian_Kirkness has any insight that he could provide, it would be really appreciated.


That’s a shame…

If you’re really stuck I can help you with a (paid for) custom solution. Just send me a PM and I’ll be glad to help you.

Hi there, @Tuur. I’d be interested in that solution. Can you PM me, so I can learn more?

I can’t speak to its accuracy, but there is a php routine for generating CSVs via the API available on codegists.

Hey all, if you’re finding this thread while looking for “normal backups” as Tuur was referencing earlier in the thread, we’ve built a way to do external backups for Airtable automatically to address the need directly.

So if that kind of backups are a priority for you, check out the show and tell here: How to set up automatic external backups for Airtable in 20 minutes

Hope that helps!

Hi @Steven_Zhang! Unfortunately the API doesn’t have a call for that.

I’ve written something though, details are in your message box. :slightly_smiling_face:

Best, Arthur.


Hi @Tuur! I’m looking for a similar solution, but it’s not for backups. I need to export a CSV from AirTable in order to pass data into another program (Vantage) which is not supported by Zapier. Do you have any tips?

Thanks!

Yup. I’ll send you a PM. :slightly_smiling_face:


Tuur, could you also share it with me please? :slightly_smiling_face: Thanks in advance!

@Tuur interested too!

Hi there @Tuur, I’d really like to access this as well. Can you hook me up? Thanks!

I have a page here - https://www.pagemonk.com/export which I use for downloading CSV files. Are you looking for the same thing via API?

@Tuur Could I i please have access to the script you wrote for auto exporting CSVs? It would be immensely helpful!

Hi @Tuur please can I go for it too? I have been wrestling with Zapier into Zoho / Excel and its just too much of a workaround compared what I can see being discussed here…
Would be forever grateful - Thanks

PM incoming. {20 char filler}


@Tuur - can you send me the export script you’ve written. Thanks!

@Tuur can I get access to the script as well, please?

I’d also like the script!

I built a desktop app that lets you export your Airtable data to CSV files. It also converts Linked records to corresponding Primary field values.

Its at https://www.pagemonk.com/export . Hope it helps somebody !!

Following up on my original post 3 years later… A friend mine made a webapp to do automatic regular cab backups. They’re having some login issues with the community account, so posting on their behalf:

Created https://backuptable.com after trying and failing to find a means of regularly backing up my bases on airtable. BackupTable doesn’t try to do anything more or less than what the name implies - it backs up everything you have on airtable (plus attachments) and can do so either manually or automatically. Dropbox sync coming soon.

Hope people find it useful and would love to hear feedback :slightly_smiling_face:

Hi @Steven_Zhang! Unfortunately the API doesn’t have a call for that.

I’ve written something though, details are in your message box. :slightly_smiling_face:

Best, Arthur.


Hi Tuur–

I’m looking for the same thing.

Thanks for sharing!

@Tuur I’m very interested in this. Would you mind sharing with me too please?

We made a tool exactly for this!

Hello, I was facing similar problem lately, and decided to create a python package just for this.


You could programmatically download csv from any shared view. While you can download csv without API key, sadly you have to create a shared view link for this to work

Hi @Steven_Zhang! Unfortunately the API doesn’t have a call for that.

I’ve written something though, details are in your message box. :slightly_smiling_face:

Best, Arthur.


Hi @Tuur @Steven_Zhang, can you share the script via PM please?

@Tuur could you share the script with me as well via PM?

I built a desktop app that lets you export your Airtable data to CSV files. It also converts Linked records to corresponding Primary field values.

Its at https://www.pagemonk.com/export . Hope it helps somebody !!


I’m getting an HTTP 404 on the link; site loads fine.

Yup. I’ll send you a PM. :slightly_smiling_face:


Do you still have something written for this? Hoping to pull the CSVs from a python script.

Terms & ConditionsAccessibility statement