What This Tool Does

This tool applies proper quoting to CSV fields according to RFC 4180, the standard for CSV format. Fields containing commas, double quotes, or newlines are wrapped in double quotes. Internal quotes are escaped by doubling them. Choose between minimal quoting (only when necessary) or quoting all fields.

RFC 4180 Quoting Rules

According to the CSV standard (RFC 4180):

Fields with commas: Must be quoted. "New York, NY" not New York, NY.

Fields with double quotes: Must be quoted, with internal quotes doubled. "He said ""Hello""" not He said "Hello".

Fields with newlines: Must be quoted to contain embedded line breaks.

Fields without special characters: Quoting is optional. Both John and "John" are valid.

Quoting Modes

RFC 4180 (minimal): Quote only fields that require it (contain comma, quote, or newline). Produces cleaner output.

Quote all fields: Wrap every field in quotes. Maximum compatibility with strict parsers.

Quote numeric fields: Optionally quote numeric values to preserve leading zeros and prevent type conversion.

Quote mode: Choose when to apply quoting based on your needs.

Example: RFC 4180 Mode

Input (inconsistent quoting):

name,address,quote
Alice,New York NY,Hello
Bob,"Los Angeles, CA",He said "Hi"
Charlie,Chicago,Normal text

Output (RFC 4180 compliant):

name,address,quote
Alice,New York NY,Hello
Bob,"Los Angeles, CA","He said ""Hi"""
Charlie,Chicago,Normal text

Example: Quote All Mode

Same input, quote all mode:

"name","address","quote"
"Alice","New York NY","Hello"
"Bob","Los Angeles, CA","He said ""Hi"""
"Charlie","Chicago","Normal text"}

When to Use This

Fix malformed CSV: Repair CSV files with missing or inconsistent quoting.

Prepare for strict parsers: Some systems require RFC 4180 compliant input.

Standardize exports: Ensure consistent quoting across CSV files from different sources.

Preserve numeric formatting: Quote numeric fields to preserve leading zeros (e.g., "00123" vs 123).

Database imports: Many database import tools expect properly quoted CSV.

Quote Escaping

Double quotes inside fields are escaped by doubling:

Input:  He said "Hello"
Output: "He said ""Hello"""

This is the standard CSV escaping mechanism, compatible with all RFC 4180 parsers.

Why Quote Numeric Fields

Unquoted numeric values may be interpreted differently by various tools:

Leading zeros: 00123 becomes 123 without quotes.

Long numbers: Credit card numbers over 15 digits may be converted to scientific notation.

Phone numbers: Values like 555-0100 may be interpreted as formulas or dates.

Limitations

Large files: Works best with files under 50MB. Very large files may cause slow performance.

Malformed input: Severely malformed CSV (unclosed quotes, inconsistent structure) may not process correctly.

Frequently Asked Questions

What's the difference between RFC 4180 and Quote All?

RFC 4180 quotes only when necessary (cleaner output). Quote All quotes every field (maximum compatibility, larger file size).

Does this fix unescaped quotes?

Yes. Quotes inside fields are properly escaped by doubling them.

Can this remove quotes instead of adding them?

No. This tool adds/normalizes quotes. To remove unnecessary quotes, use the CSV Unquote tool.