Skip to main content

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!

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.

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.


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

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

@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 - 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.


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

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


Reply


Terms & Conditions