Skip to content Skip to sidebar Skip to footer

Upload Excel to Google Sheets Without Converting

Occasionally, you may demand to convert Excel files to Google Sheets. This may be a single file, multiple files, or a file with formulas and macros. In most cases, information technology is easy enough to do it, merely you lot might besides face some challenges.

This article explains several options to catechumen Excel to Google Sheets. We'll larn each of them in detail and understand which method is best for certain cases. Let's kickoff!

Why you may demand to convert an Excel file to Google Sheets

Microsoft Excel is ane of the best tools for large organizations, and has been used to manage financial data for decades. As Excel is a standalone app, it's fast and powerful. Information technology tin shop a large number of cells (17,179,869,184, specifically), and you don't need to worry well-nigh slowing performance – as long as you have a good computer with fast RAM.

Google Sheets, on the other paw, tin can store merely 5,000,000 cells, at the time of this writing. The restriction is because Sheets is a deject-based spreadsheet; the more cells you use, the slower it gets.

Despite those limitations, more and more people are using Google Sheets for the following reasons:

  • Google Sheets is costless, while Excel has monthly/yearly subscriptions.
  • Almost people don't really need those 5,000,000 cells — and in Google Sheets, when you're working with smaller spreadsheets, you may not experience any lag.
  • It's fully attainable and editable via browsers.

"But, Excel also has an online version, and it's also free," you may say.

Indeed, you lot can likewise collaborate for free using Excel Online. Withal, in many cases, yous'll still need to launch Excel while editing your certificate. So yous may want to convert your files to Google Sheets when yous're collaborating with others who don't have Excel or when y'all want to switch to a completely free solution.

Can I open and edit an Excel file using Google Sheets without converting it?

Yes, of grade! The following table lists some file formats supported in Excel that you lot can view in Google Sheets. Detect that four of them are editable.

Format Extension Editable in Google Sheets
Excel 2007-2010 Workbook .xlsx Yep
Excel 2007-2010 Macro-enabled Workbook .xlsm Yes
Excel 97-2003 Workbook .xls Yep
Excel 97-2003 Template .xlt Aye
Excel 2007-2010 Template .xltx No
Excel 2007-2010 Macro-enabled Template .xltm No
OpenDocument Spreadsheet .ods No
Comma-delimited text file .csv No
Tab-delimited text file .tab No

Google continues to better Office editing in Google Sheets, merely currently, only Excel files with .xlsx, .xlsm, .xls, and .xlt extensions are editable. Google Sheets will save any changes you make to these files in the original Excel format. If y'all edit an Excel file older than Office 2007, it volition be saved to a newer format.

To open and edit an Excel file, you start need to upload it to Google Bulldoze. The following steps show you how to upload an edit an XLSX file:

Pace i. Open GDrive using Google Chrome on your computer. You may use other browsers that you have.

Step 2. Click the New button in the top-left. Then, select File upload from the dropdown menu.

Step 3. Select the Excel file y'all want to upload from your reckoner and wait for the upload to complete.

Pace 4. Double-click the file to open it. Your Excel file will open in "Role Editing Mode", which retains Excel formatting without converting the file. If y'all'd like, you can also edit the file, view the version history, share, and interact with others.

How to convert an Excel spreadsheet to Google Sheets in Google Bulldoze

You might want to convert an Excel file to Google Sheets format then continue working on it in Sheets. When converting a file, Google Sheets will create a new spreadsheet and won't alter your original Excel file.

For an editable file in Google Sheets (such as an XLSX file), y'all tin can simply open it and save information technology in Google Sheets format past clicking File > Save as Google Sheets from the menu.

What if the file is non editable in Google Sheets, such as a CSV or XLTX? In this case, when you open up it, there will exist an option, "Open with Google Sheets", at the top of the file. If you click on information technology, your file will exist automatically converted to Google Sheets format.

Cheque out the reverse integration – from Google Drive to Excel.

How to catechumen an Excel file to Google Sheets by importing its data

Instead of converting an Excel file, you may want to import its information into a new or existing Sheets file. In this case, your original Excel file won't be inverse. Here are the steps to import data from Excel to Google Sheets:

Step 1. Create a new Google Sheets file or open an existing spreadsheet.

Step two. Click File > Import.

