NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Import and export›Import a CSV file

Google Sheets · Verified tutorial

Import a CSV file in Google Sheets

The CSV rows are in A1:A4. Select A1:A4 and use Data > Split text to columns with Comma as the separator so the imported data fills A1:C4.

Verified by PhilisJuly 15, 2026About 60 seconds

Quick answer

The CSV rows are in A1:A4. Select A1:A4 and use Data > Split text to columns with Comma as the separator so the imported data fills A1:C4.

Step-by-step

1

Select the targetThe CSV rows are in A1:A4.

2

Apply the changeSelect A1:A4 and use Data > Split text to columns with Comma as the separator so the imported data fills A1:C4.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

The CSV content is imported into three clean columns with its header and all three records.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select A1:A4 and repeat the final action. The CSV content is imported into three clean columns with its header and all three records.

Example spreadsheet data

This is the clean fixture used for the verified run.

Product,Units,Region

Desk lamp,12,North

Monitor stand,8,South

Keyboard,15,West

Video transcript

Open the prepared CSV import spreadsheet.
Select the target. The CSV rows are in A1:A4.
Apply the change. Select A1:A4 and use Data > Split text to columns with Comma as the separator so the imported data fills A1:C4.
The CSV content is imported into three clean columns with its header and all three records.