Importing CSV into Google Spreadsheet

In this section you will learn:

What is a CSV file?

A CSV (Comma Separated Values) file is a text based format that represents the data typically found in a spreadsheet or a database table. It is a common format for data interchange as it is simple, compact and widespread.

Why using Google Sheets to open CSV file?

Google Sheet is an easy, safe and free way to open your CSV files. Additionally, many other spreadsheet solutions like Excel or Numbers do not preserve the CSV format and can create errors when importing back into erplain. This is why we recommend using Google Sheet to open and save your CSV files.

How to import CSV into Google Spreadsheet?

Step 1: Go to sheets.google.com


Step 2: Open the file picker



Step 3: Click on Upload

From this screen, you can select a file from your device or simply drag a file to the window to import it.




Your file should now display.

How to save a file to CSV format in Google Sheets?

Menu File > Download > Comma-separated values (.csv, current sheet)


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.