How to Convert Excel File to Google Sheets Automatically (3 Ways)

If you are looking for a way to convert your Excel file to Google Sheets then you have come to the right place. The objective of this article is to explain how to convert Excel file to Google Sheets automatically.


Download Practice Workbook

You can download the practice workbook from here.


3 Simple Ways to Convert Excel File to Google Sheets Automatically

Here, I have taken the following worksheet to explain this article. Now, I will show you how you can convert this Excel file to Google Sheets automatically in 3 simple ways.

Dataset to Convert Excel File to Google Sheets Automatically


1. Convert Excel to Google Sheets Automatically Using Google Drive and Google Sheets

In this first method, I will use both Google Drive and Google Sheets to convert Excel files to Google Sheets automatically. Let’s see the steps.

Steps:

  • Firstly, open Google Drive.
  • Secondly, select New.

Convert Excel to Google Sheets Automatically Using Google Drive and Google Sheets

  • Thirdly, select File Upload.

Uploding New File to Google Drive to Convert Excel to Google Sheets Automatically

  • After that, the File Upload dialog box will appear.
  • Select the Excel file you want to convert.
  • Then, select Open.

File Upload Dialog Box to Convert Excel to Google Sheets Automatically

  • Next, you will see that the Excel file is uploaded to your Google Drive. But, it is still in Excel format.

  • Afterward, Right-click on the Excel file.
  • Then, select Open with.
  • After that, select Google Sheets.

  • Now, you will see that you have opened the file in Google Sheets. But, the file is still an XLSX file.

XLSX file Opened in Google Sheets to Convert Excel File Automatically

  • Now, I will change the format of the file.
  • To do so, select the File tab.
  • Then, select Save as Google Sheets.

  • Finally, you will see that you have converted the file to Google Sheets.

  • Now, you can go back to your Google Drive and you will see that the file is saved in Google Sheets format.

Read More: How to Convert Excel Sheet to Google Sheets (3 Easy Ways)


2. Employ Only Google Drive to Transform Excel to Google Sheets Automatically

The method I used before is fine for a file or two but if you want to convert files frequently then this method will be very helpful. Here, I will convert Excel files to Google Sheets automatically by using Google Drive only. Let’s see how it is done.

Steps:

  • In the beginning, open Google Drive.
  • Then, click on the Settings button.
  • After that, a drop-down menu will appear.
  • Select Settings from the drop-down menu.

Employ Only Google Drive to Transform Excel to Google Sheets Automatically

  • Next, check the Convert uploads to Google Docs editor format option.

Changing Settings of Google Drive to Convert Excel to Google Sheets Automatically

  • After that, follow the steps from Method-1 to upload the Excel file you want to convert.
  • Finally, you will see that the file is converted to Google Sheets automatically.

Read More: How to Import Data from Excel to Google Sheets (2 Easy Ways)


Similar Readings


3. Utilize Google Sheets to Convert Excel to Google Sheets Automatically

You can also use Google Sheets to convert Excel to Google Sheets automatically. Here, I will start with Google Sheets and then import the file I want to convert. There are 2 ways in which you can import the file one is from your device and another is from your drive.


3.1. Upload from Device

Here, I will import an Excel file from the device to convert it to Google Sheets automatically. Let’s see the steps.

Steps:

  • First, open a new spreadsheet in Google Sheets.
  • Then, select the File tab.
  • Next, select Import.

Utilize Google Sheets to Convert Excel to Google Sheets Automatically

  • Here, the Import file dialog box will appear.
  • Select Upload.
  • Afterward, click on Select a file from your device.

  • Consequently, the File Upload dialog box will appear.
  • Then, select Open.

  • Next, another dialog box named Import file will appear.
  • After that, click on the drop-down option for the Import location.

  • Subsequently, a drop-down menu will appear.
  • Select Create new spreadsheet from the drop-down menu.

  • After that, select Import data.

  • Then, the file will be converted to Google Sheets.
  • Next, select Open now to open the file.

  • Finally, you can see that I have converted the Excel file to Google Sheets. And, this is how the file looks in Google Sheets.


3.2. Import from Drive

In this method, I will import an Excel file from Google Drive to convert it to Google sheets. Let me show you the steps.

Steps:

  • Firstly, open a new spreadsheet in Google Sheets.
  • Secondly, go to the File tab.
  • Thirdly, select Import.

Import from Drive

  • Then, the Import file dialog box will appear.
  • Select My Drive.
  • After that, select the Excel file you want to convert from your Google Drive.
  • Next, click on Select.

  • Consequently, the Import file dialog box will appear.
  • Select Create new spreadsheet as Import location.
  • Then, select Import data.

  • After that, the file will be converted to Google Sheets.
  • Then, select Open now to open the file.

  • In the end, you will see that you have converted the Excel File to Google Sheets successfully.

Read More: IMPORTRANGE Function to Import Data from Excel to Google Sheets


How to Convert Google Sheets to Excel

In the previous methods, I explained how you can convert Excel to Google Sheets. Now, I will explain how to convert Google Sheets to Excel. The process is quite simple. To explain this section, I have taken the following Google Sheet. I will convert this spreadsheet to Excel.

How to Convert Google Sheets to Excel

Let’s see the steps.

Steps:  

  • To begin with, select the File tab.
  • Next, select Download.
  • Then, select Microsoft Excel (.xlsx).

  • After that, you will see that you have downloaded the file as Excel.

  • Finally, I opened the file, and this is how the file looks after converting it to Excel.

Read More: 10 Key Differences Between Google Sheets and Excel


Things to Remember

  • It should be noted that you will not be able to import password-protected files to Google Sheets.
  • Google Sheets does not support all the functionality of Excel. So, you might face problems while converting Excel files with advanced functionality. You can simply avoid this problem by removing the feature from your Excel file that is causing the problem.

Practice Section

Here, I have provided a practice sheet for you to practice how to convert Excel files to Google Sheets automatically.

Practice Sheet for How to Convert Excel to Google Sheets Automatically


Conclusion

So, you have reached the end of my article. Here, I tried to explain how to convert Excel files to Google Sheets automatically in 3 different methods. I also tried to explain how you can convert Google Sheets to Excel. For more articles, stay connected with ExcelDemy. Lastly, if you have any questions, feel free to let me know in the comment section below.


Related Articles

Mashhura

Mashhura

Hey! Welcome to my profile. Right now, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo