Thankfully, there is a simpler method available, and it involves accessing Excel files in Google Sheets. And you have the question that How to open an excel file in google sheets? What are your options? What do you do? You might attempt downloading the file to your own computer, but doing so is inconvenient, and if you are using a computer that is shared with other people, they may not be pleased if you do so. Excel has detected the column headers as Column1, Column2, etc., To modify the column headers, click on Transform Data.You have an Excel file that you need to work with, but your office is completely full, and a coworker is using the one and only computer that has not Excel installed. If I click on Load, this data will be loaded into a new Excel Worksheet.īut here we have to make some changes. Click on Connect.Ī new dialog called Navigator is activated and this dialog has the preview of our data in Google Sheets.

If you are connecting Excel to Google Sheets for the first time you will get a dialog called Access Web Content.

Replace edit?usp=sharing with export?format=xlsx and click OK Next step is the integral part of this method. Paste the copied link into the dialog called From Web To import data into Excel, Open a new Excel file > go to the Data tab of Excel ribbon > Get Data > From other sources > From Web Once the link is copied we will get a message, then click on Done. To connect this sheet with an Excel file, Click on the Share button. Once a spreadsheet in Google Sheets is connected with an Excel file, the changes made in the Source (Google Sheet) will be reflected in the Excel file at the expense of a single mouse click.įollowing is my Google Sheet containing some sample Sales Data.

In this blog post, I will explain the step by step procedure to Connect Google Sheets with Excel using Power Query.

Open excel with google spreadsheet