General

Google Sheets Export Formats: XLSX, CSV, PDF, and More

Published Mar 19, 2026 6 min read By ChangeThisFile Team

Quick Answer

Google Sheets exports to XLSX, CSV, TSV, PDF, ODS, and HTML via File > Download. XLSX preserves formulas, formatting, and charts but loses Google-specific functions (QUERY, IMPORTRANGE, GOOGLEFINANCE). CSV exports values only from the active sheet. PDF creates a visual snapshot. ODS preserves most features except Google-specific functions. The Google Sheets API enables programmatic export with fine-grained control over format and range.

Google Sheets is a cloud-native spreadsheet that stores data in Google's proprietary format internally. When you need to share data outside Google's ecosystem — with Excel users, data pipelines, or print — you export. And every export format involves trade-offs: what features survive, what gets flattened to static values, and what disappears entirely.

The export options are deceptively simple: File > Download > pick a format. But the differences between those formats determine whether your collaborator sees live formulas or frozen numbers, your conditional formatting or plain cells, your multi-sheet workbook or a single table. Understanding what each format preserves is the difference between a clean handoff and a "why is my data broken?" email.

Export Formats: What Each One Gives You

Google Sheets offers six export formats through File > Download:

Format	Extension	What's Preserved	What's Lost
Microsoft Excel	.xlsx	Formulas (standard), formatting, charts, multiple sheets, data validation, filters	QUERY, IMPORTRANGE, GOOGLEFINANCE, SPARKLINE, some conditional formatting rules
CSV	.csv	Cell values (active sheet only)	All formulas, all formatting, all charts, other sheets, data types
TSV	.tsv	Cell values (active sheet only)	Same as CSV
PDF	.pdf	Visual appearance (all sheets or selected)	All interactivity, formulas, editability
ODS	.ods	Formulas (standard), formatting, multiple sheets	Google-specific functions, some chart types
Web Page	.html	Table structure, basic formatting, multiple sheets as tabs	Formulas, charts (rasterized or omitted), interactivity

XLSX Export: The Best General-Purpose Option

XLSX is the highest-fidelity export from Google Sheets. It preserves:

Standard formulas: SUM, VLOOKUP, IF, COUNTIF, INDEX/MATCH, and most functions shared with Excel work correctly in the exported XLSX.
Formatting: Bold, italic, colors, borders, number formats, cell merges, column widths, row heights, and frozen panes all survive.
Multiple sheets: All sheets in the workbook are included, with their names and order preserved.
Charts: Bar, line, pie, and scatter charts export as native Excel charts. More complex chart types may render differently.
Data validation: Dropdown lists, numeric ranges, and custom validation rules transfer to Excel.
Conditional formatting: Color scales, data bars, and single-condition rules export correctly. Multi-condition rules and rules using Google-specific functions may not.

What XLSX export loses is specific to Google Sheets features that have no Excel equivalent. These are the big ones.

Google-Specific Functions That Don't Export

QUERY is the biggest loss. Google Sheets' QUERY function lets you write SQL-like queries against spreadsheet ranges: =QUERY(A1:D100, "SELECT A, SUM(D) WHERE C='Active' GROUP BY A"). There's no Excel equivalent. When you export to XLSX, QUERY formulas are replaced by their last computed values — the data is there, but the formula is gone. If the source data changes, the QUERY results won't update.

IMPORTRANGE pulls data from other Google Sheets workbooks. In XLSX export, the imported values become static. The link to the source workbook is severed.

GOOGLEFINANCE provides real-time stock data. Exported to XLSX, you get the last fetched price as a static number.

SPARKLINE creates inline mini-charts in cells. These are Google-only and vanish completely in XLSX export — the cell becomes empty.

IMAGE embeds web images in cells. In XLSX export, the image may be preserved as a static image or may disappear depending on the source URL.

Other Google-specific functions that become static values: IMPORTDATA, IMPORTHTML, IMPORTXML, IMPORTFEED, DETECTLANGUAGE, GOOGLETRANSLATE.

CSV and TSV Export: Values Only, One Sheet Only

CSV and TSV exports from Google Sheets produce the bare minimum: cell values from the currently active sheet, with no formatting, no formulas, no charts, and no other sheets.

Key behaviors:

Only the active sheet exports. If your workbook has 5 sheets and Sheet3 is selected, CSV export gives you Sheet3 only. To export all sheets, you must switch to each one and export separately (or use the API).
Formulas become values. A cell containing =A1+B1 that displays 42 exports as 42.
Dates export in the sheet's locale format. If your Sheet is set to US locale, dates export as 3/19/2026. UK locale: 19/03/2026. This is a common source of confusion when sharing internationally. There's no option to force ISO 8601 format on export.
Numbers lose custom formatting. A cell formatted as currency ($1,234.56) exports as 1234.56 (the value, not the display). Percentage-formatted cells export as decimals: 42% becomes 0.42.

