Converting a Google Sheet to an Excel file usually preserves your data, but formatting like conditional formatting, cell borders, and column widths can get lost or shifted if you use the wrong method. This guide shows you the most reliable way to export a Google Sheet as an .xlsx file while keeping the layout, styles, and formulas as intact as possible.
What You’ll Need
- A Google account with access to the Google Sheet you want to convert.
- A computer with a web browser (Chrome, Firefox, Edge, or Safari).
- Microsoft Excel (desktop or web version) if you want to open and edit the file locally.
Step-by-Step
- Open your Google Sheet in a web browser. Make sure you are signed in to the Google account that owns the file or has edit access.
- Check for unsupported features. Before exporting, review your sheet for elements that don’t translate well to Excel: charts, images, drawings, and scripts (Google Apps Script) may not carry over. Conditional formatting and data validation generally do convert, but complex custom formulas might need adjustment.
- Go to File > Download > Microsoft Excel (.xlsx). This is the direct export option. It downloads the file to your computer’s default Downloads folder.
- Wait for the download to complete. The file will have the same name as your Google Sheet, with an .xlsx extension. If your sheet is large, the download may take a few seconds.
- Open the downloaded file in Excel. Double-click the file to open it in Microsoft Excel. If Excel is not installed, you can upload it to OneDrive and open it in Excel for the web.
- Review the formatting. Scroll through your sheets, check column widths, row heights, cell colors, borders, and merged cells. Excel may slightly adjust some elements, but the overall layout should be close to the original.
- Save a copy in Excel format. Once you’ve confirmed everything looks good, go to File > Save As and choose the location. The file is already .xlsx, so you can just save it to keep the current version.
Common Mistakes
- Using “Save as” inside Google Sheets. Google Sheets doesn’t have a “Save as” button. You must use the Download menu to export the file.
- Copying and pasting the entire sheet. Copying all cells and pasting into Excel often breaks formatting like column widths, row heights, and conditional formatting rules. Always use the official export.
- Exporting as CSV instead of XLSX. CSV files only store plain text and numbers. All formatting, formulas, and multiple sheets are lost. Always choose “Microsoft Excel (.xlsx)” from the download menu.
- Ignoring print area and page setup. If your sheet has a defined print area, it might not carry over perfectly. Check Page Layout in Excel after converting.
- Forgetting to check formulas. Some Google Sheets functions (like QUERY, IMPORTRANGE, or GOOGLETRANSLATE) are not supported in Excel. They will show an error after conversion. Replace them with Excel equivalents before exporting.
Tips
- Use the same file name. The export will use the sheet’s name. If you want a different name, rename the Google Sheet before downloading.
- Check the first sheet. Excel will open the first sheet in the workbook. Make sure that’s the one you want users to see first.
- Keep a backup. The original Google Sheet remains untouched. The downloaded file is a separate copy, so you can always go back to the original if something goes wrong.
- Test with a small sample. If your sheet is complex, create a copy and delete most of the content, then export that copy to see how formatting behaves before converting the full file.
- Use Google Sheets’ “Compatibility mode”. In Google Sheets, go to File > Settings and check “Convert uploaded files to Google Sheets editor format”. This doesn’t affect export, but it helps when uploading Excel files back later.
Troubleshooting
Problem: The downloaded file won’t open in Excel.
Try opening it with a different program (like LibreOffice) to see if the file is corrupt. If it still doesn’t open, go back to Google Sheets and try exporting again. If the file is very large, try splitting it into smaller sheets.
Problem: Conditional formatting is missing or changed.
Excel and Google Sheets handle conditional formatting differently. Check the range references and rules in Excel. You may need to recreate some rules manually. To minimize this, keep conditional formatting rules simple and avoid using custom formulas that reference other sheets.
Problem: Column widths and row heights are off.
This is common because Google Sheets uses a slightly different measurement system. After opening in Excel, select all cells (Ctrl+A) and then go to Home > Format > AutoFit Column Width and AutoFit Row Height. This will adjust to the content.
Problem: Images or charts are not showing.
Google Sheets often exports images as separate files or places them in a way Excel doesn’t recognize. You’ll need to reinsert images and charts manually in Excel. For charts, you can copy the chart from Google Sheets and paste it into Excel as a picture or recreate it using the data.
Problem: Formulas show errors.
Check for unsupported functions. Common ones include QUERY, IMPORTRANGE, GOOGLETRANSLATE, and IMAGE. Replace them with Excel alternatives like FILTER, VLOOKUP, or simply the data itself. Also check for array formulas that use semicolons instead of commas.
Problem: The export option is grayed out.
This can happen if you don’t have edit access to the sheet. Make sure you are the owner or have been granted editor permissions. If you’re viewing a shared sheet, ask the owner to share it with edit rights.
Frequently Asked Questions
Q: Can I convert Google Sheets to Excel on my phone?
Yes, the Google Sheets mobile app has a download option. Open the sheet, tap the three-dot menu, and choose “Share & export” > “Save as” > “Excel”. The process is similar but may have fewer formatting options.
Q: Will my formulas work in Excel?
Most basic formulas (SUM, IF, VLOOKUP) work fine. But Google-specific functions like QUERY or IMPORTRANGE will not. You’ll need to replace them with Excel equivalents or paste the values.
Q: Can I convert multiple sheets at once?
Yes, the export downloads the entire workbook, including all sheets. Each sheet becomes a separate tab in the Excel file.
Q: Does the conversion preserve data validation?
Yes, data validation rules (like dropdown lists) are usually preserved. However, if you have custom formulas in validation, they might need adjustment.
Q: What if I need to convert an Excel file back to Google Sheets?
You can upload the .xlsx file to Google Drive and open it with Google Sheets. The same formatting issues can occur in reverse, so it’s a similar process.
Q: Is there a way to avoid losing formatting entirely?
No method is 100% perfect because the two programs use different rendering engines. The export method described here is the most reliable. For critical documents, consider keeping the original in Google Sheets and only exporting when necessary.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this bed
- Fix Text Cursor Turning White in Windows 11
- Force Quit Non-Responding Apps on Mac: 6 Ways
- Chromebook Not Charging? Fix It Fast
- iPhone Won’t Make Calls but Texts Work? Fixes
- Android to iPhone Hotspot: Connect & Fix Issues
- Fix Bluetooth Not Working on Discord Mobile