How to Export Google Docs on a Schedule to Csv in Windows

Here’s a quick how-to on how to configure your windows computer to download any Google spreadsheet to .csv a regular basis.

1. Go to File then Publish

2. Then select what sheet you want to make available.

3. Then select the output type. In most cases .csv is more than sufficient.

4. Click the green Publish button.

5. Save the link given. We’ll need that in a second.

6. Download and Install Git

7. While installing, follow the prompts. Leave options as is.

8. Open up your Task Manager

9. Create a new task.

10. Enter the name and select ‘Run whether or not user is logged in”

11. Create a trigger to run when you want. I set a trigger to run every day @ 5p

12. Then create an action.

13. In the Program/script field put in "C:\Program Files\Git\bin\sh.exe"

14. In the argument box put in --login -c "curl '<THE URL FROM STEP5>' > /c/Users/<ENTER YOUR USERNAME HERE>/Desktop/<FILENAME OF YOUR CHOICE>.csv" Make sure you keep the ‘’ that are surround the URL. Also, you will have to customize to your windows install. Find what your User folder is named and place it where I wrote <ENTER YOUR USERNAME HERE> (This is your Windows username. Open up Explorer go to C:\Users to double check)

15. You should be good to go. Press OK to save your changes. You may be prompted for your password. Enter it.

16. To test, select the task and then on the right side click Run. Check your desktop location and it should have a file called <FILENAME OF YOUR CHOICE>.csv

Have fun!

Last Modified: 2020.3.7