Import CSV data into Google Sheets

Learn how to bring a CSV file into Google Sheets using the import menu, choose delimiter settings, and decide whether to replace or append a sheet.

3 min read6 viewsImport CSV data into Google Sheets
— · 0 votes
Contents
  1. Start from the File menu
  2. Check delimiter detection
  3. Replace or append the current sheet
  4. Questions about CSV import in Sheets
  5. How do I import CSV into Sheets?
  6. Can I import a CSV into an existing spreadsheet?
  7. What does delimiter detection do during a CSV import?
  8. What is the difference between replace and append on import?

You can import CSV data into Google Sheets through the File menu, which opens a CSV import panel where you pick the file and set how Sheets should read it. The process turns a comma-separated values file into editable rows and columns on a sheet. The choices you make about delimiters and about replacing or appending decide how the data lands.

Start from the File menu

The CSV import in Google Sheets starts from File > Import, which opens a panel for choosing the source file. You can upload a file from your computer or pick one already stored in your Google Drive. The panel then asks where the data should go, and the sheet you choose receives the parsed rows. Reading the preview before confirming lets you catch a wrong setting early.

Check delimiter detection

Delimiter detection decides which character separates one column from the next in the CSV file. Sheets reads commas by default, yet a file built elsewhere may use semicolons or tabs instead. You can let the tool guess or set the separator yourself in the import options. The preview updates as you change the separator, so you can confirm the columns line up.

Replace or append the current sheet

A CSV import can replace the contents of a sheet or append the new rows below what is already there. Replacing clears the existing cells before the imported data arrives, while appending keeps earlier rows and adds the file underneath. Choose replace when the file holds a fresh full dataset. Choose append when you are adding records to work already in the sheet.

Questions about CSV import in Sheets

How do I import CSV into Sheets?

You import a CSV into Google Sheets by opening the target spreadsheet and choosing File > Import. Pick the CSV file from your computer or Drive, then review the separator and destination options before you confirm. The rows appear as columns once the import finishes. Check the preview to confirm the columns are split correctly.

Can I import a CSV into an existing spreadsheet?

Yes, a CSV file can go into a spreadsheet you already have open in Google Sheets. The import panel offers a replace option that clears the current sheet first and an append option that adds rows below existing data. You can also create a new sheet for the import. Decide which destination matches how you want the data organized.

What does delimiter detection do during a CSV import?

Delimiter detection tells Google Sheets which character marks the boundary between columns in the CSV file. Commas are the standard separator, but semicolons and tabs also appear in exported files. The import preview shows how rows split as the delimiter changes. Setting the separator yourself fixes columns that arrive merged into one.

What is the difference between replace and append on import?

Replace overwrites the chosen sheet, while append adds the imported rows beneath existing content. Replace suits a file that represents the full dataset you want in that sheet. Append suits adding new records to data you already collected. Both options act on the destination sheet you select in the import panel.

Read next

Latest articles