How to Upload Excel Files Inot Google Drive
The war between Google Sheets and Excel users rages on. These are two of the virtually pop spreadsheet programs. Those who are comfortable using Google sheets swear by information technology, while Excel lovers prefer to stay inside their Excel condolement zones.
But 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 are 1 of those Google Sheets loyalists at the receiving end of an Excel certificate, you practice have a pick of merely viewing the certificate as information technology is.
But if you lot desire to work on the sent file in your familiar and comfortable Google Sheets surround, you may want to convert Excel to Google Sheets.
In this tutorial, I volition show y'all some means y'all can use to open an Excel file in Google Sheets easily.
How to Convert Excel to Google Sheets
Google Sheets can work with the following Excel file formats:
- .xls
- .xlsx
- .xlsm
- .xlt
- .ods
- .csv
- .tsv
- .tab
If you need to open a file in Google Sheets, information technology needs to first be present in your Google drive. And so the first stride 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:
- Open up your browser and get to Google Drive past typing drive.google.com in the location bar.
- On the top left of the Google Drive screen, click on New and then navigate to File Upload from the drop-downwardly menu.
- Select the Excel file you want to upload from your computer. Give it a few seconds to upload
The above steps would add your Excel file to the bulldoze and now you will be able to open up it even if y'all don't accept Excel installed on your system.
To view the file content, simply double click on it.
At this bespeak, you can just view the file, just y'all cannot brand any changes to information technology.
If y'all want to make changes to it, you need to open information technology in Google Sheets by clicking on the Open in Google Docs pick on the elevation of the screen.
If you cannot come across this pick, don't worry. You tin notwithstanding open the fil e in Google Sheets by right-clicking, then selecting clicking Open up with -> Google Sheets.
Now you tin edit your file, share and collaborate with others on the data using Google Sheets. This is a very unproblematic mode to transfer Excel to Google Sheets.
The all-time role is, when y'all save this file, all changes will be saved to the original Excel file.
How to Convert an Excel File to Google Sheets Format
Y'all might want to not just edit your file in Google Sheets, only as well salve it in the Google Sheets format instead of the Excel format.
If that is the example, brand 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 some other in Google Sheets format.
So even if you make any changes to this Google Sheet file, your original .xls file volition remain unchanged.
How to Automatically Catechumen all Future Excel File Uploads
You can set your Google Drive to automatically convert subsequent uploads of Excel files to Google Canvas format.
This will salve you lot a lot of fourth dimension if you demand to oftentimes employ Excel files in Google Sheets. You tin set this up as follows:
- Open Google bulldoze.
- Click on the gear icon on the top correct.
- Click Settings from the options that show up.
- In the Settings box, you will encounter an option that says " Catechumen Uploads ". Check the box that says " Convert uploaded files to Google Docs editor format ".
- Click Done .
This will convert whatsoever Office files to Google Docs, Sheets or Slides format.
Previously uploaded files, even so, volition not be affected by this setting and will continue to be in the original format.
How to Export a Google Sheets File to Excel
Finally, when you are done working on your Google Sheets file, you might want 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) selection.
Notice you also have the selection to salvage this file in other formats such every bit PDF, HTML, or CSV. That'south one of the things that makes Google Sheets and so versatile.
If y'all want to direct convert the Google Sheet file from your Google bulldoze:
- Right-click on the file's icon
- Select the Download option
Your sheet automatically gets converted to an excel-set format when downloading.
Compatibility Issues
While information technology'due south bang-up that you can work with Excel files in Google Sheets, Excel is nevertheless a lot more characteristic-rich. Google Sheets lacks a lot of functionalities and you may accept some compatibility issues when y'all work with an Excel file that is converted to Google Sheets.
Google is always in the process of cocky-comeback and is besides working on improving its Role editing features.
Just in the meantime, though, you lot may run across some compatibility-related issues with sure features.
Before ending the discussion, here are a few incompatibility issues that you lot might come across when trying to catechumen Excel files to Google Sheets:
- If your file is password protected, it will not be possible to import it into Google Sheets
- Google Sheets does not account for links in your Excel file to other Workbooks.
- Google Sheets does not 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. Y'all can, however, write your code in AppScript when working within Google Sheets.
If your Excel file has any of the to a higher place elements, either these will be subconscious, lost, or worse, contradistinct! So make sure you get rid of the to a higher place 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.
Yet, afterwards Google released its counterpart, Google Sheets, a lot of people have started taking a liking to the browser-based spreadsheet platform. Hither'southward 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 gratuitous Google Account).
- Excel has been effectually longer, and so a lot of people have 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 course)
- Your Google Sheets are saved on your Google Bulldoze, so you tin access your files from anywhere using any browser. Yous don't demand any special software to run it.
- Google sheets allow you lot collaborate with others on the same sheet, so you can piece of work with your team-mates in existent-fourth dimension and brand changes simultaneously. You can even chat with these collaborators in existent-time.
- When Google Sheets roll out a new feature or functionality, it'southward bachelor to all at the aforementioned time. You lot don't take 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 up into your Google Drive, then no more oops moments.
- You can add together code and run APIs using Google Sheets, which adds much more flexibility and functionality to how you use your data.
In this article, you've learned how to convert Excel to Google Sheets and how to transfer Excel to Google Sheets and dorsum once again. As you tin see, it's quite piece of cake to alter formats between the two spreadsheet giants Google Sheets and Excel.
Promise you establish this tutorial useful!
Yous may also like the post-obit Google Sheets tutorials:
- Microsoft Excel Vs Google Sheets – Which One 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 Files Inot Google Drive"
Post a Comment