What Happens When You Upload an Excel File to Google Drive?
The state of war betwixt 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 adopt to stay within their Excel comfort zones.
But what happens when an Excel user sends a spreadsheet to a Google Sheets user?
Unless yous have Excel, you can't open and edit it.
If you are i of those Google Sheets loyalists at the receiving end of an Excel document, you lot do have a choice of simply viewing the certificate as it is.
But if you want to piece of 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 volition show you some ways y'all tin apply to open an Excel file in Google Sheets hands.
How to Convert Excel to Google Sheets
Google Sheets tin 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, it needs to commencement exist present in your Google drive. Then 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:
- Open your browser and go to Google Drive by typing drive.google.com in the location bar.
- On the acme left of the Google Drive screen, click on New and and then navigate to File Upload from the drop-down card.
- Select the Excel file yous desire to upload from your computer. Give it a few seconds to upload
The in a higher place steps would add together your Excel file to the drive and at present y'all will be able to open information technology fifty-fifty if you don't have Excel installed on your arrangement.
To view the file content, just double click on it.
At this signal, you lot can merely view the file, but you cannot make any changes to information technology.
If you desire to make changes to it, you need to open up information technology in Google Sheets by clicking on the Open up in Google Docs pick on the top of the screen.
If you lot cannot see this option, don't worry. You tin can however open the fil e in Google Sheets by correct-clicking, then selecting clicking Open up with -> Google Sheets.
At present y'all can edit your file, share and collaborate with others on the data using Google Sheets. This is a very simple style to transfer Excel to Google Sheets.
The all-time office 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
Y'all might desire to not just edit your file in Google Sheets, merely also save information technology in the Google Sheets format instead of the Excel format.
If that is the case, make certain your file is already open in Google sheets, select Save equally Google Sheets from the File menu.
You will at present have 2 copies of the same file – 1 in Excel format and another in Google Sheets format.
So even if yous brand whatsoever changes to this Google Canvas file, your original .xls file will remain unchanged.
How to Automatically Convert all Future Excel File Uploads
You lot can gear up your Google Drive to automatically catechumen subsequent uploads of Excel files to Google Sail format.
This will salve you a lot of fourth dimension if y'all need to often employ Excel files in Google Sheets. You can set this upward as follows:
- Open Google bulldoze.
- Click on the gear icon on the top right.
- Click Settings from the options that show upward.
- In the Settings box, you will see an pick that says " Convert Uploads ". Check the box that says " Convert uploaded files to Google Docs editor format ".
- Click Done .
This volition convert whatever Function files to Google Docs, Sheets or Slides format.
Previously uploaded files, all the same, will non be afflicted by this setting and will continue to exist 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 convert it dorsum to Excel.
This is also quite simple:
If your file is already open in Google Sheets:
- Get to File Download
- Select the Microsoft Excel (.xls) option.
Notice you besides take the option to save this file in other formats such equally PDF, HTML, or CSV. That's one of the things that makes Google Sheets so versatile.
If you want to directly convert the Google Canvass file from your Google drive:
- Right-click on the file'southward icon
- Select the Download choice
Your canvas automatically gets converted to an excel-set format when downloading.
Compatibility Issues
While it'southward smashing 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 yous work with an Excel file that is converted to Google Sheets.
Google is always in the process of self-improvement and is too working on improving its Office editing features.
But in the meantime, though, y'all may run into some compatibility-related issues with certain features.
Before ending the word, hither are a few incompatibility issues that you might run across when trying to convert Excel files to Google Sheets:
- If your file is password protected, it will non 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, Power Query or other Data Model features of Excel
- If your Excel file has macros written in VBA, and so these are non accounted for in Google Sheets. You tin can, even so, write your code in AppScript when working inside Google Sheets.
If your Excel file has whatever of the higher up 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 globe.
However, after 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 available on your regular Google browser completely complimentary of price (all you need is a free Google Account).
- Excel has been around longer, and 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 form)
- Your Google Sheets are saved on your Google Drive, so y'all can admission your files from anywhere using any browser. You don't need any special software to run it.
- Google sheets let you collaborate with others on the same sheet, so you can work with your team-mates in real-time and make changes simultaneously. Yous tin even chat with these collaborators in existent-time.
- When Google Sheets gyre out a new characteristic or functionality, it'south available to all at the same time. Y'all don't have to worry almost versions and astern compatibility of documents with Google Sheets.
- When you work on a Google Sheet, your files get automatically backed up into your Google Bulldoze, so 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, you've learned how to catechumen Excel to Google Sheets and how to transfer Excel to Google Sheets and back again. As you can come across, information technology's quite easy to change formats betwixt the two spreadsheet giants Google Sheets and Excel.
Hope you institute this tutorial useful!
You may also similar the following Google Sheets tutorials:
- Microsoft Excel Vs Google Sheets – Which One is Better + Are they Dissimilar/Same?
- How to Freeze Rows in Google Sheets
- How to Insert CheckBox in Google Sheets
- How to Insert Google Sheets in Google Docs
littleyouserainvid.blogspot.com
Source: https://spreadsheetpoint.com/convert-excel-to-google-sheets/
Post a Comment for "What Happens When You Upload an Excel File to Google Drive?"