CSV Formatter

What Is CSV Formatting?

CSV (Comma-Separated Values) formatting is the process of normalizing raw tabular text so that delimiters, quoting, whitespace, and line endings follow a consistent set of rules. RFC 4180, published in 2005, defines the most widely adopted CSV standard: fields separated by commas, records terminated by CRLF, and any field containing a comma, double quote, or newline wrapped in double quotes. A CSV formatter takes messy or inconsistent CSV data and rewrites it to match these conventions.

Real-world CSV files rarely arrive in clean form. Spreadsheet exports from Excel, Google Sheets, and database dump utilities each apply different quoting strategies, handle whitespace differently, and may use semicolons or tabs instead of commas. When you feed these files into a parser that expects strict RFC 4180 input, the result is often broken rows, shifted columns, or silent data loss. Formatting before processing catches these problems early.

A CSV formatter differs from a CSV converter. Formatting keeps the data in CSV. It normalizes quoting, trims stray whitespace, realigns columns, and optionally switches the delimiter. Converting changes the format entirely, producing JSON, HTML, SQL, or Markdown output.

Why Use This CSV Formatter?

This tool parses and re-serializes your CSV entirely in the browser. Your data never leaves your machine.

CSV Formatter Use Cases

CSV Quoting and Escaping Rules (RFC 4180)

RFC 4180 defines specific rules for when and how fields must be quoted. The six scenarios below cover the cases where quoting behavior matters.

CSV Delimiter Comparison

The choice of delimiter affects compatibility, readability, and how often you'll need quoted fields.

Code Examples

These examples show how to parse messy CSV and re-serialize it with consistent formatting in different languages. Each snippet handles whitespace trimming, delimiter normalization, and quoting.

import { parse, unparse } from 'papaparse'

const messy = `name, age ,city
Alice , 30, Berlin
Bob,25 , " Tokyo "`

// Parse with trimming, then re-serialize with consistent formatting
const parsed = parse(messy, {
  header: true,
  skipEmptyLines: true,
  transformHeader: h => h.trim(),
  transform: v => v.trim(),
})

const clean = unparse(parsed.data, { quotes: true })
console.log(clean)
// → "name","age","city"
// → "Alice","30","Berlin"
// → "Bob","25","Tokyo"

import csv
import io

messy = """name, age ,city
Alice , 30, Berlin
Bob,25 , " Tokyo " """

reader = csv.DictReader(io.StringIO(messy), skipinitialspace=True)
output = io.StringIO()
writer = csv.DictWriter(
    output,
    fieldnames=[f.strip() for f in reader.fieldnames],
    quoting=csv.QUOTE_ALL,
)
writer.writeheader()
for row in reader:
    writer.writerow({k.strip(): v.strip() for k, v in row.items()})

print(output.getvalue())
# → "name","age","city"
# → "Alice","30","Berlin"
# → "Bob","25","Tokyo"

package main

import (
	"encoding/csv"
	"fmt"
	"strings"
)

func main() {
	input := "name,age,city\nAlice,30,Berlin\nBob,25,Tokyo"
	r := csv.NewReader(strings.NewReader(input))
	records, _ := r.ReadAll()

	var buf strings.Builder
	w := csv.NewWriter(&buf)
	w.UseCRLF = true // RFC 4180 line endings
	for _, record := range records {
		_ = w.Write(record)
	}
	w.Flush()
	fmt.Print(buf.String())
	// → name,age,city\r\n
	// → Alice,30,Berlin\r\n
	// → Bob,25,Tokyo\r\n
}

# Re-format a CSV file with csvkit (Python-based)
csvformat -D ";" input.csv > output.csv

# Convert tabs to commas
csvformat -t input.tsv > output.csv

# Force-quote all fields
csvformat -U 1 input.csv > quoted.csv

# Using Miller (mlr) to normalize
mlr --icsv --ocsv --quote-all cat input.csv > clean.csv

Frequently Asked Questions