Skip to main content

Link for Exporting data as CSV

  • May 27, 2019
  • 6 replies
  • 299 views
B
Forum|alt.badge.img+13

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!

D

6 replies

O
Forum|alt.badge.img+19
  • openside
  • Inspiring
  • May 28, 2019

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.

B
Forum|alt.badge.img+13
  • Brett_D
  • Author
  • Known Participant
  • May 28, 2019

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.

M
Forum|alt.badge.img+20
  • M_k
  • Inspiring
  • May 28, 2019

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

O
Forum|alt.badge.img+19
  • openside
  • Inspiring
  • May 28, 2019

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

V
B
Forum|alt.badge.img+13
  • Brett_D
  • Author
  • Known Participant
  • May 30, 2019

@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 :slightly_smiling_face: Amazing! Thank you so much

V
M
Forum|alt.badge.img+15
  • Moe
  • Inspiring
  • March 28, 2020

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

Terms & ConditionsAccessibility statement