The difference between CSV and TSV export is only the delimiter: comma vs. tab. TSV is slightly safer for data containing commas in text fields (addresses, descriptions). Both use UTF-8 encoding by default, which is one advantage over Excel's CSV export (which uses system locale encoding).

After exporting CSV from Google Sheets, you can convert to XLSX for sharing with Excel users, or convert to JSON for programmatic consumption.

PDF Export: Visual Snapshot with Layout Control

PDF export from Google Sheets produces a print-ready visual snapshot. Unlike CSV or XLSX, the output is designed for human viewing, not data interchange.

Google Sheets' PDF export settings are more granular than most people realize:

Page range: All sheets, current sheet, or selected cells.
Orientation: Portrait or landscape.
Paper size: Letter, A4, Legal, and many others.
Scale: Fit to width, fit to height, fit to page, or custom percentage.
Margins: Normal, narrow, or custom.
Headers/footers: Page numbers, sheet name, date, custom text.
Gridlines: Show or hide.
Notes: Include or exclude cell notes.

Charts are rasterized into the PDF at screen resolution. For high-quality chart exports, consider copying the chart to Google Slides first, then exporting as PDF — Slides renders charts at higher resolution.

If you need to extract data from a Google Sheets PDF, you'll need to round-trip through a data format: convert PDF to CSV (works for simple tables) or manually re-export from Google Sheets as CSV.

ODS Export: For LibreOffice and Open Standards

ODS (OpenDocument Spreadsheet) is the native format for LibreOffice Calc and an ISO standard. Google Sheets' ODS export is similar to XLSX export in fidelity — standard formulas, formatting, multiple sheets, and basic charts survive.

The trade-offs vs. XLSX export:

Better formula compatibility with LibreOffice. Some functions that get subtly mangled in XLSX export (like SUMPRODUCT with boolean conditions) export more cleanly to ODS.
Worse chart compatibility. Charts are less consistently rendered in ODS than XLSX, especially modern chart types like treemaps or waterfall charts.
Same Google-specific function losses. QUERY, IMPORTRANGE, GOOGLEFINANCE, and SPARKLINE become static values in ODS, just like XLSX.

Use ODS export when the recipient uses LibreOffice or when organizational policy requires open standard formats. For everyone else, XLSX is the safer choice. You can always convert ODS to XLSX or convert ODS to CSV later.

Programmatic Export: Google Sheets API and Apps Script

The Google Sheets API and Google Apps Script offer export capabilities beyond what the UI provides:

Google Sheets API — Export as file:

GET https://www.googleapis.com/drive/v3/files/{fileId}/export?mimeType=text/csv
GET https://www.googleapis.com/drive/v3/files/{fileId}/export?mimeType=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
GET https://www.googleapis.com/drive/v3/files/{fileId}/export?mimeType=application/pdf

This uses the Drive API's export endpoint. It exports the entire workbook (for XLSX/ODS/PDF) or the first sheet (for CSV/TSV). To export a specific sheet as CSV, you need the Sheets API: GET /v4/spreadsheets/{id}/values/{sheetName}!A:Z?alt=media.

Apps Script — Custom export:

function exportSheetAsCsv() {
  var sheet = SpreadsheetApp.getActive().getSheetByName('Data');
  var range = sheet.getDataRange();
  var values = range.getValues();
  var csv = values.map(row => row.join(',')).join('\n');
  DriveApp.createFile('export.csv', csv, MimeType.CSV);
}

Apps Script gives you full control: choose which sheets, which ranges, apply transformations, format dates in ISO 8601, handle QUERY results by reading computed values instead of formulas. For automated data pipelines, this is the recommended approach — you control exactly what gets exported and how it's formatted.

Which Export Format to Choose

Match the format to the recipient:

Excel user who needs to edit: XLSX. Highest fidelity, native compatibility.
Data pipeline / script: CSV via API. Values only, clean, parseable.
Client or manager for viewing: PDF. Professional appearance, no accidental edits.
LibreOffice user: ODS. Native format, best formula compatibility.
Web publishing: HTML. Embedded tables, basic formatting.
Bioinformatics / scientific: TSV. Standard in genomics and research data exchange.

If the recipient will further convert the file, choose the richest starting format. XLSX preserves the most information and can be converted to CSV, converted to JSON, or converted to PDF downstream without losing anything that wasn't already lost in the Google Sheets export.