Step 3. Select an Excel file from your Google Drive or upload information technology from your difficult-drive.

Stride 4. Choose an import location, then click the Import data button.

See that in the above screenshot, in that location are three available locations for the current import. Nonetheless, if y'all're importing a CSV file to Google Sheets, all half-dozen options will be bachelor. Be careful when choosing "Replace spreadsheet" or "Supersede data at selected prison cell", because your existing data volition then exist replaced.

How to convert multiple Excel files to Google Sheets

Suppose you have 100 Excel files, and you lot desire to convert all of them to Google Sheets format. Doing it ane at a time can be irksome. Here are two options you tin can cull to convert those files automatically.

Automatically convert Excel files to Google Sheets on upload

This method is suitable if your Excel files are currently on your difficult drive.

Stride 1. Open up Drive using Google Chrome or other browsers you may have.

Step 2. Click the Settings icon > Settings.

Step 3. Tick the check box adjacent to the Convert upload option.

Pace 4. Click the DONE button.

Now, every time you select single or multiple files (including files in Excel format), those files will exist converted automatically to Google Sheets format. Note that files previously uploaded earlier this setting was turned on will not exist affected.

How to convert Excel files to Google Sheets using a script

Suppose you lot have XLSX files already stored in a Google Bulldoze folder named Folder East. Yous want to convert all of the files and keep them in Binder G.

Here are steps on how to do this using Google App Script.

Stride 1. Get the ID of Folder E. It'southward easy — open up the folder and re-create the last part of the URL. Paste this in a text editor or somewhere with easy access.

Stride 2. Go the ID of Folder One thousand in the aforementioned style as Step ane.

Footstep 3. Create a new Google Sheets document.

Pace 4. Open the Script editor by clicking Tools > Script editor from the card.

Step v. Re-create and paste the post-obit lawmaking into myFunction in Code.gs. Don't forget to change the values of sourceFolderId and destinationFolderId to the IDs in Step 1 and two, respectively.

