In this section you will learn:
- What is a CSV file?
- Why using Google Sheets to open CSV file?
- How to import CSV into Google Spreadsheet?
- How to save a file to CSV format in Google Sheets?
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.