Format

Enclose all cells or text columns in quotation marks

Wrap all cells or specific text columns in quotation marks.

🛡️ Your rows never leave your browser.

Why Onfyt: Applies strict enterprise QUOTE_ALL formatting to satisfy strict legacy mainframe and banking intake requirements.

Interactive Sample Data

id	name	city
101	Grace	Nairobi
102	Peter	Mombasa

How this tool works

While minimal quoting (only quoting fields that contain commas, quotes, or newlines) is standard in modern tools, many legacy enterprise systems, ETL engines, and banking mainframes require strict `QUOTE_ALL` formatting where every cell is explicitly enclosed in quotation marks (`"value"`). Wrapping every value ensures that any unexpected commas or punctuation introduced into future records will never disrupt column position. DataFix allows you to quote all fields or selectively quote text columns while leaving numbers bare. Certain enterprise database ingest tools and legacy mainframes mandate that all CSV values—regardless of whether they contain delimiters or spaces—be enclosed in double quotes (strict quoting mode). Strict quoting prevents ambiguous whitespace interpretation, ensures that leading zeros in account numbers or postal codes are interpreted as strings rather than stripped numbers, and isolates trailing commas cleanly. DataFix processes each cell across your dataset, applying consistent quote wrapping around all fields while escaping any internal quote marks, producing a uniform, compliant CSV file ready for strict enterprise loaders. Legacy mainframes and strict enterprise ingestion pipelines require strict quote encapsulation for all fields. Encapsulating values in quotation marks preserves leading zeros in postal codes, social security numbers, and bank account identifiers, preventing spreadsheet programs from erroneously coercing text tokens into truncated integers. Enterprise loaders frequently require explicit quote encapsulation to prevent ambiguity around whitespace or leading zeroes in postal codes and account identifiers. Applying uniform quotation wrapping prevents spreadsheet software from coercing numeric strings into floating-point numbers, safeguarding critical alphanumeric identifiers.

Things that usually go wrong

Quoting a value that already contains quotes requires escaping the inner quotes — the tool does this automatically.
Some parsers reject all-quoted CSVs if they don't expect quoting around numeric values.

Edge cases we tested

🧪 Cells with internal quotes

Correctly doubled ("") when wrapped.

🧪 Values already wrapped in quotes

Leaves existing wrapping intact without creating double quotes.

Frequently Asked Questions

When would I need to quote all values?

When a downstream system requires strictly quoted CSV (some legacy mainframe importers), or when values may ambiguously start with '=' (Excel formula injection prevention).