Convert Google Sheets to Excel: The Complete 2026 June Guide to Moving Spreadsheets Between Platforms Without Losing Data

If you need to convert Google Sheets to Excel, you are not alone. Millions of analysts, accountants, students, and small business owners move spreadsheets between the two platforms every day, whether to share a workbook with a client who only uses Microsoft Office, archive financial records in a stable local format, or take advantage of Excel features like advanced Power Query, pivot tables, and the full vlookup excel function library that Google Sheets does not replicate one-for-one.

On the surface, the process looks simple: open your Google Sheet, click File, choose Download, and select Microsoft Excel. In practice, the conversion is rarely that clean. Custom Google Apps Scripts vanish, IMPORTRANGE formulas break, conditional formatting rules sometimes shift, and certain chart types render differently once the .xlsx file opens in Excel. Understanding why these changes happen makes the difference between a smooth migration and hours of cleanup.

This guide walks through every method available in 2026, from the built-in download option to bulk conversion through Google Drive, command-line tools, and third-party automation services like Zapier and Make. You will learn how to preserve formulas, handle date and currency formats correctly across locales, and verify that nothing was lost in translation before sending the file to a client or uploading it to a shared SharePoint folder.

We also cover the reverse situation: what to do when a coworker sends you an Excel file and you need it back in Google Sheets, plus how to keep both versions synchronized when teams are split across platforms. The end of the article includes a troubleshooting checklist for the most common conversion errors, including the dreaded #REF! and #NAME? errors that appear when Google-specific functions like QUERY, GOOGLEFINANCE, and ARRAYFORMULA hit Excel.

Before diving into the steps, it helps to understand one fundamental truth about spreadsheet conversion: Google Sheets and Excel are not identical products with different logos. They are two distinct calculation engines that happen to share roughly 80 percent of their function library. The remaining 20 percent is where problems live, and the entire purpose of this guide is to help you anticipate and handle that 20 percent before it costs you a deadline or a client relationship.

Whether you are a single user converting one file or an IT administrator planning a department-wide migration, the techniques below scale from one workbook to thousands. Bookmark this page, work through the methods in order, and by the end you will be able to convert any Google Sheet to Excel with confidence that formulas, formatting, and data integrity all survive the trip.

The good news is that Google has invested heavily in Excel compatibility since 2023, and most everyday spreadsheets convert flawlessly. The bad news is that the more sophisticated your sheet, the more careful you need to be. Let us start with the basics and build from there, covering both single-file conversions and enterprise-scale migration strategies.

The most common way to convert google sheets to excel takes less than thirty seconds. Open the Google Sheet you want to export, click the File menu in the top-left corner, hover over Download, and select Microsoft Excel (.xlsx) from the submenu. The file downloads instantly to your default Downloads folder, fully compatible with Excel 2016, 2019, 2021, 2024, and Microsoft 365 across Windows, Mac, web, and mobile. The original Google Sheet remains untouched on Drive.

When you open the downloaded .xlsx file in Excel, you will see all your sheets preserved as tabs at the bottom, your data laid out exactly as it appeared in Google Sheets, and most of your formulas working without modification. Cell formatting, including font colors, borders, number formats, and conditional formatting rules, transfers with high fidelity. Charts convert to their nearest Excel equivalent, and embedded images move along with their parent cells, though their positions occasionally shift by a few pixels.

For users who frequently move files between platforms, Google offers a more elegant alternative called Office Editing Mode. If you upload an existing .xlsx file to Google Drive, you can edit it directly in Sheets without converting it to Google format, and any changes save back to the original Excel file. This is the ideal workflow when collaborating with someone who insists on Excel: they keep their .xlsx, you work in your familiar Sheets interface, and the file stays in Excel format throughout the process.

To download multiple files at once, navigate to drive.google.com, select all the Google Sheets you want to convert using shift-click or ctrl-click, right-click the selection, and choose Download. Google packages everything into a ZIP file and converts each Sheet to Excel format automatically during the download. This batch method saves enormous amounts of time when migrating entire folders, though it does have one quirk: any sheet larger than about 100 MB will be skipped and listed in an error log included in the ZIP.

For genuinely large-scale migrations, Google Takeout is the right tool. Visit takeout.google.com, deselect everything, then enable only Drive and configure the file format to export Google Sheets as Microsoft Excel. You can choose to download the archive directly or have it delivered to Dropbox, OneDrive, or another Google account. Takeout handles tens of thousands of files reliably, splits oversized archives into manageable chunks, and gives you a downloadable manifest documenting every file in the export.

