How to Convert Excel File to Google Sheets?

Our team has over a decade of experience in Excel and Google Sheets automation. People often ask me how to save an Excel file to Google Drive. And they are surprised that there’s such an option.

With a few simple steps, you can easily transfer your Excel files to Google Drive. In this article, we’ll explore exactly how to do that, and provide some tips to help you get started.

How to save an Excel File to Google Drive?

1. Go To Your Personal Google Drive

Before you can save an Excel file to Google Drive, you’ll need to ensure you have a personal Google Drive. Open Google Drive on your computer by accessing the Google Drive website. Sign in with your Google account and follow the next steps.

Related Article: How to Excel Template?

2. Create a Folder and Upload Your Excel File

Create a folder or choose an already existing folder for your Microsoft Excel file. Once you have the folder, click the right button on your mouse. A drop-down will appear. Select the “file upload” option.

Google Drive will open your Computer folder and let you select the file you want to upload.

Screenshot from Google Drives taken by the author

Once you have selected the file you want to upload on Google Workspace the upload tab will start. Wait for a couple of seconds and you’ll have an imported Excel file in your Drive.

Screenshot by the Author on Google Drive

Now you have uploaded the Excel file on Google Drive. Start editing with Google Sheets and sharing files with others online. Another great feature of Google Sheets is that your workbook is automatically saved.

Related Article: 10 Tips on How To Reduce Excel File Size

Step 3: Edit Your Excel File With Google Sheets

Once you have opened your Excel file through Google Drive you can start editing with Google Sheets. Please keep in mind that Google Sheets doesn’t provide as many features as Excel format. When you’ve uploaded an Excel file on Google Drive you have only Google Sheets features available.

Google Sheets may remove some formatting or replace formulas and your file can look different once uploaded on Google Drive App. But the great news is that you can edit this file online with colleagues. Also, use other features that Google Sheets provide but Excel doesn’t.

Screenshot on Google Sheets taken by the Author

Related Article: How to Remove Conditional Formatting in Excel

4. Convert the Excel file to Google Sheets

Continue editing your Excel file or automatically convert it to Google Sheets for better performance. Go to the quick access toolbar. Click on File to convert uploads. Select “Save Excel File as Google Sheets.”

This will save the workbook as a Google Sheets document. This action will create a Google Sheets file copy in your folder.

Screenshot by the Author in Google Sheets

Now you have a Google Sheets file with the same data and formulas. Feel free to edit your file in google docs editor format.

Related Article: A comparison of Excel and Google Sheets: Which one is right for you?

Once you need an Excel file or other format you can go to File -> Download -> Choose The Format (.xlsx, .ods, .pdf, .HTML, .csv, or .tsv.)

The screenshot was taken by the Author in Google Sheets

Related Article: How to Print a Graph in Excel and Google Sheets

Conclusion

Saving an Excel file to Google Drive is a simple process that can be completed in just a few steps. By following the steps outlined in this article. You can easily transfer your Excel files to Google Drive and take advantage of the many benefits of cloud-based storage.

Frequently Asked Questions

Learn more about Excel and Google Sheets hacks in other articles. Stay connected with us on social media and receive more daily tips and updates.