Cara save google spreadsheet ke excel

Table of Contents Show

Some Google Sheets Functions Don’t Work in Excel
Convert a Google Sheet to Excel From the Google Sheets Website
Convert a Google Sheet to Excel From the Google Drive Website
Why Sync Google Sheets to Excel?
How to Convert a Google Sheet to Excel
How to Save Google Sheets as Excel Using Google Drive
Do the Functions From Sheets Work in Excel?
How to Open a Google Sheets File in Excel
How to Save Excel as Google Sheets
How to Open an Excel File in Google Sheets
Compatibility Issues When Using Excel Files in Sheets
Frequently Asked Questions
How Do I Open Google Sheets in Excel?
How Do I Change a Google Sheet to .xlsx?
How Do I Convert Multiple Google Sheets to Excel?
Wrapping Up
Bagaimana cara memindahkan spreadsheet ke excel?
Apakah Google Spreadsheet bisa diedit semua orang?
Bagaimana cara mengakses Google Spreadsheet?
Berapa ukuran maksimal Microsoft Excel yang dapat dikonversi ke dalam Google sheet?

By converting your Google Sheet to Microsoft Excel, you can edit your spreadsheet locally with the Excel app on your computer. We’ll show you how to perform this conversion on both the Google Sheets and the Google Drive sites.

Some Google Sheets Functions Don’t Work in Excel

Google Sheets has certain functions that are not supported by Excel. If your spreadsheet uses one or more of these functions, you will need to remove them or replace them with Excel-compatible functions before converting your files. Open as App keeps a list of Google Sheets functions that don’t work in Excel, so check it out to make sure you don’t end up with a broken sheet.

Convert a Google Sheet to Excel From the Google Sheets Website

If you prefer the Google Sheets site to access your spreadsheets, use this method for the conversion.

First, on your Windows, Mac, Linux, or Chromebook computer, launch a web browser and head over to the Google Sheets site. Log in to your account if you aren’t already.

On the Sheets site, select the sheet you’d like to convert to Excel.

Your sheet will open on the Sheets’ editing screen.

From the menu bar on the Sheets’ editing screen, select File > Download > Microsoft Excel.

You will see your computer’s standard “save” window where you can save the resulting Excel file. In this window, choose a folder to save your file in, type a name for your file, and click “Save.”

And that’s it. The Excel version of your selected Google Sheet is now available in the specified folder on your computer. You can use a similar process to convert Google Docs to Word files.

RELATED: How to Convert a Google Docs Document to Microsoft Office Format

Convert a Google Sheet to Excel From the Google Drive Website

If you access your Google Sheets from the Google Drive site, use this method for your conversion. A benefit of this method is that you can use this to convert multiple Google Sheets to Excel at once.

Start by launching a web browser on your Windows, Mac, Linux, or Chromebook computer and accessing the Google Drive site. Log in to your account on the site.

On the Google Drive site, find the Google Sheet to convert to Excel.

Right-click the Google Sheet and select “Download” from the menu.

You will see your computer’s standard “save” window to save your Excel file. Here, select a folder to save your file, enter a name for your file, and click “Save.”

And your Google Sheet is now available as an Excel file on your computer. Enjoy locally editing your spreadsheets!

Went Excel and want to go back? Converting an Excel spreadsheet to Google Sheet is as easy as the guide above.

RELATED: How to Import an Excel Document into Google Sheets

Why Sync Google Sheets to Excel?

If you’re working in a large organization, there are several reasons why you would want to convert Google Sheets to Excel and vice versa.

Here are a few of the most common reasons to save a Google Sheet to an Excel file:

People in your team prefer one spreadsheet software over the other.
Team members do not wish to be a part of the Google ecosystem.
Policies dictate that you have to send in work as an attachment rather than a link.
One software doesn’t have the functions that your company needs.
Sheets lose their performance when working with larger spreadsheets which is why the company needs the responsiveness of Excel.
Sometimes it’s easier to import a .csv file into Google Sheets, then copy the .xlsx file to Excel to work with it.

How to Convert a Google Sheet to Excel

