Export Google Sheets to CSV
in one click.
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.
Choose the method that fits your workflow.
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.
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.
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.
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.
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.
Common workflows where a CSV export is necessary.
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.
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.
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.
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.
Other free converters on CSVShift you might need.
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.
docs.google.com/spreadsheets/d/{ID}/export?format=csv — CSVShift generates this URL automatically from your sheet link.#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.