How to Convert Excel Spreadsheets to Google Sheets

  • MORE

One useful Google Sheets features is the Web-based spreadsheet program's ability to upload a Microsoft Excel document for online editing.

uploadexcelend

I've often started a spreadsheet in Excel where I'm less distracted, and then uploaded it to Google to better collaborate with others. This feature is also useful if you no longer want to use Excel, and have a library of old .xls or .xlsx files you want to keep using. Here's how to convert those files.

MORE: Best Chromebooks Available Now

1. Sign into Google Sheets and click the folder icon below your profile photo.

upload01

2. Click Upload.

upload02

3. Click "Select a file from your computer."upload03

4. Select an Excel file and click OK.

upload04

You can now edit your Excel spreadsheet in Google Sheets.

upload05

Author Bio
Henry T. Casey
Henry T. Casey,
After graduating from Bard College a B.A. in Literature, Henry T. Casey worked in publishing and product development at Rizzoli and The Metropolitan Museum of Art, respectively. Henry joined Tom's Guide and LAPTOP having written for The Content Strategist, Tech Radar and Patek Philippe International Magazine. He divides his free time between going to live concerts, listening to too many podcasts, and mastering his cold brew coffee process. Content rules everything around him.
Henry T. Casey, on
Add a comment
1 comment
  • Marty Says:

    If you do this method, you'll have two versions of the file - one in .XLS format, and the other in Google Sheets form. It can be confusing having two files with the same name in your Drive (the Google Apps version will be the most current, if you use Sheets).

    I recommend changing your Drive settings. In Drive, click the Gear icon and select Settings. Check the "Convert uploaded files to Google Docs editor format" box and click Done.

    Now you have one file in Drive in the correct format (you can always export your files in .XLS format) and Google Apps files don't count against your Drive storage limit.

    Note: Macros and linked spreadsheets are not supported by Google Sheets.

Back to top