Upload an Excel Doc to Google Sheets
The war betwixt Google Sheets and Excel users rages on. These are two of the most popular spreadsheet programs. Those who are comfy using Google sheets swear by it, while Excel lovers adopt to stay within their Excel comfort zones.
Simply what happens when an Excel user sends a spreadsheet to a Google Sheets user?
Unless you have Excel, you can't open and edit it.
If you lot are 1 of those Google Sheets loyalists at the receiving end of an Excel certificate, yous do have a selection of simply viewing the document as information technology is.
But if you desire to piece of work on the sent file in your familiar and comfy Google Sheets environment, you may want to catechumen Excel to Google Sheets.
In this tutorial, I will show yous some ways yous can use to open an Excel file in Google Sheets hands.
How to Catechumen Excel to Google Sheets
Google Sheets can work with the post-obit Excel file formats:
- .xls
- .xlsx
- .xlsm
- .xlt
- .ods
- .csv
- .tsv
- .tab
If you need to open a file in Google Sheets, it needs to first be present in your Google drive. And so the first stride to open up an Excel file in Google Sheets is to upload it to the drive.
To upload an Excel file to your Google Bulldoze, follow the steps beneath:
- Open your browser and go to Google Drive by typing drive.google.com in the location bar.
- On the peak left of the Google Drive screen, click on New and and then navigate to File Upload from the drib-downward bill of fare.
- Select the Excel file you lot want to upload from your computer. Give it a few seconds to upload
The above steps would add your Excel file to the drive and now you will be able to open information technology fifty-fifty if you don't have Excel installed on your organisation.
To view the file content, simply double click on it.
At this point, you can just view the file, but yous cannot make whatsoever changes to it.
If you desire to make changes to it, y'all demand to open it in Google Sheets by clicking on the Open in Google Docs option on the meridian of the screen.
If you cannot see this option, don't worry. You can still open the fil e 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 information using Google Sheets. This is a very unproblematic 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 Format
You might want to not merely edit your file in Google Sheets, only likewise salvage it in the Google Sheets format instead of the Excel format.
If that is the instance, make sure your file is already open in Google sheets, select Save every bit Google Sheets from the File carte.
You lot will now have two copies of the same file – one in Excel format and some other in Google Sheets format.
So even if you brand any changes to this Google Sheet file, your original .xls file will remain unchanged.
How to Automatically Convert all Future Excel File Uploads
You tin can ready your Google Drive to automatically catechumen subsequent uploads of Excel files to Google Canvas format.
This will relieve you lot a lot of time if you need to often employ Excel files in Google Sheets. You can set this up as follows:
- Open Google drive.
- Click on the gear icon on the pinnacle right.
- Click Settings from the options that show upward.
- 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 catechumen any Function files to Google Docs, Sheets or Slides format.
Previously uploaded files, however, will not be affected by this setting and will keep to exist in the original format.
How to Export a Google Sheets File to Excel
Finally, when yous are washed working on your Google Sheets file, yous might desire to catechumen it back 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.
Notice you besides have the option to save this file in other formats such equally PDF, HTML, or CSV. That'southward 1 of the things that makes Google Sheets and so versatile.
If you want to direct convert the Google Sheet file from your Google drive:
- Right-click on the file'due south icon
- Select the Download selection
Your canvas automatically gets converted to an excel-ready format when downloading.
Compatibility Problems
While information technology's great that you tin work with Excel files in Google Sheets, Excel is still a lot more characteristic-rich. Google Sheets lacks a lot of functionalities and y'all may accept some compatibility issues when you piece of work with an Excel file that is converted to Google Sheets.
Google is e'er in the procedure of cocky-improvement and is also working on improving its Part editing features.
But in the meantime, though, y'all may encounter some compatibility-related problems with sure features.
Before ending the discussion, here are a few incompatibility issues that y'all might come across when trying to catechumen Excel files to Google Sheets:
- If your file is password protected, information technology will non 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, Power Query or other Data Model features of Excel
- If your Excel file has macros written in VBA, then these are non accounted for in Google Sheets. You can, nonetheless, write your code in AppScript when working within 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 earlier 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 take started taking a liking to the browser-based spreadsheet platform. Hither's why:
- While installation of Microsoft Excel costs $99, Google Sheets are available on your regular Google browser completely free of toll (all you need is a complimentary Google Account).
- Excel has been around longer, then a lot of people take gotten accepted 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 course)
- Your Google Sheets are saved on your Google Drive, so you lot tin admission your files from anywhere using whatever browser. Yous don't need whatever special software to run information technology.
- Google sheets let you lot collaborate with others on the same sheet, and then you lot tin work with your team-mates in real-time and make changes simultaneously. You can even chat with these collaborators in existent-time.
- When Google Sheets curl out a new feature or functionality, it's available to all at the same time. You don't have to worry nigh versions and backward compatibility of documents with Google Sheets.
- When yous piece of work on a Google Canvass, your files get automatically backed up into your Google Bulldoze, and then no more oops moments.
- You tin 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 catechumen Excel to Google Sheets and how to transfer Excel to Google Sheets and back again. As you tin see, it'south quite piece of cake to change formats betwixt the two spreadsheet giants Google Sheets and Excel.
Promise you plant this tutorial useful!
You may as well like the following Google Sheets tutorials:
- Microsoft Excel Vs Google Sheets – Which One is Better + Are they Different/Aforementioned?
- 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 "Upload an Excel Doc to Google Sheets"
Post a Comment