There are plenty of reasons to open an Excel spreadsheet in Google Sheets. Perhaps you want to access the data but donโt have Microsoft Excel installed. Maybe you simply prefer Google Sheets as a spreadsheet platform. Either way, you can import Excel to Google Sheets without an issue.
In this guide, weโll walk you through different ways to import an Excel file into Google Sheets and how you can do it automatically moving forward.
Table of Contents
Different Methods to Import Excel to Google Sheets
There are two straightforward methods for opening Excel files in Google Sheets: using Google Sheets to convert the file or going through Google Drive instead. Whichever you decide, weโve provided both methods.
Importing Excel Into Google Sheets From Spreadsheet Options
Google Sheets comes with the ability to natively convert Microsoft Excel spreadsheet files to a file format thatโs compatible with Google Docs. Doing so couldnโt be easier;
- Log into your Google account in your preferred web browser. Head to the Google Sheets homepage.
- Open a blank Google Sheet.
- Select “File” > “Import.” You can use this option to import CSV files to Google Sheetsย (and it works just as well for .xlsx spreadsheets).
- A pop-up will appear and youโll choose the Excel file to convert. Select a file from your Google Drive or upload it. If you choose the latter, drag and drop the file or click the BROWSE button (which will open aย window where you can search for the file from your computer).
- Once youโve selected a file to upload, youโll see another pop-up where you can finalize specific import options. This includes import location, separator type, and whether or not to convert text to numbers, dates, and formulas. When youโre ready, click the โImport dataโ button to finalize the process.
Converting Excel From Google Drive
The second way to open Excel in Google Sheets is by first uploading the file to Google Drive and then converting it. To do so, simply follow these steps:
- Open Google Drive in your web browser and sign in to your Google account.
- Click theย โNewโย button in the top-left corner of the page and select โFile upload.โ
- In the pop-up, you can go through your computer files and choose the Excel sheet you want to upload. Once you highlight your file and click theย โOpenโย button, it should appear in your Google Drive within a few seconds (depending on the size).
- Navigate to this file in Google Drive and open it. The file should be editable in Google Sheets, but itโs still aย .xlsx file (which is the proprietary file type of Microsoft Excel). If youโre looking to convert it, proceed to step 5.
- Click โFileโ > โSave as Google Sheets.โ The Microsoft Excel spreadsheet should now be converted into a format supported by Google Sheets.
Note: If youโre looking to convert Google Sheets to Excelย format, you can click โFileโ > โDownload.โ From there, you can choose which file type the downloaded spreadsheet will have, including Microsoft Excel-supported file extensions.
Automatically Convert Excel To Google Sheets When Uploading
If youโre tired of having to open Excel in Google Sheets and manually convert spreadsheets, Google Drive includes an option to automatically convert files into a supported format whenever possible. Fortunately, .xlsx to Google Sheets is one of the conversions it supports.
Follow the steps below to have this option automatically toggled for future projects:
- Open Google Drive in your web browser and sign in to your Google account.
- Click the gear icon in the top-right corner and select Settings.
- Selectย โGeneralโ from the left-side panel and tick theย โConvert uploads to Google Docs editor formatโ checkbox. You can find this under the Convert Uploads header.
Now, whenever you upload a .xlsx file to your Google Drive, itโll automatically convert it to Google Sheets formatting. This eliminates the need for manually uploading Excel to Google Sheets for conversion.
Frequently Asked Questions
Does XLSX Work in Google Sheets?
The proprietary file format for Microsoft Excel spreadsheets is .xlsx, but you can open Excel in Google Sheets. These types of files can be opened from within Google Sheets natively and youโll be able to edit all the information stored in the sheet without issues. That said, there may be some compatibility problems with other Google products.
Can Google Sheets Pull Data from Excel Automatically?
Having to convert each Excel file to Google Sheets format can be quite a hassle, especially if youโre working with lots of Excel spreadsheets. On the plus side, Google Drive has a cool feature that automatically converts any uploaded files to a Google Doc-supported format. This works for .xlsx as well, so all you need to do is upload the Excel sheet and itโll be changed into Google Sheets format.
Conclusion
Microsoft Excel is an excellent spreadsheet program thatโs been the standard for decades. But a greater number of people are migrating to Google Sheets, whether to save some money or collaborate with others.
Whatever the reason, thereโs bound to be a time when youโll have to import Excel to Google Sheets. Luckily, itโs simple and requires a handful of methods outlined above. You can also customize your Google Drive settings to automatically convert Excel files to the Google Sheetsย formatย โ whenever theyโre uploaded.
Want to discover more advanced spreadsheet knowledge? Check out these awesome Udemy courses for G Suiteย today!
Related: