How to Upload Excel Files as Csv to Google Drive
The 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 past information technology, while Excel lovers prefer to stay inside 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 up and edit it.
If yous are one of those Google Sheets loyalists at the receiving end of an Excel certificate, you lot practice accept a choice of only viewing the document equally it is.
Simply if you want 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 show you some ways you can apply 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 lot need to open a file in Google Sheets, it needs to offset be nowadays in your Google drive. And so 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 Bulldoze, follow the steps below:
- Open your browser and get to Google Bulldoze by typing drive.google.com in the location bar.
- On the elevation left of the Google Drive screen, click on New and then navigate to File Upload from the driblet-down bill of fare.
- Select the Excel file you want to upload from your computer. Give 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 fifty-fifty if you don't take Excel installed on your system.
To view the file content, only double click on it.
At this point, you tin can just view the file, but yous cannot make whatever changes to information technology.
If you want to make changes to it, you lot need to open up it in Google Sheets by clicking on the Open in Google Docs option on the top of the screen.
If you cannot see this option, don't worry. Y'all tin can still open the fil e in Google Sheets by right-clicking, and then selecting clicking Open up with -> Google Sheets.
At present yous tin 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 salvage this file, all changes will be saved to the original Excel file.
How to Catechumen an Excel File to Google Sheets Format
You might want to not just edit your file in Google Sheets, but too save 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 Salve as Google Sheets from the File menu.
You will now have two copies of the aforementioned file – i in Excel format and another in Google Sheets format.
And so even if y'all brand any changes to this Google Canvass 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 Canvass format.
This volition save y'all a lot of time if you lot need to oft use Excel files in Google Sheets. You can set this upwardly 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, yous volition see an option that says " Convert Uploads ". Check the box that says " Catechumen uploaded files to Google Docs editor format ".
- Click Done .
This will convert any Office files to Google Docs, Sheets or Slides format.
Previously uploaded files, however, will not be affected past this setting and will continue to be 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 want to convert it back to Excel.
This is besides quite elementary:
If your file is already open in Google Sheets:
- Go to File Download
- Select the Microsoft Excel (.xls) option.
Notice y'all besides have the option to save this file in other formats such as PDF, HTML, or CSV. That's 1 of the things that makes Google Sheets and so versatile.
If y'all desire to directly convert the Google Sheet file from your Google drive:
- Right-click on the file's icon
- Select the Download selection
Your canvass automatically gets converted to an excel-fix format when downloading.
Compatibility Issues
While it's great 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 y'all may take some compatibility issues when you work with an Excel file that is converted to Google Sheets.
Google is always in the process of cocky-improvement and is too working on improving its Office editing features.
But in the concurrently, though, you may meet some compatibility-related issues with certain features.
Before catastrophe the give-and-take, here are a few incompatibility problems that you might come up across when trying to convert Excel files to Google Sheets:
- If your file is countersign protected, it volition not exist 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 not support PowerPivot, Power Query or other Information Model features of Excel
- If your Excel file has macros written in VBA, then 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 whatever of the above elements, either these will be hidden, lost, or worse, altered! So brand certain you get rid of the in 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 existence used in companies and offices all over the earth.
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 free of cost (all you need is a costless Google Account).
- Excel has been around longer, then 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 Drive, so y'all tin can access your files from anywhere using whatsoever browser. Yous don't demand any special software to run it.
- Google sheets permit yous collaborate with others on the aforementioned sheet, so you can work with your team-mates in real-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 you work on a Google Sail, your files go automatically backed upwardly into your Google Drive, then no more than oops moments.
- Yous 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 convert Excel to Google Sheets and how to transfer Excel to Google Sheets and back once again. As y'all tin encounter, it's quite easy to modify formats between the 2 spreadsheet giants Google Sheets and Excel.
Promise you constitute this tutorial useful!
You may also like the post-obit Google Sheets tutorials:
- Microsoft Excel Vs Google Sheets – Which One is Ameliorate + 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/#:~:text=Open%20your%20browser%20and%20go,a%20few%20seconds%20to%20upload
0 Response to "How to Upload Excel Files as Csv to Google Drive"
Post a Comment