How to Upload Excel in Google Sheets
The war betwixt Google Sheets and Excel users rages on. These are two of the near 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 lot can't open and edit it.
If you are one of those Google Sheets loyalists at the receiving end of an Excel document, y'all do accept a option of just viewing the document equally it is.
But if yous want to piece of work on the sent file in your familiar and comfortable Google Sheets surround, you may desire to convert Excel to Google Sheets.
In this tutorial, I will show you some ways you can utilize to open an Excel file in Google Sheets easily.
How to Catechumen Excel to Google Sheets
Google Sheets can piece of work with the following Excel file formats:
- .xls
- .xlsx
- .xlsm
- .xlt
- .ods
- .csv
- .tsv
- .tab
If you demand to open a file in Google Sheets, it needs to first be present in your Google drive. So the first stride to open an Excel file in Google Sheets is to upload information technology to the drive.
To upload an Excel file to your Google Bulldoze, follow the steps below:
- Open your browser and go to Google Bulldoze past typing bulldoze.google.com in the location bar.
- On the summit left of the Google Drive screen, click on New and and then navigate to File Upload from the drop-downward menu.
- Select the Excel file y'all want to upload from your estimator. Give information technology a few seconds to upload
The above steps would add your Excel file to the bulldoze and now yous volition exist able to open up it even if you don't accept Excel installed on your system.
To view the file content, simply double click on it.
At this point, you can only 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 selection on the superlative of the screen.
If you lot cannot see this choice, don't worry. You can nevertheless open the fil e in Google Sheets by correct-clicking, then selecting clicking Open with -> Google Sheets.
At present you tin edit your file, share and interact with others on the information using Google Sheets. This is a very unproblematic style to transfer Excel to Google Sheets.
The best office is, when you salve this file, all changes will exist saved to the original Excel file.
How to Catechumen an Excel File to Google Sheets Format
You lot might want to not just edit your file in Google Sheets, but also salvage it in the Google Sheets format instead of the Excel format.
If that is the case, brand sure your file is already open in Google sheets, select Save as Google Sheets from the File menu.
You will at present have two copies of the same file – one in Excel format and another in Google Sheets format.
Then fifty-fifty if y'all make any changes to this Google Canvass file, your original .xls file volition remain unchanged.
How to Automatically Convert all Future Excel File Uploads
You tin set your Google Bulldoze to automatically convert subsequent uploads of Excel files to Google Sheet format.
This volition relieve you a lot of time if you need to often use Excel files in Google Sheets. You can prepare this upwards as follows:
- Open Google drive.
- Click on the gear icon on the meridian right.
- Click Settings from the options that bear witness upwardly.
- In the Settings box, you will see an option that says " Convert Uploads ". Check the box that says " Convert uploaded files to Google Docs editor format ".
- Click Washed .
This will convert any Part files to Google Docs, Sheets or Slides format.
Previously uploaded files, however, volition not be affected by this setting and will continue to be in the original format.
How to Consign a Google Sheets File to Excel
Finally, when you are done working on your Google Sheets file, you might want to convert it dorsum to Excel.
This is also quite simple:
If your file is already open in Google Sheets:
- Go to File Download
- Select the Microsoft Excel (.xls) option.
Discover you too have the option to save this file in other formats such as PDF, HTML, or CSV. That's one of the things that makes Google Sheets so versatile.
If you want to directly convert the Google Sheet file from your Google drive:
- Right-click on the file's icon
- Select the Download option
Your sheet automatically gets converted to an excel-gear up format when downloading.
Compatibility Problems
While it's bully that you can work with Excel files in Google Sheets, Excel is all the same 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 procedure 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.
Earlier 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 file is password protected, information technology volition not be possible to import it into Google Sheets
- Google Sheets does not business relationship for links in your Excel file to other Workbooks.
- Google Sheets does non support PowerPivot, Ability Query or other Data Model features of Excel
- If your Excel file has macros written in VBA, then these are not accounted for in Google Sheets. You tin, withal, write your code in AppScript when working inside Google Sheets.
If your Excel file has any of the to a higher place elements, either these will be hidden, lost, or worse, altered! Then make sure you go rid of the above features before converting.
Why Apply Google Sheets Instead of Excel?
Microsoft Excel has been effectually for quite a long time and is widely being used in companies and offices all over the world.
However, afterward Google released its counterpart, Google Sheets, a lot of people have started taking a liking to the browser-based spreadsheet platform. Here's why:
- While installation of Microsoft Excel costs $99, Google Sheets are bachelor on your regular Google browser completely costless of cost (all you demand is a costless Google Account).
- Excel has been around longer, and so a lot of people accept gotten accustomed to its interface. Google Sheets has taken a lot of inspiration from Excel and their user interface is clean and intuitive (with fewer functionalities of grade)
- Your Google Sheets are saved on your Google Bulldoze, so yous can access your files from anywhere using any browser. You don't need any special software to run it.
- Google sheets allow y'all collaborate with others on the same sheet, and so you lot can piece of work with your team-mates in existent-time and make changes simultaneously. Yous can fifty-fifty chat with these collaborators in existent-time.
- When Google Sheets roll out a new feature or functionality, it'south available to all at the same fourth dimension. You don't have to worry about versions and backward compatibility of documents with Google Sheets.
- When you piece of work on a Google Sheet, your files get automatically backed upwards into your Google Bulldoze, and so no more oops moments.
- You lot tin can add code and run APIs using Google Sheets, which adds much more flexibility and functionality to how you lot use your data.
In this article, yous've learned how to convert Excel to Google Sheets and how to transfer Excel to Google Sheets and dorsum again. As you can encounter, information technology's quite easy to change formats betwixt the two spreadsheet giants Google Sheets and Excel.
Hope y'all institute this tutorial useful!
You may also similar the post-obit Google Sheets tutorials:
- Microsoft Excel Vs Google Sheets – Which 1 is Better + Are they Different/Same?
- How to Freeze Rows in Google Sheets
- How to Insert CheckBox in Google Sheets
- How to Insert Google Sheets in Google Docs
Source: https://spreadsheetpoint.com/convert-excel-to-google-sheets/
0 Response to "How to Upload Excel in Google Sheets"
Post a Comment