Mashhura Jahan
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.
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:
- Thirdly, select File Upload.
- After that, the File Upload dialog box will appear.
- Select the Excel file you want to convert.
- Then, select Open.
- 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.
- 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.
- Next, check the Convert uploads to Google Docs editor format option.
- 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
- How to Copy from Excel to Google Sheets (4 Easy Methods)
- Pros and Cons of Google Sheets vs Excel – Which Will Be Better?
- How to Copy from Excel and Paste to Google Sheets with Formulas
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.
- 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.
- 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.
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.
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.
