Updated: November 20, 2026

If you need to move data out of Google Sheets for another app, or bring a CSV into a spreadsheet, the process is quick once you know where Google keeps the export and import tools. The main trick is choosing the right sheet, the right file type, and the right import settings so your columns line up cleanly. Here is how to export Google Sheets to CSV, and how to bring a CSV back into Google Sheets without breaking the data.

Export a Google Sheet as a CSV file

To convert Google Sheets to a CSV file, open the sheet you want to download first. CSV export works on one tab at a time, not an entire workbook with multiple sheets in one file. If your spreadsheet has several tabs, repeat the export for each tab you want as a separate CSV.

  1. Open the Google Sheets file.
  2. Click the sheet tab you want to export.
  3. Go to File.
  4. Choose Download.
  5. Select Comma-separated values (.csv, current sheet).

Google saves the file to your device as a .csv download. If you were looking for how to save Google Sheets as CSV or how to turn Google Sheets to CSV, this is the exact path. The exported file keeps plain values, so formulas, formatting, charts, and multiple tabs do not carry over.

What happens during CSV export

A CSV file stores text and numbers in rows and columns, separated by commas. It is useful for importing into databases, email tools, shop systems, and other software that does not read Google Sheets directly. Because CSV is plain text, only the visible cell values export, not colors, borders, formulas, or notes.

If your sheet contains commas inside text, Google wraps that text in quotes so the file stays readable. If your data uses dates, special currencies, or merged cells, review the output carefully before you rely on it in another system.

Import a CSV file into Google Sheets

If you need to convert a CSV file to Google Sheets, the fastest method is to open a blank spreadsheet and import the file. This is the standard way to import CSV to Google Sheets, import data into Google Sheets, or use a CSV file in Google Sheets without manually pasting rows.

  1. Open Google Sheets.
  2. Create a blank spreadsheet or open the target file.
  3. Click File, then Import.
  4. Choose Upload.
  5. Drag in your CSV file or click to select it from your device.
  6. Pick an import option, then click Import data.

The import option matters. To add the CSV into a new tab inside the current file, choose to insert a new sheet. To replace the active sheet, choose to replace the spreadsheet. If you want the CSV placed into a fresh file, create a new spreadsheet during import. That is how to import a CSV file into Google Sheets without mixing it into the wrong tab.

Best import settings for most CSV files

Use the default delimiter setting if the CSV was created in the standard comma format. If the data looks split into the wrong columns, switch the delimiter to semicolon, tab, or custom, depending on the source file. For files with accented characters or symbols, choose the correct character encoding if Google asks for it, so the text does not appear broken.

For imported files with headers, leave the first row as headers. That keeps column names at the top instead of turning them into regular data. If the file includes formulas from another program, Google Sheets imports only the values, not the original formula logic.

Convert a CSV file to Google Sheets from Drive or your computer

There are two simple ways to change CSV to Google Sheets. You can import it from your computer using the import menu, or upload it to Google Drive and open it with Sheets. Both methods end with the same result, a spreadsheet you can edit, sort, filter, and share.

Open a CSV file directly in Sheets

If the CSV is already in Google Drive, click the file and choose to open it with Google Sheets. That is useful when you want a fast conversion without downloading and reuploading the file. Once open, the file becomes a spreadsheet copy that you can edit in Sheets.

Use upload when you need more control

If you need to decide how the data lands in Sheets, use the import menu instead. That gives you control over whether the CSV becomes a new sheet, a separate spreadsheet, or a replacement for the current tab. This is the better route when you want to import spreadsheet data into Google Sheets and keep your existing tabs intact.

Use Google Sheets to work with CSV data

After import, you can use the file like any other Google Sheet. Sort columns, apply filters, add formulas, create charts, and clean up headers before exporting again. If you need to export Google Sheets as CSV later, remember that only the active sheet exports, so keep the tab you want ready before downloading.

Common uses after import

  • Clean a customer list before uploading it to another tool.
  • Review product data, inventory rows, or order history.
  • Split one CSV into separate tabs for analysis.
  • Build formulas around imported rows, then export the final values.

If you are asking how to use import data in Google Sheets, the answer is to bring the CSV in first, then do your editing inside the spreadsheet. Once the data is in Sheets, the platform handles sorting, filtering, and sharing like any other spreadsheet file.

Fix common CSV import and export problems

Most CSV problems come from the file structure, not Google Sheets itself. If numbers land in one column when they should be in several, the separator does not match the file format. If text appears garbled, the encoding is wrong. If rows look cut off, the source file has broken line endings or embedded commas that were not quoted correctly.

When columns do not split correctly

Reopen the import flow and change the delimiter. A CSV from a European system may use semicolons instead of commas. A tab-delimited file needs the tab option. If a file that should be CSV still imports wrong, open it in a text editor and check whether commas, semicolons, or tabs separate the fields.

When the file looks different after export

Google Sheets exports only the current sheet, so tabs beyond the active one are left out. It also strips formatting, merged cells, comments, and formulas. If you need those elements preserved, CSV is the wrong format. Use a spreadsheet format instead. If you need plain data only, CSV is the correct choice.

Frequently Asked Questions

Can you convert Google Sheets to CSV?

Yes. Open the sheet you want, then use File and Download to save the current sheet as a CSV file. Each tab exports separately, so repeat the download for each sheet you need.

How do I import a CSV file into Google Sheets?

Open Google Sheets, go to File, choose Import, upload the CSV, and select how you want it placed. You can insert it as a new sheet, replace the current sheet, or create a new spreadsheet from it.

How do I download a CSV file into Google Sheets?

You do not download a CSV into Sheets directly. You import it into Sheets. Use the File and Import menu, then upload the CSV from your device or open it from Google Drive.

How do I save a CSV file in Google Sheets?

Upload the CSV into Google Sheets through the import menu. After the data is in the spreadsheet, Google Sheets saves it as a Sheets file in your Drive. The original CSV stays separate unless you delete it.

How do I import an Excel file into Google Sheets?

Use the same import menu. Google Sheets accepts Excel files through File, then Import, then Upload. After import, the workbook opens as a Google Sheets file, and you can edit it there.