CSV quoting is the use of quotes around a value so commas, line breaks, and quotes inside the value do not break the CSV structure.
Example:
company,notes
Datablist,"CSV editor, deduplication tool, and enrichment platform"The comma inside the notes value is part of the text. It is not a column separator because the value is quoted.
When CSV values need quotes
A CSV value should be quoted when it contains:
- The delimiter, such as a comma or semicolon
- A line break
- A quote character
- Leading or trailing spaces you need to keep
In the common CSV format documented by RFC 4180, escape a double quote inside a quoted field by writing it twice:
company,quote
Datablist,"He said ""clean the file first"""⚠️ Broken quotes break rows
One missing quote can shift values into the wrong columns. This can corrupt CRM imports, deduplication checks, and enrichment mappings.
A quoted value can span several lines
company,notes
Datablist,"First line
Second line"
Example Co,"No line break"This file has two data records, each with two fields. The line break inside the first notes field belongs to that value. Counting physical lines in a text editor would give the wrong record count; use a CSV parser or editor instead.
The Terminal row-count guide explains when a line count can represent CSV records and when it cannot.
Do quotes change the value or its data type?
The surrounding double quotes are CSV syntax. After parsing, "Datablist" becomes Datablist, and "He said ""hello""" becomes He said "hello".
Quoting every field is valid, including fields without commas. Single quotes are not interchangeable with CSV double quotes: 'Paris, France' will still split at the comma in a normal comma-delimited CSV parser.
CSV quotes do not force a spreadsheet cell to stay text. Even "00124" can be interpreted as a number during import. Configure identifier columns as text in the receiving application if leading zeros must be preserved.
Quoting vs delimiter
The CSV delimiter separates fields. CSV quoting protects field values.
If a file uses commas as delimiters, values with commas must be quoted. If a file uses semicolons, values with semicolons must be quoted.
How to spot CSV quoting issues
You might have a quoting issue when:
- One row has more columns than the header
- Addresses split across several columns
- Long descriptions break into new rows
- A CRM import says the file has malformed rows
Open the file in a CSV editor before cleaning or importing it. Datablist helps you inspect columns before running data cleaning, deduplication, or enrichment.