Export Google Sheets Data to Excel In Python

Jul 2, 2019 | Automation Scripts, Google Sheets API, Python, win32com | 5 comments

Google Sheets and Microsoft Excel are no doubt the two most and widely used spreadsheet software today. In this tutorial I will be showing you how to use Google Sheets API and win32com module to integrate these two applications in Python.

We will be using Google Sheets API to read data and then using the win32com module to write data to Excel spreadsheet.

Install Google Client Python Library
https://youtu.be/euIHL4q4L0Q

Create a new project
https://youtu.be/wJ6WC0G8w4o

Create a client secret file
https://youtu.be/HzICUriU3k0

Create a Google Sheets Service instance
https://youtu.be/xE0kuiAPxtA

Python Scripts
https://learndataanalysis.org/export-excel-data-to-google-sheets-in-python/

Google Sheets to Excel.py
Google.py

5 Comments

  1. Anthony Frascarelli
    Anthony Frascarelli on 2020-05-12 at 6:19 PM

    Win32 is not available on Mac. Do you have any other solution so I can successfully export google sheets to excel. I really have appreciated this series and have followed everything until that point. I hope you see this message, thank you.

    Reply
    • Timmy Adet
      Timmy Adet on 2020-06-15 at 11:11 PM

      I am getting no module named Google, what can I do

      Reply
      • Carlos
        Carlos on 2020-07-21 at 3:23 AM

        Install the google-api-python-client package

        Reply
      • Peter
        Peter on 2020-08-16 at 9:04 PM

        You did not save the above Google.py file

        Reply
    • jiejenn
      jiejenn on 2020-06-16 at 1:11 AM

      Hi Anthony,

      My apologies to reply this late since I don’t usually check my blog comments. Anyway, win32com library is only available to Windows platform.

      Reply

Submit a Comment

Your email address will not be published. Required fields are marked *