Thankfully, Google Sheets lets you download your spreadsheets in a .xlsx file. Microsoft Excel supports this file type. So you’ll never have to make a definitive decision about which spreadsheet program is better.

Here are the steps you need to follow to convert Google Sheets to Excel:

Open the spreadsheet you wish to download to your computer.
Click on File in the top bar. This will open a dropdown menu containing a list of options.
Here, click on Download. This will open another sub-menu allowing you to choose the file format. We aim to download the file in a .xlsx format.
In the menu, click on Microsoft Excel (.xlsx)

This will download the file to your computer. You can usually find the file in the download folder of your web browser.

How to Save Google Sheets as Excel Using Google Drive

If you’re working on Google Sheets, your data is automatically backed up to Google Drive. If you don’t have access to Sheets, you can also download the file from there.

Here are the steps you need to follow to export Google Sheets to Excel:

Open Google Drive in your browser.
Click on My Drive and scroll down to find the name of the Google Sheets file. Alternatively, you can also search for the name in the search bar at the top of the screen.
Right-click on the file, which will show a pop-up menu. Click on Download, and the file will download onto your computer locally.

If you follow the above to learn how to download Google Sheets into Excel, then you just click to open the downloaded file in your Windows or macOS file browser.

Do the Functions From Sheets Work in Excel?

Although the functionality of both Microsoft Excel and Google Sheets is similar, there are many incompatible functions in either software, which means importing the spreadsheet file into either software is bound to break some functionality.

Here are some of the formulas that are incompatible between Excel and Google Sheets:

ADD
ARRAYFORMULA
CONCAT
CONTINUE
COUNTUNIQUE
DETECTLANGUAGE
DIVIDE
EQ
FILTER
GOOGLEFINANCE
GOOGLETOURNAMENT
GOOGLETRANSLATE
GT
GTE
IMAGE
IMPORTDATA
IMPORTFEED
IMPORTHTML
IMPORTRANGE
IMPORTXML
JOIN
LT
LTE
MINUS
MULTIPLY
POW
QUERY
SORT
SPARKLINE
SPLIT
TO_TEXT
TO_PERCENT
TO_DOLLARS
TO_DATE
UMINUS
UNARY_PERCENT
UNIQUE
UPLUS

If your spreadsheet uses any of these functions, you should look to remove the formula or replace it with one which is compatible with Excel.

How to Open a Google Sheets File in Excel

There are multiple versions of Microsoft Office that you can use. These include Office 2019, 2016, 2013, and 2010.

The latest release is Office 365, which works on a subscription-based model. Office 365 works online, whereas older versions of Office work on your computer locally. We will be working on Office 365 for this example.

But if you’re using older versions, right-click on the file, which will open a menu. Here, click on Open with and then choose Microsoft Excel. This will open Excel on your computer. There you will be able to access the file normally.

To open the downloaded Google Sheets file in Excel for Office 365, follow these steps:

Open Microsoft Excel on your browser. If you have Excel downloaded on your computer, open it there.
On the main screen, click on Upload. This will open the local file browser of your operating system. There, navigate to the locally stored file.
Select your file and click on Open. This will open a small window in the middle of the screen where you can see the file upload progress.

Once done, Excel will open your file, and you can make changes to the file like you normally would.

How to Save Excel as Google Sheets

Downloading your spreadsheet from Excel follows a similar format as it would if you were to download it on Google Sheets. When using Microsoft Office 2019, 2016, 2013, and 2010, the files will be saved locally to your PC. However, on Office 365, the file is synced to Onedrive, so you will have to download it locally.

Here are the steps you need to follow to do this:

In your Excel spreadsheet, click on File. This will open the main sidebar menu.

Click on Save As in the main options. This will open a sub-menu.
There, click on Download a Copy.

This will download the .xlsx file to your computer. This file can be found in the Downloads folder of your browser.

How to Open an Excel File in Google Sheets

Here are the steps you need to follow to open an Excel file in Google Sheets:

Head over to Google Sheets in your browser.

Click on the File icon. This will open a new window allowing you to choose the file.

