Excel and Google Sheets are two immensely popular spreadsheet tools presently in prevail. Although both of them maintain a rivalry, they have a fair share of customer community supporting them along and at times instances come up in which a user may end up with an excel file that he or she would like to have in Google Sheets. It is thus, extremely important to know more about how an excel file can be converted into a Google Sheet.
It is a general conviction that a user has to have a working excel application to open and read an excel file that was sent his or her way. But several workarounds can be employed to convert an excel file into google Sheets. Some of them involve direct conversion whereas several others include other applications like Google Drive.
Why converting an excel file to Google Sheets is important because the receiver may not be quite familiar with the working of the excel application and thus, would prefer to work the document with the familiarity of Google Sheets. Also, the Google Sheets are better suitable for collaborations and the receiver may be part of an enterprise.
Having said that, certain inherent and essential downfalls can occur while converting an excel file to Google Sheet. One such downside is that it may take quite a while for the excel file to be completely converted to a Google Sheet also, it is a known fact that Google Sheets have limited visualization tools when compared to excel and thus, some of the advanced information and formulas in the excel file may find it difficult to be reproduced in Google Sheets.
How to convert excel to Google Sheets?
One of the fastest and easiest ways to convert an excel file is to try to open it in a Google Sheet itself.
Step 1. Open the Google Sheet application on the device.
STEP 2. Click on the file option at the top menu bar.
Step 3. From the drop-down menu, click on the import/upload option.
Step 4. On the window that opens, choose the file that has to be imported or uploaded.
Step 5. Click on the Select option at the bottom of the window, once a file is chosen.
Step 6. A dialogue box appears which contains options for customization.
Step 7. The user can choose the import location of the spreadsheet.
Step 8. Click on the Import Data option at the bottom.
Step 9. The file is imported successfully and a message intimating the same will appear on the screen.
Step 10. Click on the Open Now option to view the created Google Sheet.
Step 11. The excel file has converted successfully to a Google Sheet.
Another extremely easiest way to convert excel to Google Sheets is to directly open the received excel file with the Google Sheets option for editing and then afterward, save the edited copy in Google Sheets.
Step 1. Open the Gmail application on the device.
Step 2. Click open the email which contains the excel file.
Step 3. Move the cursor over the received file and click on the Edit with Google Sheets option.
Step 4. The excel file is immediately opened in Google Sheets and the user can save the sheet in Google Sheets itself after necessary edits if needed.
If any of the above-mentioned methods work out or were not possible to carry out on your device, there is another easy method to convert an excel file to Google Sheets via Google Drive.
Step 1. Open the Gmail application on the device and click open the email that has the excel file attached to it.
Step 2. Download the file to the device.
Step 3. Open Google Drive on the device.
Step 4. Click on the New option that is present at the top left part of the Drive window.
Step 5. From the drop-down menu that appears, click on the File Upload option.
Step 6. Find and choose the excel file that you have already downloaded.
Step 7. Upload the file and once the uploading is finished, a notification appears on the right bottom corner of the screen intimating the same.
Step 8. The file is now available in the Google Drive home.
Step 9. Right-click on the uploaded file. From the drop-down menu that appears, click on the Open With option.
Step 10. From the options, click on the Google Sheets option.
The file is now successfully converted to Google Sheets.