Wmy Excel File Wont Upload to Google Drive
The state of 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 accept Excel, you can't open and edit it.
If y'all are ane of those Google Sheets loyalists at the receiving end of an Excel document, y'all do have a choice of merely 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 catechumen Excel to Google Sheets.
In this tutorial, I will bear witness you some ways yous can use to open an Excel file in Google Sheets hands.
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 lot demand to open a file in Google Sheets, information technology needs to outset be present in your Google drive. Then the first pace to open 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 below:
- Open your browser and go to Google Bulldoze by 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-down bill of fare.
- Select the Excel file y'all want to upload from your reckoner. Give information technology a few seconds to upload
The higher up steps would add together your Excel file to the drive and now y'all will be able to open up information technology fifty-fifty if you don't accept Excel installed on your arrangement.
To view the file content, simply double click on it.
At this signal, y'all can just view the file, but you cannot make any changes to information technology.
If y'all want to brand changes to it, you need to open up it in Google Sheets past clicking on the Open in Google Docs option on the peak of the screen.
If you cannot see this option, don't worry. You can still open the fil e in Google Sheets past right-clicking, then selecting clicking Open with -> Google Sheets.
Now you lot 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 lot 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 just edit your file in Google Sheets, but as well relieve information technology in the Google Sheets format instead of the Excel format.
If that is the instance, brand sure your file is already open in Google sheets, select Save as Google Sheets from the File bill of fare.
Yous volition now take ii copies of the same file – ane in Excel format and another in Google Sheets format.
So even if yous make whatever changes to this Google Sheet file, your original .xls file will remain unchanged.
How to Automatically Convert all Future Excel File Uploads
You 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 frequently use Excel files in Google Sheets. Yous can fix this up equally follows:
- Open Google drive.
- Click on the gear icon on the top right.
- Click Settings from the options that testify up.
- In the Settings box, you lot will see an option that says " Catechumen Uploads ". Bank check the box that says " Convert uploaded files to Google Docs editor format ".
- Click Done .
This will convert any Function files to Google Docs, Sheets or Slides format.
Previously uploaded files, however, will non be affected by this setting and will continue to exist in the original format.
How to Export a Google Sheets File to Excel
Finally, when yous are done working on your Google Sheets file, you might desire to convert it back to Excel.
This is besides quite simple:
If your file is already open in Google Sheets:
- Go to File Download
- Select the Microsoft Excel (.xls) selection.
Detect you as well have the choice 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 catechumen the Google Canvass file from your Google bulldoze:
- Correct-click on the file'due south icon
- Select the Download option
Your sheet automatically gets converted to an excel-set up format when downloading.
Compatibility Issues
While it's great that you tin work with Excel files in Google Sheets, Excel is even so a lot more feature-rich. Google Sheets lacks a lot of functionalities and you may have some compatibility problems when y'all work with an Excel file that is converted to Google Sheets.
Google is ever in the process of self-improvement and is also working on improving its Office editing features.
Only in the meantime, though, y'all may meet some compatibility-related problems with certain features.
Earlier catastrophe the discussion, hither are a few incompatibility issues that yous might run across when trying to convert Excel files to Google Sheets:
- If your file is countersign protected, information technology will not be possible to import information technology into Google Sheets
- Google Sheets does not business relationship 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 deemed for in Google Sheets. You tin, even so, write your code in AppScript when working inside Google Sheets.
If your Excel file has whatever of the to a higher place elements, either these volition exist hidden, lost, or worse, contradistinct! Then make certain you lot become rid of the above features before converting.
Why Use Google Sheets Instead of Excel?
Microsoft Excel has been around for quite a long fourth dimension and is widely beingness used in companies and offices all over the world.
Nevertheless, after Google released its counterpart, Google Sheets, a lot of people accept started taking a liking to the browser-based spreadsheet platform. Hither'south why:
- While installation of Microsoft Excel costs $99, Google Sheets are bachelor on your regular Google browser completely complimentary of cost (all you need is a gratis Google Account).
- Excel has been around longer, and so a lot of people have gotten accepted to its interface. Google Sheets has taken a lot of inspiration from Excel and their user interface is make clean and intuitive (with fewer functionalities of course)
- Your Google Sheets are saved on your Google Drive, so y'all can access your files from anywhere using any browser. You don't demand whatever special software to run it.
- Google sheets let y'all collaborate with others on the same canvass, then you can work with your team-mates in real-fourth dimension and make changes simultaneously. Yous tin fifty-fifty chat with these collaborators in real-time.
- When Google Sheets roll out a new feature or functionality, information technology'due south bachelor to all at the same time. You don't have to worry near versions and backward compatibility of documents with Google Sheets.
- When y'all work on a Google Sheet, 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 yous utilise 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 over again. As you can encounter, information technology's quite easy to change formats between the two spreadsheet giants Google Sheets and Excel.
Hope you found this tutorial useful!
You may as well like the following Google Sheets tutorials:
- Microsoft Excel Vs Google Sheets – Which One is Amend + Are they Unlike/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/