CSV Getter Docs
CSV GetterLoginSign Up
  • Welcome
  • What is CSV Getter?
  • The Export URL
  • Data Sources
    • Connect Airtable
    • Connect Notion
    • Connect Google Sheets
    • Upload Data
  • Destinations
    • Connect to Dropbox
    • Connect to Google Drive
  • Exporting
    • Export Airtable
    • Export Airtable (With Airtable URL)
    • Export Airtable (via API)
    • Export Notion
    • Export Google Sheets
    • Export Uploaded Data
  • Automations
    • Export to Excel (Windows)
    • Export to Google Sheets (Drive)
    • Export to Google Sheets (Direct)
    • Export to Dropbox
    • Export to JSON
    • Export to XML
  • Airtable
    • Linked Records and Lookup Fields
    • Export Shared Airtable View
  • Platform Features
    • URL Parameters
    • The "Type" Parameter
    • The "SQL" Parameter
    • Email Notifications
    • Extract JSON Property
    • Embeddable Wordpress HTML
  • Misc
    • Zapier Code Example
    • Google App Script Snippet
  • Custom Chat GPT Code
Powered by GitBook
On this page

Was this helpful?

  1. Automations

Export to Excel (Windows)

PreviousExport Uploaded DataNextExport to Google Sheets (Drive)

Last updated 3 months ago

Was this helpful?

Make sure you have first


1. Go to CSV Getter Home

2. Copy the Export URL of the data you want to sync with Excel

3. In Excel (on Windows), click the data tab.

4. Click From Web

5. Paste in your Export URL

6. Click OK

7. Review your data and click load

8. Use the Queries & Connections pane

You can keep your data up to date without leaving Excel.

9. You can Refresh the data at any time

10. You can set a scheduled refresh by clicking Properties

11. Make sure 'Refresh every' is selected

You can also specify a refresh interval.

Optional Extra Step: Auth

12. On the Sample Screen, check the Auth section

13. Enable Auth by using the checkbox

14. Type in an Auth header

This will essentially work as a password

15. Click on Save Auth Header

16. For authenticated URLs, you will need to use 'Advanced' option when importing data.

17. Paste your URL and add a 'Authorization' request header that matches your Auth header set in CSV Getter

The Authorization Parameter format should be Bearer your_set_token.

18. Press OK

Created an Export