xlsx to Google Sheets is one of the conversions it supports.įollow the steps below to have this option automatically toggled for future projects: 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. 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.Īutomatically Convert Excel To Google Sheets When Uploading Click “File” > “Save as Google Sheets.” The Microsoft Excel spreadsheet should now be converted into a format supported by Google Sheets.If you’re looking to convert it, proceed to step 5. xlsx file (which is the proprietary file type of Microsoft Excel). The file should be editable in Google Sheets, but it’s still a. Navigate to this file in Google Drive and open it.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). In the pop-up, you can go through your computer files and choose the Excel sheet you want to upload.Click the “New” button in the top-left corner of the page and select “File upload.”.Open Google Drive in your web browser and sign in to your Google account.The second way to open Excel in Google Sheets is by first uploading the file to Google Drive and then converting it.

When you’re ready, click the “Import data” button to finalize the process. This includes import location, separator type, and whether or not to convert text to numbers, dates, and formulas. Once you’ve selected a file to upload, you’ll see another pop-up where you can finalize specific import options.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). Select a file from your Google Drive or upload it. A pop-up will appear and you’ll choose the Excel file to convert.Select “File” > “Import.” You can use this option to import CSV files to Google Sheets (and it works just as well for.Log into your Google account in your preferred web browser.Google Sheets comes with the ability to natively convert Microsoft Excel spreadsheet files to a file format that’s compatible with Google Docs. Importing Excel Into Google Sheets From Spreadsheet Options Whichever you decide, we’ve provided both methods. 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. Can Google Sheets Pull Data from Excel Automatically?ĭifferent Methods to Import Excel to Google Sheets.Automatically Convert Excel To Google Sheets When Uploading.Importing Excel Into Google Sheets From Spreadsheet Options.Different Methods to Import Excel to Google Sheets.

Convert pdf to excel google sheets