Understanding CSV Files
A CSV file is a simple file format used to store tabular data, such as a spreadsheet or database. Files in the CSV format can be imported to and exported from programs that store data in tables, such as Microsoft Excel.
CSV stands for "comma-separated values". Its data fields are most often separated by a comma. For example, let's say you had a spreadsheet containing the following data:
The above data could be represented in a CSV-formatted file as follow:
Sally Whittaker,2018,McCarren House,312,3.75
Belinda Jameson,2017,Cushing House,148,3.52
Jeff Smith,2018,Prescott House,17-D,3.20
Sandy Allen,2019,Oliver House,108,3.48
In a CSV file, each entry represents a cell in a spreadsheet, each line represents a new row, and each comma indicates where one entry ends and another one begins.
Important note: When you save a CSV file you can also set it's encoding. We only support uploading the below encoding types.
- Western (Windows 1252)
- Western (ISO 8859)
If you upload a CSV saved with another encoding it will either generate an error or even alter the data in your file causing undesirable results. To avoid these types of errors caused by encoding, use the Google Sheets method below.