role myFunction() {   // ID of Folder E. Change information technology with yours.   var sourceFolderId = "1QYu4Ymn1Phq1umCkK2EuDkrZ3dLXbQPd";      // ID of Binder G. Alter information technology with yours.   var destinationFolderId = "19x8qXzKCm7Jp7SRmg-zBUELXUCPv8R9o";      // Get Microsoft Excel spreadsheet files   var files = DriveApp.getFolderById(sourceFolderId).getFilesByType(MimeType.MICROSOFT_EXCEL);      while(files.hasNext()){     var file = files.next();     var proper noun = file.getName().split('.')[0];      var id = file.getId();     var blob = file.getBlob();       var newFile = {         title : name + '_converted',         parents: [{id: destinationFolderId}]        };             var sheetFile = Drive.Files.insert(newFile, blob, { convert: true });   } }

Your entire lawmaking volition look like this:

Step 6. Add together the Drive API service by clicking the plus (+) button next to Services in the left menu, and so click the Add button at the bottom of the popup.

Step seven. Click the Run button, and authorize the script to access your business relationship if requested. Subsequently that, bank check the destination folder.

Here is an example result. Run into that the Excel files in Folder E were converted to Google Sheets format in Binder One thousand.

After exporting your Excel files to Google Sheets, you might want to combine multiple sheets from one or multiple documents into one. Bank check out our tutorial on how to combine information from multiple sheets into one.

How to convert Excel Online files to Google Sheets

Suppose yous're using Excel Online, and your file is stored in OneDrive. In this case, you lot can't convert it directly to Google Sheets format. However, you lot can import the information to Google Sheets using Coupler.io.

Coupler.io is an integration tool that allows you to retrieve data from popular sources to Google Sheets. You can import data from Airtable, Shopify, WordPress, QuickBooks, CSV, and many others into Google Sheets and automate this procedure. This tool can import XLSX and CSV/TSV files stored on OneDrive, too as Dropbox. For more detail, see our tutorial on how to sync your Excel files stored on OneDrive or Dropbox with Google Sheets.

Note: Please notation that this method will fetch the information but. Thus, you volition lose all formulas, conditional formatting, and so on.

Utilize IMPORTDATA function to pull Excel from OneDrive

To employ this function, unfortunately, your file needs to be in a comma-delimited (.csv) format. If your file is in another format, click the Open up in Desktop App menu at the superlative to launch Excel.

After the file opens in Excel, click File > Save a Re-create and save it as a CSV in anOneDrive binder.

Note : If your file contains more than 1 sheet, only the active canvas will exist exported to CSV. You'll need to relieve each sheet individually to different CSV files.

Next, follow the steps below to import its data to a Google sheet.

Step 1. Get the iframe code of your CSV file every bit follows:

<iframe src="https://onedrive.alive.com/embed?cid=D8149252543AB8C1&resid=D8149252543AB8C1%218886&authkey=AO00J5TABupU99A" width="98" height="120" frameborder="0" scrolling="no"></iframe>

Step two. Catch the link from the iframe code.

https://onedrive.live.com/embed?cid=D8149252543AB8C1&resid=D8149252543AB8C1%218886&authkey=AO00J5TABupU99A

Stride 3. Replace the cord "embed" in the link with "download".

https://onedrive.live.com/download?cid=D8149252543AB8C1&resid=D8149252543AB8C1%218886&authkey=AO00J5TABupU99A

Pace iv. Now you tin can use this link as the URL argument in the IMPORTDATA formula. Create a new Google Sheets document and copy-paste the following formula into A1.

=IMPORTDATA("https://onedrive.live.com/download?cid=D8149252543AB8C1&resid=D8149252543AB8C1%218886&authkey=AO00J5TABupU99A")

Can I convert an Excel file with formulas to Google Sheets?

Yes, of form! Y'all can convert the file using the methods explained previously: by saving it in Google Sheets format or importing it. However, Excel and Google Sheets don't share all formulas. So, it'southward best to check the converted file to ensure all the formulas work as expected.

Moreover, other things that may not work:

  • Some text and cell formats.
  • Countersign-protected files, then y'all need to remove whatever password protection before opening an Excel file in Sheets.
  • Any SmartArt.
  • Links to whatever other Excel spreadsheets.
  • Pivot tables from Excel may not work in Sheets.
  • Power Pin and Power Query.

Then, it'due south best to verify the converted file in Google Sheets to see which ones you might lose so that you tin can ready them.

Can I convert an Excel file with macros to Google Sheets?

If the original spreadsheet has macros, you'll have to recreate them in Google Sheets. For the scripting linguistic communication, Excel is based on VBA (Visual Basic for Applications), while Sheets is based on JavaScript. So, the macros you create in i app won't piece of work on another.

Here's an example of an Excel file with macros. If the macro push is clicked, a bulletin box appears:

At present, let'due south compare with the post-obit screenshot that shows how it looks afterwards the file is converted to Google Sheets format:

From the above screenshot, see that the push from the macro is not converted. And so, if yous have macros in your Excel file, it'southward best to note them before converting the file. This manner, you accept a list of macros to recreate in Google Sheets.

Bonus: How tin can I catechumen Google Sheets to Excel?

The easiest way to convert Google Sheets to Excel is past downloading the Google Sheets information as a Microsoft Excel workbook.

For the first choice, right-click on the Google Sheets file, then select Download from the menu, as the following screenshot shows:

As another option, if the certificate is already opened in Google Sheets, simply click File > Download > Microsoft Excel (.xlsx) from the carte.

Notice that you tin can really download to other formats such as ODS, PDF, HTML, and others.

Best way to convert Excel into Google Sheets

We have explored in detail each method for converting Excel to Sheets (except for coding solutions, for example Python to export Excel to Google Sheets). Now, you may exist wondering which method is the best. Well, unfortunately, in that location is no unmarried all-time solution for all cases. The best answer depends on several things, such as:

  • Whether you want to convert single or multiple files.
  • Whether the format of the original file is editable in Google Sheets or not.
  • Whether the Excel files are on your difficult drive, or in cloud storage such equally OneDrive.

So hopefully, after reading this article, you'll be able to cull the most convenient method based on your needs. Good luck!

Back to Blog

Admission your data

in a simple format for free!

Start Free

woodardhioname.blogspot.com

Source: https://blog.coupler.io/convert-excel-to-google-sheets/

Post a Comment for "Upload Excel to Google Sheets Without Converting"