How do I convert Google Sheets to CSV online?

Paste your Google Sheets URL into CSVShift. The tool generates a direct CSV download link from the spreadsheet ID. Click the link to download the CSV. Works for publicly shared sheets without any login.

Free Google Sheets exporter — no signup required

Export Google Sheets to CSV
in one click.

Q: How do I save Google Sheets as CSV?

File → Download → Comma-separated values (.csv) in Google Sheets. The CSV is downloaded to your device. If you need to automate this or share a download link, use the Google Sheets CSV export URL format: docs.google.com/spreadsheets/d/{ID}/export?format=csv&gid={GID}.

Generate a direct CSV download link from any public Google Sheets URL — or paste copied Sheets data to convert tab-separated content to a proper CSV file. No Google account needed for public sheets.

No data uploaded to any server

Direct export link from URL

Paste and convert

No signup required

Always free

Need the reverse? CSV to Google Sheets converter

Google Sheets to CSV 100% client-side

Method 1 — Generate CSV export link from Google Sheets URL

CSV export URL — click to download

The sheet must be publicly shared ("Anyone with the link can view") for this link to work without a Google login. For private sheets, use File → Download → CSV in Google Sheets directly.

Method 2 — Paste data copied from Google Sheets

First row

Output delimiter

CSV ready

All methods to export Google Sheets to CSV

Choose the method that fits your workflow.

Method 1 — File menu download (most common)

Open your Google Sheet → Click File in the menu bar → Download → Comma-separated values (.csv). This exports the currently active sheet tab as a CSV file to your Downloads folder. To export a different sheet, switch to that tab first.

Method 2 — Direct download URL (for public sheets)

If your sheet is publicly shared, you can generate a direct CSV download link using the format:
https://docs.google.com/spreadsheets/d/{SHEET_ID}/export?format=csv&gid={GID}
Replace {SHEET_ID} with your spreadsheet ID (from the URL) and {GID} with the sheet tab ID (the number after #gid= in the URL). Use the URL tool above to generate this link automatically.

Method 3 — Copy and paste (quick for small data)

Select the cells you want in Google Sheets → Ctrl+C to copy → paste into the text area above. Google Sheets copies data as tab-separated text. CSVShift converts it to proper RFC 4180 CSV with correct quoting. Works best for datasets under a few thousand rows.

Method 4 — Google Sheets API (for automation)

For automated exports in scripts: use the Sheets API with spreadsheets.values.get to fetch data as JSON, then convert with CSVShift's sister tool JSON to CSV. Or use the export URL method above in a wget or curl command with your OAuth token for private sheets.

Why Google Sheets TSV needs converting to proper CSV

What happens when you copy data from Google Sheets.

When you copy cells from Google Sheets with Ctrl+C, the clipboard receives tab-separated values (TSV) — not CSV. Tabs separate columns, newlines separate rows, and quoted fields may or may not be properly escaped. If you paste this directly into a .txt file and rename it to .csv, many tools will fail to parse it correctly.

CSVShift's paste mode converts the tab-separated clipboard content into RFC 4180 compliant CSV — proper comma delimiters, correct quoting of fields that contain commas or newlines, and UTF-8 BOM encoding for universal compatibility. The result is a CSV that opens correctly in Excel, Google Sheets, all databases and any data pipeline tool.

When do you need to export Google Sheets to CSV?

Common workflows where a CSV export is necessary.

Database imports

Data maintained in Google Sheets — contacts, product catalogs, configuration tables — often needs to be imported into a database. Exporting as CSV is the required first step for MySQL, PostgreSQL and most ETL tools that don't connect to Sheets directly.

Sharing with non-Google users

Recipients without a Google account cannot open a Sheets link. Exporting as CSV and attaching it to an email lets anyone open the data in Excel, LibreOffice or Numbers without a Google login.

Automation and scripting

Data pipelines and scripts typically expect flat CSV files, not Google Sheets URLs. Exporting to CSV — either manually or via the export URL — produces a file that any Python, R or command-line script can read without the Sheets API.

Importing into other tools

CRMs (Salesforce, HubSpot), email marketing platforms (Mailchimp, Klaviyo) and analytics tools (Tableau, Power BI) all accept CSV imports but not direct Google Sheets connections without paid integrations. Exporting as CSV is the universal workaround.

Related CSV tools

Other free converters on CSVShift you might need.

All spreadsheet converters

Two methods. Both
work without a server.

The URL export link is generated entirely in your browser by extracting the spreadsheet ID from the URL you paste — no server receives the URL. The paste converter processes your clipboard data locally in JavaScript. Neither mode transmits any data to CSVShift servers.

The CSV export URL format (export?format=csv&gid=...) is a documented Google Sheets feature — CSVShift simply constructs it from the components in your URL, saving you the manual effort of finding the spreadsheet ID and GID.

Direct export URL generator

Extracts spreadsheet ID and sheet GID from any Google Sheets URL format and builds the CSV export link instantly.

TSV to CSV converter

Converts the tab-separated clipboard format that Google Sheets uses when copying cells to proper RFC 4180 CSV.

UTF-8 BOM output

Downloads include the UTF-8 byte-order mark so special characters display correctly when re-imported to Excel or Sheets.

Free, no conditions

No watermark, no account. Funded by display advertising only.

Frequently asked questions

Common questions about exporting Google Sheets to CSV format.

How do I export Google Sheets to CSV?

In Google Sheets: File → Download → Comma-separated values (.csv). This downloads the active sheet as a CSV. For a shareable download link, paste the sheet URL into CSVShift and it generates a direct CSV export URL that works for publicly shared sheets.

How do I save Google Sheets as CSV?

File → Download → Comma-separated values in Google Sheets saves the current sheet as a .csv file. If the sheet is publicly shared, you can also use the direct URL format: docs.google.com/spreadsheets/d/{ID}/export?format=csv — CSVShift generates this URL automatically from your sheet link.

How do I get a CSV download link for a Google Sheet?

Paste your Google Sheets URL into the URL field above and click Generate link. CSVShift extracts the spreadsheet ID and sheet GID to build the export URL. The sheet must be publicly shared (Anyone with the link can view) for the link to work without a Google login. Private sheets require authentication.

How do I export a specific sheet tab to CSV?

Each sheet tab in Google Sheets has a unique GID number visible in the URL as #gid=1234567890. Navigate to the tab you want to export and copy the URL from the browser — CSVShift will extract the correct GID and generate an export link for that specific tab.

How do I convert Google Sheets data to CSV by pasting?

Select the cells in Google Sheets, copy with Ctrl+C, then paste into the text area in CSVShift's Method 2 panel. The clipboard data arrives as tab-separated text — CSVShift converts it to proper comma-separated CSV with correct quoting and UTF-8 encoding. Click Convert and download.

Export Google Sheets to CSV in one click.