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
Quotes inside quoted values are usually escaped by doubling them:
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.
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.