If you make changes to the file, Google maintains the. The file in Google Sheets is an editable Excel file. In the resulting submenu, choose Open With, and then select Google Sheets. You can use one of your Excel files or the demonstration PBIGoogleSheets_ExcelDemo.xlsx file after saving it locally.įigure A Open the Excel file with Google Sheets.ĥ. Locate and then select the Excel file you want to upload and click Open ( Figure A). You can also upload a folder, which is convenient, but we won’t do so now.Ĥ. In the resulting dropdown, choose File Upload. To demonstrate, let’s upload an Excel file into Google Drive and then save it as a Google Sheets document:ģ. Rather, it creates a new Google Sheets file - you end up with an. gsheet file, Google Sheets won’t replace the Excel file. After all, Google Drive is about storage, not format. Google Drive lets you upload and store an Excel file without forcing you to convert the.

How to upload and save an Excel file as a Google Sheets file You can download the demo file for this tutorial. I’m using Google Sheets in Microsoft Edge and Microsoft Power BI on a Windows 10 64-bit system. We’ll also review how to import Microsoft Excel data into Google Sheets and vice versa. In this tutorial, I’ll show you how to import data from Google Sheets into Microsoft Power BI. Microsoft 365: A side-by-side analysis w/checklist (TechRepublic Premium) The capability to do so has been around for almost a year so it might be beneficial to learn how. With many users and even organizations turning to Google Sheets, you might find yourself needing to import data from Google Sheets into Microsoft Power BI. Microsoft is probably feeling Google’s influence because the latest version of Microsoft Edge interfaces with Microsoft 365, and the dashboard looks a bit like Google Drive. Lots of users are turning to Google Sheets because it’s free and easy to use. For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Learn how using data stored in Google Sheets is now as easy as copying a URL. How to use Google Sheets data in Microsoft Power BI

Download google sheets for windows 10