Upload Excel as Google Sheet to Box
The war between Google Sheets and Excel users rages on. These are two of the almost popular spreadsheet programs. Those who are comfortable using Google sheets swear by it, while Excel lovers adopt to stay inside their Excel comfort 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 one of those Google Sheets loyalists at the receiving end of an Excel certificate, you practice accept a selection of just viewing the certificate as it is.
But if you lot desire to 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 will prove yous some ways y'all can use to open up an Excel file in Google Sheets easily.
How to Catechumen Excel to Google Sheets
Google Sheets tin can work with the post-obit Excel file formats:
- .xls
- .xlsx
- .xlsm
- .xlt
- .ods
- .csv
- .tsv
- .tab
If you need to open up a file in Google Sheets, it needs to kickoff exist present in your Google drive. So the beginning 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 up your browser and go to Google Bulldoze past typing bulldoze.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 bill of fare.
- Select the Excel file y'all desire to upload from your computer. Requite it a few seconds to upload
The in a higher place steps would add your Excel file to the drive and now you will be able to open it even if you lot don't have Excel installed on your system.
To view the file content, merely double click on it.
At this point, you can just view the file, but you cannot brand any changes to information technology.
If you want to make changes to information technology, you need to open it in Google Sheets by clicking on the Open in Google Docs option on the meridian of the screen.
If yous cannot run across this option, don't worry. You tin can however open up the fil e in Google Sheets past right-clicking, and so selecting clicking Open with -> Google Sheets.
Now yous tin can edit your file, share and collaborate with others on the data using Google Sheets. This is a very simple 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 non just edit your file in Google Sheets, just also relieve it in the Google Sheets format instead of the Excel format.
If that is the case, make sure your file is already open in Google sheets, select Salvage as Google Sheets from the File menu.
You will now accept two copies of the aforementioned file – 1 in Excel format and some other in Google Sheets format.
And then even if you brand any changes to this Google Canvas file, your original .xls file will remain unchanged.
How to Automatically Convert all Hereafter Excel File Uploads
You lot tin can set your Google Drive to automatically convert subsequent uploads of Excel files to Google Sheet format.
This will relieve yous a lot of time if you demand to oft utilise Excel files in Google Sheets. You can set this upwards as follows:
- Open up Google drive.
- Click on the gear icon on the top right.
- Click Settings from the options that show up.
- In the Settings box, you will encounter an option that says " Convert Uploads ". Check the box that says " Convert uploaded files to Google Docs editor format ".
- Click Done .
This volition convert any Office files to Google Docs, Sheets or Slides format.
Previously uploaded files, even so, will not be affected by this setting and will keep 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 desire to convert information technology dorsum to Excel.
This is as well quite simple:
If your file is already open in Google Sheets:
- Become to File Download
- Select the Microsoft Excel (.xls) pick.
Notice you also take the pick to salve this file in other formats such as PDF, HTML, or CSV. That'south 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 canvass automatically gets converted to an excel-ready format when downloading.
Compatibility Issues
While it's smashing that y'all can work with Excel files in Google Sheets, Excel is nonetheless 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 ever in the process of self-improvement and is also working on improving its Function editing features.
But in the meantime, though, you lot may meet some compatibility-related issues with certain features.
Before ending the discussion, here are a few incompatibility issues that y'all might come beyond when trying to convert 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 non business relationship for links in your Excel file to other Workbooks.
- Google Sheets does not back up PowerPivot, Power Query or other Data Model features of Excel
- If your Excel file has macros written in VBA, so these are non accounted for in Google Sheets. You can, however, 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! So make sure you lot get rid of the in a higher place features before converting.
Why Utilize 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.
Nonetheless, later on Google released its analogue, 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 gratis of cost (all you need is a free Google Account).
- Excel has been around 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 make clean and intuitive (with fewer functionalities of course)
- 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 let yous collaborate with others on the aforementioned sheet, so y'all can work with your team-mates in existent-time and make changes simultaneously. You can fifty-fifty chat with these collaborators in real-time.
- When Google Sheets roll out a new feature or functionality, information technology's available to all at the same time. You don't have to worry about versions and backward compatibility of documents with Google Sheets.
- When yous piece of work on a Google Canvas, your files get automatically backed upward 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 yous use your information.
In this article, you've learned how to convert Excel to Google Sheets and how to transfer Excel to Google Sheets and dorsum again. Every bit yous can come across, it'southward quite easy to change formats between the two spreadsheet giants Google Sheets and Excel.
Hope you found this tutorial useful!
You may also like the following Google Sheets tutorials:
- Microsoft Excel Vs Google Sheets – Which One is Amend + Are they Dissimilar/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 Excel as Google Sheet to Box"
ارسال یک نظر