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.
12. On the Sample Screen, check the Auth section
13. Enable Auth by using the checkbox
This will essentially work as a password
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
