CSV Canonicalizer documentation

Open CSV Canonicalizer · Explore Work & Tools · Avant Media Technology home

Purpose and features

CSV Canonicalizer is a small factual utility experiment for one CSV subset. It accepts pasted comma-delimited UTF-8 text up to 256 KiB, LF or CRLF record endings, and RFC-4180-style quoted fields. Embedded CRLF is accepted as quoted-field data, while a lone carriage return is refused even inside a quoted field. It produces canonical CSV output locally and refuses malformed input rather than repairing or guessing.

Supported use cases

Use it to review or normalize pasted CSV text that already fits the declared comma-delimited subset. It is useful when a receiving system requires consistent comma delimiters, minimal quoting, and CRLF record endings. It does not infer a dialect, repair malformed input, or handle files.

Before and after: normalize line endings

A two-record input using LF line endings:

name,city\n
Ada,"New York, NY"\n

becomes the same data with CRLF endings and one final CRLF:

name,city\r\n
Ada,"New York, NY"\r\n

The symbols \n and \r\n above describe line-ending characters; they are not added as visible text.

Before and after: remove unnecessary quoting

"name","city"\n
"Ada","London"

becomes:

name,city\r\n
Ada,London\r\n

Quotes remain when required, including around "New York, NY" because that field contains a comma.

Usage instructions

Paste CSV text, select Canonicalize locally, and review the output. When nonempty accepted output is available, Select canonical output selects and focuses the existing readonly output textarea for a manual browser copy. Copy canonical output uses the browser clipboard only when it is available; if it is unavailable, the same local textarea-only selection fallback is used. The fallback does not bypass browser permissions and does not provide a download guarantee. Clear text removes the page fields for the current interaction.

Examples

Input name,city followed by Ada,New York produces the same two records with CRLF line endings and one final CRLF. A field containing a comma must already be quoted, such as "Ada, Jr.",London.

FAQ

Does it upload or store pasted text? Pasted text remains in page memory for the current interaction. It is not uploaded, stored, sent over the network, or associated with an account. Use only data you are authorized to process; do not paste confidential data.

What happens to malformed input? The utility refuses malformed input rather than repairing or guessing.

Does it edit files? No. Paste text into the page, then copy the canonical output.

Troubleshooting

If copying is blocked by the browser, choose Select canonical output and use the browser or operating system copy command. If input is refused, review the reported line, column, and reason. Clear the page and try a smaller sample if the pasted text exceeds 256 KiB.

Known limitations and compatibility

The utility supports current browsers with JavaScript enabled. It accepts pasted comma-delimited UTF-8 text only. It does not handle file uploads, other delimiters, dialect inference, malformed-data repair, accounts, shared records, or persistent storage.

Pricing and use

CSV Canonicalizer is available free of charge on this website. No account is required.

Support and problem reports

Use the Avant Media Technology contact form to report a reproducible problem. Include the browser and operating-system versions and a synthetic example that does not contain confidential or regulated information. No response-time commitment is made.

Version and updates

This is version 1.0.0, released November 7, 2026. Material behavior or compatibility changes will be reflected on this page.

Removal and data

The utility stores no account or server-side work record to remove. Clear the text fields or close the page to end the current interaction. Avant Media Technology may withdraw or replace the hosted utility if a material defect is found.

Return to CSV Canonicalizer · Explore other Work & Tools · Return to Avant Media Technology