Link for Exporting data as CSV

[Brett_D]

Hey! I am looking to periodically update my wordpress sites using WP All Import (http://www.wpallimport.com/). I have been advised by them that if I were to use Google Sheets to achieve this, I should be changing the shared link from:

https://docs.google.com/spreadsheets/d/FILE_ID/edit?usp=sharing
to:
https://docs.google.com/spreadsheets/d/FILE_ID/export?format=csv

Does anyone know if I could be using Airtable instead of Sheets, and if so, what my Airtable shared URL should look like? It needs to export as CSV.

Thanks!

[openside]

Unfortunately that is not available in Airtable. You can manually export a table as CSV through the UI, but there isn’t an externally accessible url to pull the CSV like there is with Google Sheets.

[Brett_D]

Oh okay, that’s a shame. Thanks for responding.

[M_k]

Hi @Brett_D

I have just finished creating a scenario using Integromat to create a CSV backup of my Airtable records to Google Sheets and so far it seems to work. Then if I need to use my backup to place my records back into Airtable, I just create the reverse scenario. I realize it’s not using a URL to do this, but there is the option to do it by using Integromat.

Hope this helps.

Mary

[openside]

@Brett_D - another approach is to use this product (https://builtonair.com/resource/airtable-importer/) to import your Airtable into Google Sheets, then you can use the export link from there.

[Brett_D]

Awesome, I think this ought to do it. And it’s free :slightly_smiling_face: Amazing! Thank you so much

[Moe]

We created a tool that allows you to export your Airtable view as a CSV link. It works with multiple views as well.