Export to Excel (Windows)

Make sure you have Created an Export 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