Skip to main content

Link for Exporting data as CSV

  • May 27, 2019
  • 6 replies
  • 379 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!

    This topic has been closed for replies.

    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.

      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

        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