How to Export Data From Google Sheets to CSV
Export data from Google Sheets to CSV. Download one sheet, export a range, or publish a CSV link. Then check the file and convert it to XLSX if needed.
Your accounting system, online store, or database asks for a CSV file, and your data lives in Google Sheets. You can export data from Google Sheets to CSV in three clicks. The part to watch is what travels with the export and what gets left behind.
How to Export Google Sheets to CSV
- Open the spreadsheet in your browser and click the tab of the sheet you want to export.
- Choose File, then Download, then Comma Separated Values (.csv).
- Your browser saves the file in your downloads folder. The file name is usually the spreadsheet name joined with the sheet name.
Google Sheets exports only the active sheet. If your spreadsheet has five tabs, you get one CSV file from one tab.
Export Several Sheets or Part of Your Data
Several sheets. Repeat the steps above for each tab. Every tab produces its own CSV file.
Part of your data. Google Sheets does not export a selected range. A workaround exists:
- Select the cells you need and copy them.
- Create a new spreadsheet and paste the copied cells into the first sheet.
- Choose File, Download, Comma Separated Values (.csv).
Check the original sheet for hidden rows and columns before you export, so no data travels along without your knowing.
Publish a Sheet as a CSV Link
Developers often need a link that always points to the latest data. Google Sheets can publish one sheet as CSV.
- Choose File, then Share, then Publish to web.
- Pick the sheet you want to publish.
- Change the format from web page to Comma-separated values (.csv).
- Click Publish and copy the link.
Anyone who holds the link can read the data, even without a Google account. Do not use this route for personal or confidential data. The link also follows changes in your sheet unless you turn off the automatic republish option.
What Carries Over and What Does Not
CSV stores text only. Here is the comparison:
| In Google Sheets | In the CSV file |
|---|---|
| Formulas | The result values only |
| Colors, bold text, column widths | Gone |
| Images and charts | Gone |
| Other sheets in the same spreadsheet | Not included |
| Text | Saved with UTF-8 encoding |
| Separator between values | Comma |
Date and number values export as they appear in the cell, including currency symbols and the date format you chose. Open the result and check the date and currency columns before you send the file.
Check the Export With CSV Viewer
Before you upload the CSV to another system, confirm the contents. CSV Viewer on Kertaas opens the file in your browser without passing through Excel.
- Open CSV Viewer.
- Drag the CSV file into the upload area, or click to choose a file.
- The data appears as a table.
- Type a keyword in the search box to filter rows across every column.
Search for a few values you know exist in the source sheet, such as a name or an order number, and confirm the rows are complete. Your browser reads the file on your device, so nothing uploads. CSV Viewer displays and searches data only, so you cannot edit the contents.
Convert the CSV to XLSX When You Need an Excel File
If you are still in Google Sheets and need an Excel file, choose File, Download, Microsoft Excel (.xlsx). You do not need to export a CSV first.
CSV to XLSX helps when you only have the CSV file, such as an export a colleague sent you.
- Open CSV to XLSX.
- Choose your CSV file.
- Check the preview that appears.
- Click Download .xlsx.
The result is a standard .xlsx file that opens in Excel, Google Sheets, and LibreOffice Calc. The tool writes each value as plain text straight from the CSV. Excel usually still detects numbers, but custom date formats may need reformatting in Excel. A very large CSV, with hundreds of thousands of rows, slows the conversion because your browser does the work.
Common Problems
Only one sheet exported. Google Sheets exports the active tab. Export each tab separately.
Formulas turned into numbers. CSV does not store formulas. Keep a copy of the original spreadsheet if you still need the formulas.
Dates or currency look different. Values export as they appear in the cell. Change the column format in Google Sheets before you export.
Leading zeros disappeared. Zip codes and phone numbers lose their zeros when the cell uses a plain number format. Switch the column to Plain text in Google Sheets before you enter data. In Excel, import that column with the Text type.
The file opens in one column or shows broken letters in Excel. The data is intact, but Excel uses a different separator or encoding. Open the file through Data, then From Text/CSV, and pick the right separator and UTF-8 encoding.
Frequently Asked Questions
How do I export Google Sheets to CSV?
Open the tab you want to export, then choose File, Download, Comma Separated Values (.csv).
Can I export all sheets at once?
Not into one CSV file. Google Sheets exports one tab per file, so repeat the steps for each tab.
Do formulas export too?
No. CSV stores only the values that formulas produce.
Can CSV Viewer edit data?
No. CSV Viewer shows data as a table and filters rows through search. To edit, change the data in Google Sheets and export again.
Does my file upload when I use CSV Viewer or CSV to XLSX?
No. Your browser reads and converts the file, and no data goes to a server.
