Paste CSV into Google Sheets—and Check the Result

To paste CSV into Google Sheets, select an empty starting cell and paste the text. If each row lands in one column, select those cells, then choose Data → Split text to columns and set the separator to Comma. Google documents this workflow for clearly delimited text in its split-text instructions.

Use this shortcut for a small, simple dataset. For CSV containing quoted commas, embedded line breaks, or identifiers with leading zeros, prefer the file-import workflow below.

Paste a simple CSV

This invented sample represents a small public-data summary:

area,year,observations
North,2025,128
South,2025,96

In the desktop web version of Google Sheets:

1. Open a blank sheet, or choose an empty area with room to the right and below.
2. Copy only the CSV text—not the code-block markers.
3. Click A1 once to select it. Don’t enter cell-editing mode or paste into the formula bar.
4. Paste with Ctrl+V on Windows or Command+V on Mac.
5. If the data already occupies three columns, leave it alone. If it occupies only column A across three rows, select A1:A3.
6. Choose Data → Split text to columns. In the Separator dropdown, choose Comma.

The expected result is three columns and three rows, including the header. Cell A2 should contain North, B2 should contain 2025, and C2 should contain 128.

If everything lands inside A1 rather than in separate rows, undo and try pasting with the cell selected—not being edited. If it still lands in one cell, use file import instead. If the text uses semicolons or tabs instead of commas, select the matching separator rather than forcing Comma.

Import a file when CSV structure matters

A comma can be part of a value, not just a column boundary:

area,note,observations
North,"Survey, revised",128

Here, Survey, revised is one field. CSV convention uses double quotes around fields containing commas, line breaks, or quotes; an internal quote is escaped as two quotes. RFC 4180 documents these conventions.

For this kind of data, prefer file import over a simple delimiter split:

1. Keep the original CSV file. If you only have CSV text, save it in a plain-text editor with a .csv extension.
2. In Google Sheets, choose File → Import → Upload and select the file.
3. Choose Create new spreadsheet to keep the imported data separate from existing work.
4. Choose Comma as the separator for comma-delimited CSV, or the separator actually used by your source.
5. If literal values matter—such as an ID 00127—uncheck Convert text to numbers, dates, and formulas before importing.
6. Import the file and check a row containing quoted text. The example above should still have three columns.

Google’s file-import documentation explains the separator choices and import destinations. Avoid Replace spreadsheet or Replace current sheet unless you intend to overwrite existing content.

Disabling text conversion keeps number-like and date-like text from being automatically interpreted; you can convert measurement columns deliberately afterward. This import-option walkthrough explains the leading-zero and date-conversion risks. Check the imported values against the original rather than relying on their appearance alone.

Check the table before publishing

Before treating the sheet as a finished dataset, check:

• Structure: every record has the expected fields, with no values shifted into neighboring columns.
• Completeness: the record count matches the source; count data rows separately from the header. A quoted field can contain a line break, so physical lines in the CSV are not always separate records.
• Values: inspect leading-zero IDs, dates, decimals, accented text, and blank fields against the original.
• Documentation: retain the source, collection date, units, and any cleaning decisions alongside the dataset.

For a reviewed publication copy, follow the CSV export checklist. TablePage accepts CSV, TSV, XLSX, and XLS uploads and turns them into public dataset pages with a shareable link and filterable table. Upload only data cleared for public release—never sensitive information.

If the source is a public CSV URL rather than clipboard text, use the separate Google Sheets IMPORTDATA workflow.