If you work with Google Sheets, there may be times when you have to convert Excel to Google Sheets. This allows you to collaborate with others and benefit from the powerful features of Google Sheets.
There are a couple of ways to convert Excel to Google Sheets:
Let’s go through these methods in detail.
Here are the steps to convert Excel to Google Sheets by importing the Excel file:
In my opinion, the conversion is almost flawless. I have converted many Excel files into Google Sheets (that had formulas and conditional formatting), and in most of the cases, I got a perfect conversion.
However, in some cases, you would lose some functionalities when you convert an Excel to Google Sheets:
This method is best suited when you have a couple of Excel files that you want to convert to Google Sheets.
This method is best suited when you have a lot of Excel files that you want to convert to Google Sheets.
Here are the steps to convert Excel to Google Sheets while uploading to Google Drive:
Now, when you upload an Excel file to Google Drive, it will automatically be converted into the Google Sheets format.
If you already have some Excel files in Google Drive, or if you don’t like the idea of Google Drive automatically converting your files to Google Sheets format, this method is for you.
You can choose to convert selected files into the Google Sheets format.
Here are the steps to Convert an Excel file in Google Drive into Google Sheets:
This will open the file in Google Sheets, however, your file in the Google Drive would continue to be in the Excel file format.
You May Also Like the Following Google Sheets Tutorials:
How to Use OR Function in Google Sheets (with Examples)
How to Use IMPORTRANGE Function in Google Sheets (with Examples)
How to Use IMPORTDATA function in Google Sheets
Calculate the Number of Days Between Two Dates in Google Sheets
Using IFS Function in Google Sheets to Test Multiple Conditions