The fastest way to transfer an Excel file to Google Sheets
You can move an Excel spreadsheet to Google Sheets in three ways: upload the file directly to Google Drive and open it as a Google Sheet, use Google Sheets' import function, or copy and paste the data manually. The upload method is fastest for most people and preserves formatting, formulas, and multiple sheets. Google Sheets will convert your .xlsx or .xls file automatically, though some advanced Excel features may not transfer perfectly.
The process takes a few minutes and requires only a Google account. Your original Excel file stays on your computer — Google Sheets creates a new copy in your Google Drive. You can keep both versions or delete the Excel file once you confirm the transfer worked.
Key Takeaways
- Uploading your Excel file to Google Drive is the simplest method and automatically converts it to a Google Sheet while keeping your original file intact.
- Most formatting, formulas, and multiple sheets transfer correctly, but some Excel features like macros and certain functions may not work in Google Sheets.
- You can also import an Excel file directly within Google Sheets using the File menu, which gives you the option to replace or create a new sheet.
- Copying and pasting data works for straightforward spreadsheets but loses formatting and formulas, so use this method only for basic data transfer.
Upload your Excel file directly to Google Drive
Go to drive.google.com and sign in with your Google account. Click the New button on the left side, then select File upload. Find your Excel file on your computer and open it. Google Drive will upload the file and show it in your file list with an Excel icon.
Right-click the uploaded file and select Open with, then choose Google Sheets. Google Sheets will open a new tab and convert your file. The conversion usually takes less than a minute. Your spreadsheet now exists as a Google Sheet in your Drive, and you can edit it online or share it with others.
The original Excel file remains on your computer unchanged. If you want to remove the Excel version from Google Drive after confirming the conversion worked, right-click it and select Delete.
Import an Excel file using Google Sheets' import function
Open sheets.google.com and click Blank spreadsheet to create a new sheet. Once the sheet opens, go to File in the menu bar, then select Import. A dialog box will appear with three tabs: Upload, Search, and By URL.
Click the Upload tab and select your Excel file from your computer. Google Sheets will ask what you want to do with the imported data. You can choose to Create new spreadsheet (which makes a fresh Google Sheet with your data) or Insert new sheet (which adds your data to the blank sheet you just opened). Select your preference and click Import.
This method works well if you want to combine multiple Excel files into one Google Sheet or if you prefer to set up a new sheet before importing. The import process takes the same amount of time as the upload method.
What transfers and what doesn't when you convert
Most of your spreadsheet transfers correctly: cell values, text formatting (bold, italics, colors), column widths, row heights, formulas, and multiple sheets all move to Google Sheets. Conditional formatting (rules that change cell color based on values) usually transfers as well, though complex rules may simplify.
Some Excel features do not work in Google Sheets. Macros (recorded actions or scripts) will not transfer — you would need to rewrite them using Google Apps Script if you need that functionality. Pivot tables convert to static data, so you lose the ability to pivot and reorganize. Some advanced Excel functions have no Google Sheets equivalent, and those cells will show an error. Charts usually transfer but may need minor adjustments to labels or formatting.
After conversion, open your Google Sheet and scroll through to check that numbers, text, and formulas look correct. If you see error messages in cells, those are formulas Google Sheets does not recognize — you can rewrite them using Google Sheets' function library or delete them if you do not need them.
Copy and paste data if you only need the values
If your Excel file is straightforward and you only need the data without formulas or formatting, you can copy and paste manually. Open your Excel file, select all the data you want to move (use Ctrl+A on Windows or Cmd+A on Mac to select everything), and copy it with Ctrl+C or Cmd+C.
Open a new Google Sheet, click on the first cell, and paste with Ctrl+V or Cmd+V. Google Sheets will paste the data into the sheet. This method is faster only for very small spreadsheets and loses all formatting and formulas, so it is not recommended for complex files. Use the upload or import methods instead for anything beyond a straightforward data table.
Share your Google Sheet or read it back to Excel
Once your spreadsheet is in Google Sheets, you can share it with others by clicking the Share button in the top right. Enter email addresses or create a shareable link. People you share with can view, comment on, or edit the sheet depending on the permission level you set.
If you need to send the file back to Excel format, click File, then read, and select Microsoft Excel (.xlsx). Google Sheets will read a copy to your computer in Excel format. This is useful if you need to share the file with someone who uses Excel or if you want to keep a backup in Excel format.
Troubleshooting common conversion problems
If your formulas show errors after conversion, the formula syntax may differ between Excel and Google Sheets. Open the cell with the error, check the formula bar at the top, and compare it to Google Sheets' function documentation. You may need to rewrite the formula using Google Sheets' syntax, or the function may not exist in Google Sheets and you will need to find an alternative.
If your formatting looks wrong — colors are off, text is misaligned, or columns are too narrow — you can fix these manually in Google Sheets. Click and drag column borders to resize, use the Format menu to adjust colors and alignment, and reapply any formatting that did not transfer correctly. For most spreadsheets, only minor adjustments are needed.
If your file is very large (over 10,000 rows or 1,000 columns), the conversion may be slow or fail. Try splitting the file into smaller sheets in Excel, converting each one separately, and then combining them in Google Sheets if needed. You can also contact Google Support if the upload fails repeatedly.
Frequently Asked Questions
Will my Excel file be deleted when I convert it to Google Sheets?
No. Your original Excel file stays on your computer. Google Sheets creates a copy in your Google Drive. You can keep both versions or delete the Excel file from your computer if you no longer need it. The file in Google Drive is separate and will not affect the original.
Can I edit the Google Sheet and have the changes appear in my Excel file?
No. Once you convert to Google Sheets, the two files are separate. Changes you make in Google Sheets do not update the Excel file, and vice versa. If you need both versions to stay in sync, you would need to manually read the Google Sheet back to Excel format each time you want to update the Excel version.
What happens to my Excel formulas when I convert?
Most formulas transfer and work the same way in Google Sheets. However, some Excel-specific functions may not exist in Google Sheets and will show an error. You can rewrite these formulas using Google Sheets' available functions, or delete them if you do not need them. Check your spreadsheet after conversion to see if any cells show errors.
Can I convert multiple Excel files at once?
You can upload multiple files to Google Drive at the same time, but you must convert each one individually to Google Sheets. Select multiple files during upload, then right-click each one and open it with Google Sheets. For large batches, this takes longer than converting one at a time, but it is still faster than uploading and converting them separately.
Is my data safe when I upload it to Google Drive?
Your data is stored on Google's servers and protected by Google's security measures. Only you can see your files unless you share them with others. You can delete files from Google Drive at any time. If you have concerns about storing data online, keep your original Excel file on your computer and only use Google Sheets for files you want to share or access from multiple devices.