How to Convert a Google Sheet to Excel (XLSX) Format

Google Sheets is a powerful cloud-based spreadsheet tool, ideal for collaboration and accessibility. But sometimes you need to work offline, open your file in Microsoft Excel, or share it with someone who uses Excel rather than Google Workspace.

The solution is simple: Convert your Google Sheet to an Excel XLSX file. In this post, we’ll show you multiple ways to do this—manually, automatically, and programmatically—so you can choose what fits best.

✅ When Should You Convert Google Sheets to Excel?

Some common reasons for converting include:

• Sharing spreadsheets with Excel users

• Working offline or without internet

• Using Excel-only features (macros, advanced charts)

• Creating a backup in XLSX format

Method 1: Manually Download as Excel (XLSX)

This is the most straightforward way.

Step-by-Step:

1. Open your Google Sheet.

2. Click on File > Download > Microsoft Excel (.xlsx).

3. The XLSX file will be downloaded to your computer.

4. You can now open it in Microsoft Excel, or share it via email, drive, or any other medium.

Notes:

• File name will match your Google Sheet name.

• Formatting, formulas, and charts are generally preserved.

• Some complex features (e.g., Google Sheets-only functions like GOOGLEFINANCE) may not work in Excel.

Method 2: Convert via Google Drive (Right-click)

You can also convert and download without opening the Sheet.

Steps:

1. Go to Google Drive.

2. Locate the Google Sheet you want to convert.

3. Right-click the file and choose Download.

4. Google Drive will automatically convert it into XLSX format and download it.

This works only if the file is a native Google Sheet.

Method 3: Use Google Apps Script to Export as Excel

If you want to automate the conversion, such as exporting a sheet daily or on a trigger, you can use Google Apps Script.

Script:

1. Open your Sheet > Extensions > Apps Script

2. Paste this code:

function exportSheetToExcel() {
  const file = SpreadsheetApp.getActiveSpreadsheet();
  const fileId = file.getId();
  const url = `https://docs.google.com/spreadsheets/d/${fileId}/export?format=xlsx`;

  const options = {
    method: "GET",
    headers: {
      Authorization: "Bearer " + ScriptApp.getOAuthToken()
    }
  };

  const response = UrlFetchApp.fetch(url, options);
  const blob = response.getBlob().setName(file.getName() + ".xlsx");

  DriveApp.createFile(blob);
}

3. Save and run the script.

4. The .xlsx file will be created in your Google Drive with the same name as your Sheet.

Use Cases:

• Scheduled daily backups to Excel

• Exporting multiple sheets programmatically

• Automating report sharing with Excel users

Method 4: Use Google Takeout to Export All Sheets as Excel Files

If you want to export multiple Google Sheets in bulk, Google Takeout is helpful.

Steps:

1. Visit Google Takeout.

2. Select only Google Drive or specifically Google Sheets.

3. Choose the export format for Docs/Sheets (set Sheets to Excel).

4. Proceed to export.

5. You'll receive a ZIP file with all your Sheets as .xlsx files.

Method 5: Convert Google Sheet to Excel Using Third-Party Tools or Add-ons

Some file conversion platforms support bulk export from Google Sheets to Excel. Examples:

• Zapier or Make (Integromat) for automation

• CloudConvert or ConvertAPI

• Google Workspace Add-ons like Sheetgo

Be cautious when using third-party tools—ensure they are trustworthy and handle your data securely.

Things to Watch Out For When Converting

To ensure compatibility, test your file in Excel after converting and make any necessary adjustments.

Conclusion

Converting Google Sheets to Excel (.xlsx) is fast, easy, and essential when you need cross-platform compatibility or offline access. Whether you're doing a one-time conversion or building an automated workflow, Google Sheets gives you multiple tools to get it done right.