Mobile users have a slightly different process. On the Google Sheets iOS or Android app, tap the three-dot menu in the top-right corner, choose Share & export, then Save as, and select Excel (.xlsx). The file saves to your device storage where you can email it, upload it to OneDrive, or open it directly in the Microsoft Excel mobile app. The mobile conversion uses the same engine as the desktop version, so the resulting file is identical regardless of which platform you used to generate it.

One often-overlooked feature is the ability to download a single sheet rather than an entire workbook. While Google does not offer this directly, you can right-click the sheet tab, choose Copy to, create a new spreadsheet, then download that single-sheet workbook as Excel. This trick is invaluable when you want to share one specific tab from a larger workbook without exposing the rest of the data to your recipient.

When conversions go wrong, the symptoms usually fall into one of five categories: missing formulas, broken formatting, lost data, shifted layouts, or corrupted files. Each has a different cause and a different fix, so identifying the category quickly saves hours of trial and error. Start by opening the converted file in Excel desktop rather than Excel Online, since the desktop application reveals more diagnostic information and provides better tools for repairing damaged workbooks through the built-in Open and Repair option in the File menu.

The most frequent issue is the #NAME? error appearing in cells that previously held Google-specific functions. These cells contain formulas Excel does not recognize, and there is no automatic translation. You must manually replace each one. Use Ctrl+F to search for the function name across all sheets, then either substitute the closest Excel equivalent or convert the cell to a static value by copying and pasting as values. For QUERY formulas specifically, consider rebuilding the logic using Excel's FILTER, SORT, and UNIQUE functions, which together cover most QUERY use cases.

Conditional formatting that uses custom formulas sometimes converts incorrectly because Sheets and Excel use slightly different formula reference styles. If you see formatting rules that appear in Excel but do not apply correctly, open the Conditional Formatting Rules Manager from the Home tab and inspect each rule. You may need to rewrite the formula using Excel's reference conventions, which use absolute references by default in conditional formatting whereas Sheets uses relative references in the same context.

Data validation rules often need attention after conversion. Drop-down lists built using data from another sheet sometimes lose their source reference, especially if the source range was defined using a named range. Open the Data Validation dialog from the Data tab, verify each rule, and update the source if needed. If you originally created the list using the how to create a drop down list in excel approach, the converted rules should work, but lists built from Google's newer dropdown chip feature may need to be rebuilt entirely as standard data validation.

Frozen rows and columns usually convert correctly, but if they do not, simply select the cell below and to the right of where you want the freeze line, then choose View, Freeze Panes, Freeze Panes from the Excel ribbon. This recreates the same behavior as how to freeze a row in excel and should restore the layout you had in Google Sheets. Print settings, page breaks, and header and footer text also sometimes need manual adjustment after conversion since the two platforms handle print layout differently.

Merged cells occasionally split apart during conversion, particularly when the merge spans many cells or uses Sheets-specific merge types like Merge Horizontally. If you encounter this, you may need to redo the merges manually following the how to merge cells in excel procedure: select the cells, then click Merge & Center on the Home tab. For complex layouts with many merges, it is often faster to fix them in Excel after conversion than to try preventing the issue in Sheets beforehand.

Finally, if a converted file simply will not open in Excel at all, the file is likely corrupted during download. Try downloading again, ideally using a different browser or after clearing your browser cache. If the file still fails, use Excel's Open and Repair function: open Excel, click File then Open, browse to the file, click the small arrow next to the Open button, and choose Open and Repair. This recovers most damaged workbooks, though it may strip out any features Excel cannot validate.

Beyond the basic conversion mechanics, professional users develop habits that make every future conversion smoother. The first habit is to build Google Sheets with conversion in mind from day one. This means avoiding Google-specific functions when an Excel-compatible alternative exists, keeping formulas simple enough to manually inspect, and segregating any GOOGLEFINANCE or IMPORTRANGE data onto dedicated sheets that can be removed or replaced with static values before exporting.

The second habit is to maintain a parallel Excel template for any recurring report. If you produce a weekly sales summary in Google Sheets but your CFO expects an Excel file, build the Excel template once, then use Power Query inside Excel to pull data directly from the published Google Sheet. This eliminates the manual conversion step entirely and ensures the formatting your CFO expects is preserved every week regardless of changes to the underlying Sheet.

