Home » How to Convert Excel to Google Sheets (Step-by-Step) Show
How to Convert Excel to Google Sheets (Step-by-Step)The war between Google Sheets and Excel users rages on. These are two of the most popular spreadsheet programs. Those who are comfortable using Google sheets swear by it, while Excel lovers prefer to stay within their Excel comfort zones. But what happens when an Excel user sends a spreadsheet to a Google Sheets user? Unless you have Excel, you cant open and edit it. If you are one of those Google Sheets loyalists at the receiving end of an Excel document, you do have a choice of just viewing the document as it is. But if you want to work on the sent file in your familiar and comfortable Google Sheets environment, you may want to convert Excel to Google Sheets. In this tutorial, I will show you some ways you can use to open an Excel file in Google Sheets easily. Table of Contents
How to Convert Excel to Google SheetsGoogle Sheets can work with the following Excel file formats:
If you need to open a file in Google Sheets, it needs to first be present in your Google drive. So the first step to open an Excel file in Google Sheets is to upload it to the drive. To upload an Excel file to your Google Drive, follow the steps below:
The above steps would add your Excel file to the drive and now you will be able to open it even if you dont have Excel installed on your system. To view the file content, simply double click on it. At this point, you can just view the file, but you cannot make any changes to it. If you want to make changes to it, you need to open it in Google Sheets by clicking on the Open in Google Docs option on the top of the screen. If you cannot see this option, dont worry. You can still open the file in Google Sheets by right-clicking, then selecting clicking Open with -> Google Sheets. Now you can edit your file, share and collaborate with others on the data using Google Sheets. This is a very simple way to transfer Excel to Google Sheets. The best part is, when you save this file, all changes will be saved to the original Excel file. How to Convert an Excel File to Google Sheets FormatYou might want to not just edit your file in Google Sheets, but also save it in the Google Sheets format instead of the Excel format. If that is the case, make sure your file is already open in Google sheets, select Save as Google Sheets from the File menu. You will now have two copies of the same file one in Excel format and another in Google Sheets format. So even if you make any changes to this Google Sheet file, your original .xls file will remain unchanged. How to Automatically Convert all Future Excel File UploadsYou can set your Google Drive to automatically convert subsequent uploads of Excel files to Google Sheet format. This will save you a lot of time if you need to often use Excel files in Google Sheets. You can set this up as follows:
This will convert any Office files to Google Docs, Sheets or Slides format. Previously uploaded files, however, will not be affected by this setting and will continue to be in the original format. How to Export a Google Sheets File to ExcelFinally, when you are done working on your Google Sheets file, you might want to convert it back to Excel. This is also quite simple: If your file is already open in Google Sheets:
Notice you also have the option to save this file in other formats such as PDF, HTML, or CSV. Thats one of the things that makes Google Sheets so versatile. If you want to directly convert the Google Sheet file from your Google drive:
Your sheet automatically gets converted to an excel-ready format when downloading. Compatibility IssuesWhile its great that you can work with Excel files in Google Sheets, Excel is still a lot more feature-rich. Google Sheets lacks a lot of functionalities and you may have some compatibility issues when you work with an Excel file that is converted to Google Sheets. Google is always in the process of self-improvement and is also working on improving its Office editing features. But in the meantime, though, you may encounter some compatibility-related issues with certain features. Before ending the discussion, here are a few incompatibility issues that you might come across when trying to convert Excel files to Google Sheets:
If your Excel file has any of the above elements, either these will be hidden, lost, or worse, altered! So make sure you get rid of the above features before converting. Why Use Google Sheets Instead of Excel?Microsoft Excel has been around for quite a long time and is widely being used in companies and offices all over the world. However, after Google released its counterpart, Google Sheets, a lot of people have started taking a liking to the browser-based spreadsheet platform. Heres why:
In this article, youve learned how to convert Excel to Google Sheets and how to transfer Excel to Google Sheets and back again. As you can see, its quite easy to change formats between the two spreadsheet giants Google Sheets and Excel. Hope you found this tutorial useful! You may also like the following Google Sheets tutorials:
Related posts:How to Insert BULLET POINTS in Google Sheets How to Insert the Euro Symbol () in Google Sheets (5 Easy Ways) How to Underline in Google Sheets (Shortcut) How to Use SUMIFS Function in Google Sheets (Multiple Criteria) SumitGoogle Sheets and Microsoft Excel Expert. 4 thoughts on How to Convert Excel to Google Sheets (Step-by-Step)
Leave a Comment Cancel replyComment Name Email WebsiteSave my name, email, and website in this browser for the next time I comment.
Best Online Google Sheets CoursesBecome a Google Sheets expert today! View Course |