Converting your Excel file to Google Sheets You can also convert your Excel file to a Google Sheet without any extra tools. You can keep working in this file format, which is useful if you need to send the file back to Excel later. XLSX bubble at the top means you’re still opening and working in an Excel file. You can also click on it in the upload dialog to open it.
Excel has detected the column headers as Column1, Column2, etc., To modify the column headers, click on Transform Data.
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.
0 kommentar(er)