For teams working with sensitive data, consider the security implications of every conversion. Each time you download a Google Sheet as Excel, you create a local copy that exists outside Google's access controls. If the original sheet had restricted sharing, the downloaded Excel file does not inherit those restrictions and can be forwarded freely. Train your team to treat converted files as new documents requiring their own access decisions, particularly for HR, legal, and financial data.

Version control deserves attention too. Google Sheets automatically tracks every change forever, but once you convert to Excel, that history is lost. The recipient sees only a snapshot at the moment of conversion. If you need ongoing change tracking, either keep the Google Sheet as the source of truth and convert only when sending, or upload the converted Excel file to SharePoint or OneDrive which provide their own version history through Microsoft 365.

Power users should learn the Drive API and Apps Script approach for any conversion they do more than ten times. A simple Apps Script triggered by a button or a schedule can convert a Google Sheet to Excel and save it directly to a shared Drive folder, OneDrive folder, or even attach it to an email. This eliminates the entire manual download workflow and makes the conversion bulletproof. Google publishes excellent documentation for the Drive.Files.export method which is the core API call you need.

For ongoing collaboration between Sheets users and Excel users, consider tools like Sheetgo, Coefficient, or Apipheny which create live two-way bridges between the platforms. These services keep an Excel file synchronized with a Google Sheet so both teams can work in their preferred tool without manual conversions. The setup takes a few minutes and pays for itself the first time you avoid emailing version 47 of a budget spreadsheet.

Finally, remember that conversion is not always the right answer. If your only goal is to share data with someone who uses Excel, consider whether they really need the data in Excel format or whether a PDF, a CSV, or a view-only Google Sheet link would work just as well. Each format has trade-offs, and choosing the right one for the situation is a skill that distinguishes professional spreadsheet users from amateurs.

To close out this guide, here are the practical workflows that experienced spreadsheet users actually employ when moving data between Google Sheets and Excel. These are not theoretical best practices but battle-tested routines refined through hundreds of conversions across finance, marketing, operations, and education contexts. Adopt the ones that fit your situation and you will spend dramatically less time fighting your tools and more time using them.

For a one-time conversion of a single file, simply use File, Download, Microsoft Excel and open the result. Spend two minutes spot-checking the most important formulas, then send the file. Do not overthink it. The built-in conversion is excellent for standard spreadsheets and rarely produces issues worth troubleshooting in advance. Reserve detailed checking for files where errors would have real consequences.

For weekly or monthly recurring conversions, invest thirty minutes upfront building an Apps Script that exports the sheet on a schedule and emails or saves the result to a shared location. The script is fewer than twenty lines of code and pays for itself within a month. The Apps Script editor is built directly into Google Sheets under Extensions, and Google's own documentation includes copy-paste examples for exactly this use case.

For team collaborations where some members use Sheets and others use Excel, pick one platform as the source of truth and stick with it. Constantly converting in both directions creates version conflicts and lost work. If the source is Google Sheets, the Excel users open the file using Microsoft 365's web preview or download a fresh copy each time they need to work. If the source is Excel, store it in SharePoint and have the Sheets users connect to it through Power Query or a sync service.

For migrating an entire organization from Google Workspace to Microsoft 365, hire a specialist or use a dedicated migration tool like CloudFuze, BitTitan, or Sharegate. These tools handle conversion at scale, preserve sharing permissions where possible, and provide audit logs you will need for compliance. The cost is significant but small compared to the productivity loss of a botched manual migration. Plan migrations during slow business periods and run a pilot with a small team first.

For students and freelancers who occasionally need Excel deliverables but prefer working in Sheets, embrace the convert-on-demand workflow. Build everything in Google Sheets where collaboration and accessibility are easier, then convert to Excel only at the final delivery moment. Keep a personal checklist of the three or four formulas you commonly use that need replacement, and verify those specifically every time. This habit catches 95 percent of conversion problems before they reach your client or instructor.

Whatever your scenario, the most important takeaway from this guide is that conversion is a skill you can learn and improve. The first few conversions feel awkward and you may worry about losing data, but after twenty or thirty you will develop intuition for when to trust the built-in tools and when to take extra precautions. Bookmark this article, return to the troubleshooting section whenever errors appear, and over time you will become the person on your team everyone calls when a spreadsheet needs to travel between platforms.