We wish to upload our locally stored file, which is why we will be using the Upload option.
There, you can drag and drop the file, or you can click on Select a file from your device.
This will open your local file browser. Head over to the file and click on Open.

This will start loading the file into Google Sheets. Once uploaded, the file will open, and you can make changes like usual.

Compatibility Issues When Using Excel Files in Sheets

Although you can load the Excel file into Google Sheets, note that Sheets lacks many of the advanced features that Excel offers, which is why you are bound to face some compatibility issues. Here are a few of them:

You can not import password-protected Excel files into Google Sheets.
Google Sheets will ignore any links to other spreadsheets in the file.
Google Sheets does not support power query, PowerPivot, and other data modeling features of Excel.
If your Excel file has VBA macros, these won’t have support in Google Sheets. Instead, you can write code in AppScript when working in Google Sheets.

If your Excel file uses any of these functions, find an alternative to those as they won’t work in Google Sheets. If you upload the file into Sheets, they might be deleted or lose functionality.

Frequently Asked Questions

How Do I Open Google Sheets in Excel?

Here’s how to transfer Google Sheets to Excel:

Open Microsoft Excel on your computer.
On the main screen, click on Upload. This will open the local file browser of your operating system.
Navigate to the locally stored file.
Select your file and click on Open. This will open a small window in the middle of the screen where you can see the file upload progress. Once the upload is complete, the file will be loaded in Excel.

How Do I Change a Google Sheet to .xlsx?

Open the spreadsheet you wish to download to your computer.
Click on File in the top bar. This will open a dropdown menu containing a list of options.
Here, click on Download. This will open another sub-menu allowing you to choose the file format.
In the menu, click on Microsoft Excel (.xlsx). The file will then be downloaded to your computer.

How Do I Convert Multiple Google Sheets to Excel?

After selecting the Google Sheets file, click on Add another source file. Choose additional files from My Drive. Select the source tab. The tab should have the same name as the initial source. Click on Finish and Save.

Wrapping Up

Learning to import and export a spreadsheet file into Excel and Sheets can be necessary as it allows you to easily collaborate with your team members no matter what spreadsheet software they use. We hope this article helped you better understand how to save a .xlsx file in Google Sheets and import it into Excel.

Now that you know How to Convert Google Sheets to Excel, you may want to learn more.

Check out some of these related guides to boost your spreadsheet skills:

How to Add a Google Sheet to a Google Doc
Google Sheets Notifications: How to Turn On, Edit & Remove
The Best Google Sheets Add-Ons
How to Share Only One Sheet in Google Sheets

Bagaimana cara memindahkan spreadsheet ke excel?

File Excel tidak akan berubah, meskipun Anda mengubah file Spreadsheet..

Di Spreadsheet, buat spreadsheet baru atau buka yang sudah ada..

Klik File. Impor..

Pilih file Excel, lalu klik Pilih..

Pilih salah satu opsi impor: Buat spreadsheet baru. Sisipkan sheet baru. ... .

Klik Impor data..

Jika diminta, klik Buka sekarang..

Apakah Google Spreadsheet bisa diedit semua orang?

Ada dua cara membuat Google Docs bisa diedit semua orang, yaitu antar-email dengan menambahkan email orang lain ke opsi bagikan, ikon tambah orang dan membagikannya menggunakan tautan dengan mengubah perizinan tautan.

Bagaimana cara mengakses Google Spreadsheet?

Mendapatkan Spreadsheet di perangkat Anda Browser web apa pun—Buka sheets.google.com. Google Drive—Klik Baru. Google Spreadsheet, lalu buat dari awal atau dari template. Sebagian besar halaman Google—Di pojok kanan atas, klik Peluncur Aplikasi.

Berapa ukuran maksimal Microsoft Excel yang dapat dikonversi ke dalam Google sheet?

Ukuran file Hingga 10 juta sel atau 18.278 kolom (kolom ZZZ) untuk spreadsheet yang dibuat di atau dikonversi ke Google Spreadsheet. Hingga 10 juta sel atau 18.278 kolom untuk spreadsheet yang diimpor dari Microsoft Excel. Batasnya sama untuk impor Excel dan CSV.