Google Sheets' export is best understood as a translation, not a copy. Every format is a different language with different expressive power. XLSX is the closest translation — it preserves the most meaning but still can't express Google-specific concepts. CSV is a telegram: just the values, nothing else. PDF is a photograph: perfect visual reproduction, zero editability.

The practical strategy: know which Google Sheets features you depend on, check which survive in your chosen export format, and test with a sample before exporting a critical workbook. If you depend on QUERY or IMPORTRANGE, consider replacing them with standard formulas before exporting — or accept that those cells will contain frozen values in the exported file.

Key Takeaways

XLSX is the highest-fidelity export from Google Sheets. Use it when the recipient needs to edit formulas, see formatting, or work with multiple sheets.
QUERY, IMPORTRANGE, GOOGLEFINANCE, and SPARKLINE have no equivalents outside Google Sheets. They become static values in every export format.
CSV export from Google Sheets only includes the active sheet and loses all formulas, formatting, and data types. Dates export in the sheet's locale format, not ISO 8601.
Google Sheets exports CSV as UTF-8 by default (unlike Excel), which avoids encoding corruption for international text.
For automated export, use the Google Sheets API or Apps Script. They give you control over sheet selection, date formatting, and range specification that the UI export doesn't offer.
When in doubt, export as XLSX. It can be converted to any other format downstream without additional information loss.

Frequently Asked Questions

Why do my QUERY formulas disappear when I export to XLSX?

QUERY is a Google Sheets-only function with no Excel equivalent. When you export to XLSX, Google converts QUERY formulas to their last computed values — the numbers and text are preserved, but the formula is replaced by static data. If the source data changes, the QUERY results in the XLSX won't update. To maintain dynamic data in Excel, rewrite the QUERY as a combination of FILTER, SORT, and SUMIFS, which have Excel equivalents.

How do I export all sheets from Google Sheets to separate CSV files?

The UI only exports the active sheet as CSV. For multiple sheets, either switch to each sheet and export individually, or use Apps Script to iterate over all sheets and create separate CSV files: <code>SpreadsheetApp.getActive().getSheets().forEach(sheet => { ... })</code>. The Google Sheets API also supports per-sheet export by specifying the sheet name in the request URL.

Does Google Sheets export preserve conditional formatting in XLSX?

Partially. Simple conditions (greater than, less than, equal to, between) with color formatting export correctly. Color scales and data bars usually work. However, conditional formatting rules that use Google-specific functions or complex custom formulas may not transfer. Rules based on REGEXMATCH or QUERY conditions will be lost. Always verify conditional formatting after export by opening the XLSX in Excel.

Why are my dates wrong after exporting Google Sheets to CSV?

Google Sheets exports dates in the workbook's locale format. If your Sheet is set to US locale, dates export as M/D/YYYY (3/19/2026). If someone in Europe opens this CSV, they may read it as D/M/YYYY (March 19 vs. day 3, month 19 — which fails). Set your Sheet's locale (File > Settings > Locale) to match your audience, or better, format date columns as YYYY-MM-DD (ISO 8601) before exporting.

Can I export a Google Sheet to Parquet or JSON directly?

Not through the UI. Google Sheets' built-in export supports XLSX, CSV, TSV, PDF, ODS, and HTML only. For Parquet, export as CSV first, then <a href='/csv-to-parquet'>convert CSV to Parquet</a>. For JSON, export as CSV and <a href='/csv-to-json'>convert CSV to JSON</a>, or use the Google Sheets API to read cell values directly as JSON via the spreadsheets.values.get endpoint.

What happens to cell comments and notes when exporting?

In XLSX export, cell notes (the legacy comment system) are preserved as Excel comments. The newer threaded comment system in Google Sheets does not export to XLSX — threaded discussions are lost. In CSV and TSV export, all comments are stripped. In PDF export, notes can optionally be included as annotations. In ODS export, notes are preserved similarly to XLSX.

How do I export Google Sheets with images intact?

XLSX export preserves images that are inserted via Insert > Image > Image in Cell or Image over Cells. Images inserted via the IMAGE() function may not export because IMAGE() is a Google-specific function. PDF export rasterizes all visible images. CSV and TSV exports contain no images. For the most reliable image preservation, use XLSX export and verify in Excel that all images appear correctly.

Is the Google Sheets XLSX export compatible with older Excel versions?

Yes. Google Sheets exports XLSX in a format compatible with Excel 2007 and later. If the recipient uses Excel 2003 or earlier, they'll need the Microsoft Office Compatibility Pack (free download) or you should export as XLS instead — though Google Sheets doesn't offer direct XLS export. In that case, export as XLSX and <a href='/xlsx-to-xls'>convert XLSX to XLS</a>.

Ready to convert your files?

Use ChangeThisFile to convert between 600+ formats — free, fast, and private.

Start Converting