Blog

Everyone’s bought their spreadsheet instrument of selection. It doesn’t matter if they appear nearly similar to the outsider wanting in; a choice exists. It’s like PC vs. Mac or driving stick vs. computerized. But whether or not your go-to spreadsheet instrument is Google Sheets or Microsoft Excel, you’ll ultimately have to work with individuals who want the opposite. That means you’ll have to convert Excel spreadsheets to Google Sheets.

Here are two alternative ways you are able to do that.

UNITO USERS: You also can try our information on how to sync spreadsheets between Microsoft Excel and Googles Sheets with Unito.

First technique: importing an Excel sheet into Google Drive

Did you realize you possibly can truly open Excel information in Google Sheets? All you want to do is import them into your Google Drive. It’s a fairly easy course of.

The .XLSX bubble on the prime means you’re nonetheless opening and dealing in an Excel file. You can maintain working on this file format, which is helpful in case you want to ship the file again to Excel later. You also can convert your Excel file to a Google Sheet with none additional instruments.

Converting your Excel file to Google Sheets

Maybe you’re accomplished with Excel. Maybe you’re not utilizing Excel your self, and also you want to maintain working in Google Sheets. Either approach, right here’s how one can convert the workbook you imported right into a Google Sheet.

Let’s return to Google Drive and click on on File.

Looks like there’s an choice made simply in your wants. Hit Save as Google Sheets.

Notice that the .XLSX bubble is gone? That’s since you’ve transformed your Excel workbook right into a Google Sheet. Now you possibly can work in Google Sheets with the toolbars and options you’re used to.

But whereas this technique is likely to be simple, it’s not excellent.

Limitations of this technique

You can get a single Excel workbook into Google Sheets in just some clicks, however is that actually the easiest way to get it accomplished? After all:

• It’s handbook: How many Excel workbooks can your division create in a month? How a lot of these do you want to carry into Google Sheets? Even a couple of clicks can add up, till it appears like all you’re doing is clicking via menus.
• Nothing is up to date: The second you change an Excel workbook to a Google Sheet, it turns into out of date. Why? Because all of the work you’re doing in Google Sheets doesn’t get despatched again to Excel. Sure, you possibly can frequently ship your spreadsheets backwards and forwards each time there’s an replace. But who has that sort of time?
• There’s no filtering: Sometimes, you don’t want an total workbook in Google Sheets. You simply need particular columns from that workbook, possibly to add in some further knowledge in Google Sheets. But with this technique, it’s the entire workbook or nothing. Unless you need to manually create a duplicate of the workbook and delete a bunch of knowledge.

With these limitations in thoughts, right here’s a greater approach to convert Excel spreadsheets to Google Sheets.

Second technique: convert Excel spreadsheets to Google Sheets with Unito

Unito is a no-code workflow administration answer with the deepest two-way integrations for the most well-liked database instruments available on the market, together with Google Sheets and Microsoft Excel. With a Unito circulate, you change Excel spreadsheets to Google Sheets whereas holding all of your knowledge up to date in each instruments in real-time. No extra importing workbooks, copy-pasting, or handbook work.

Here’s why Unito is a greater technique for changing Excel spreadsheets to Google Sheets:

• It’s computerized: Instead of manually importing workbook after workbook each time, you possibly can simply create a Unito circulate that can mechanically maintain the whole lot in sync in each instruments.
• Everything’s up to date: Is there something worse than having to manually replace spreadsheets in two instruments any time new knowledge is available in? With Unito, that’s a factor of the previous.
• Filtering knowledge is built-in: You don’t have to sync a complete Excel spreadsheet to Google Sheets. Unito’s guidelines use easy logic to permit you to filter out the columns you don’t need in your Google Sheet.

Want to see how simple it’s to set this up?

Building a Unito circulate

Anyone can construct their first Unito circulate in just some clicks.

Start by connecting your instruments.

Next, you’ll need to choose the spreadsheets you need to join.

After that, you possibly can arrange your guidelines and filter out knowledge you don’t need to be synced over.

Now, you possibly can map your columns in Excel to columns in Google Sheets. Unito can map these for you mechanically in the event that they’re related sufficient. Otherwise, you simply want to click on on + Add mapping and discover the columns you need to map on both aspect.

And that’s it! Now all you want to do is launch your circulate and watch the info sync over.