CSV Tools

Convert NUL byte-separated values back into standard comma-delimited CSV.

Convert a JSON array-of-arrays literal back into properly quoted RFC 4180 CSV text.

Decode a Base64 string back into readable CSV text.

Best-effort auto-repair for broken CSV: closes unterminated quotes, fixes ragged rows, normalizes line endings.

Get row count, column count, per-column inferred type, and per-column unique-value count for a CSV file.

Generate a fun, self-contained animated .html file that flips through a CSV's rows one at a time.

Replace real values in chosen columns with consistent pseudonyms, preserving which rows share a value.

Keep only CSV rows where one chosen column matches equals, contains, regex, or a numeric threshold.

Replace any cell matching a word list or regex with a censor mask, across all or chosen columns.

Render a CSV as color-coded HTML, one distinct color per column, for pasting into rich-text destinations.

Insert a new column at the very end (rightmost) of every row in a CSV.

Compute the arithmetic mean of a chosen CSV column's numeric values, skipping non-numeric cells.

Count a CSV's columns from the header row, and flag ragged rows that have extra columns.

Delete a single column from a CSV by index or header name.

Extract a single column from a CSV into its own single-column CSV.

Insert a new column at any position you choose in a CSV.

Insert a new column at the very start (leftmost) of every row in a CSV.

Rename one or more CSV header names via oldName:newName pairs.

Replace an entire column's data-row values with a constant or a per-row list.

Cyclically shift a CSV's column order left or right by N positions.

Randomly reorder a CSV's columns, header and data moving together, using a crypto-backed shuffle.

Reorder a CSV's columns alphabetically by header name, ascending or descending.

Sum the numeric values in a chosen CSV column, skipping non-numeric cells, or sum every column at once.

Swap the positions of two columns in a CSV by index or header name.

Trim leading/trailing whitespace from every cell in a chosen CSV column, or every column at once.

Truncate every cell in a chosen CSV column to at most N characters.

Extract one CSV column's values, by index or header name, as a JSON array of strings.

Extract one CSV column's values, by index or header name, as a plain newline-separated list.

Turn each column of a CSV into its own row.

Remove lines whose first non-whitespace character is #, an informal but common CSV comment convention.

Compare two CSVs cell by cell and get a structured summary of row and cell-level differences.

Gzip-compress CSV text with the browser's real CompressionStream API and download it as a .csv.gz file.

Keep only specified columns from a CSV, by index or header name, Unix cut-style, dropping the rest.

Search every cell in a CSV for a substring or regex match, with exact row and column coordinates.

Decrypt a base64 blob produced by CSV Encryptor back to the original CSV text, given the passphrase.

Remove exact-duplicate CSV rows, keeping the first occurrence, with the header preserved.

Re-parse delimited text with one delimiter and re-serialize it with another of your choice.

Compare two CSV texts line by line in a unified diff format, like diff -u, with - and + markers.

Report a CSV's row count, column count, and raw byte size all in one pass.

Re-encode CSV text's underlying bytes between UTF-8, UTF-16LE/BE, and windows-1252.

Encrypt CSV text with AES-256-GCM using a passphrase, via the browser's Web Crypto API.

Deliberately inject malformed rows into a clean CSV to test how your parser handles bad data.

Truncate CSV rows that have more fields than the header down to the header's cell count.

Combine two CSV files into one, aligning columns by header name or stacking rows positionally.

Remove whatever the literal first line of a CSV file is, whether or not it's a real header row.

Strip the header row from a CSV file, keeping only the data rows.

Pad every short CSV row with empty trailing cells so all rows match the header's cell count.

List every CSV data row whose cell count doesn't match the header, with row numbers.

Hide (and reveal) a secret text message inside a CSV's trailing whitespace, a fun novelty, not real security.

Force every CSV field to be quoted, regardless of whether it needs it.

Change the quote character used in CSV data, e.g. from double quotes to single quotes, re-escaping fields as needed.

Strip unnecessary quote characters from CSV fields, keeping quotes only where RFC 4180 requires them.

Compute each CSV row's mean numeric value and append it as a new 'average' column.

Count a CSV's data rows, excluding the header, with the header-inclusive total shown too.

Cyclically shift a CSV's data row order up or down by N positions, header fixed.

Randomly reorder a CSV's data rows while the header stays fixed at the top, using a crypto-backed shuffle.

Sort a CSV's data rows by a chosen column, ascending or descending, numeric or lexicographic.

Sum the numeric values across each CSV row and append the result as a new 'sum' column.

Emit every CSV data row as its own JSON array of strings, wrapped in one outer array.

Turn each row of a CSV into its own column.

Flatten each CSV data row into one list item, with cells joined by a configurable separator.

Strip delimiter characters from CSV, joining each row's cells with a single space to produce plain text.

Minify a CSV: strip unneeded quotes, trailing whitespace, blank lines, and empty trailing columns.

Keep only data rows within a start:end range, Python-slice style, with the header always preserved.

Pretty-print a CSV by padding after each delimiter so columns line up visually, delimiters stay intact.

Convert comma-delimited CSV into NUL byte-separated values.

Render CSV as an ASCII table with the header and borders wrapped in ANSI color codes.

Convert a CSV's whole grid, header included, into a JSON array-of-arrays literal.

Render CSV as a plain-text table using only -, |, and + border characters.

Base64-encode raw CSV text so it can travel safely through text-only transports.

Turn a CSV with latitude/longitude columns into a GeoJSON Point FeatureCollection.

Convert comma-delimited CSV into hash (#)-delimited values.

Convert CSV rows into an HTML <table>, with the header row as <th> cells.

Render a CSV as a heatmap-style image, coloring each cell by its value.

Convert CSV rows into INI sections, using the first column as the section name.

Convert CSV rows into newline-delimited JSON (JSON Lines), one object per line.

Convert CSV rows into a LaTeX tabular environment with \hline rules.

Convert CSV rows into a GitHub-flavored Markdown pipe table.

Render a CSV as a literal nested-array/matrix in JS, Python, or JSON syntax.

Render a CSV as a monospace table inside a real, downloadable PDF file.

Convert comma-delimited CSV into pipe-delimited PSV.

Wrap every CSV field in double quotes: this site's own "qCSV" shorthand.

Render a CSV as a clean, styled table image (PNG) you can paste anywhere.

Generate a CREATE TABLE statement and INSERT statements from CSV rows.

Write a CSV into a real, openable SQLite3 database file, one TEXT-only table.

Convert comma-delimited CSV into semicolon-delimited SSV.

Convert CSV into human-readable, space-padded, fixed-width text columns.

Convert comma-delimited CSV into tab-delimited TSV.

Download CSV content as a .txt file, unchanged, for tools that insist on a .txt extension.

Render CSV as a clean plain-text table using Unicode box-drawing characters.

Convert CSV contact rows into vCard 3.0 BEGIN:VCARD blocks.

The canonical, parameter-free matrix transpose: swap a CSV's rows and columns wholesale.

Decode a percent-encoded string back into readable CSV text.

Percent-encode CSV text so it can be embedded in a URL query string or path segment.

Check CSV for ragged rows, unclosed quotes, and inconsistent line endings, with a line-numbered issue list.

Randomly reorder every individual cell value across the whole grid, independent of row or column shuffling.

View a CSV as a clean, scrollable table with clickable, sortable column headers.

Pick a numeric column and a label column, get an instant SVG bar chart, no spreadsheet needed.

Apply Zalgo combining-character corruption to every cell's text, while keeping rows/columns intact.

Strip Zalgo combining characters back out of every CSV cell, restoring clean, readable text.

Define named, typed columns (text, number, boolean, date) and generate a full CSV with plausible placeholder values.

Delete any CSV column where every data-row cell is empty.

Generate a CSV containing only a header row, no data, from a list of column names.

Remove fully blank raw lines from CSV text, before any parsing happens.

Delete any CSV data row where every cell is empty, keeping the header untouched.

Remove empty trailing cells within each CSV row, cleaning up ragged trailing commas like a,b,,, into a,b.

Flatten a GeoJSON Point FeatureCollection into a lat/lon CSV.

Convert hash (#)-delimited values back into standard comma-delimited CSV.

Parse the first <table> in a block of HTML back into CSV rows.

Export an image's raw pixel colors as a CSV grid, not table/OCR recognition.

Convert INI sections into CSV rows, one row per section.

Convert JSON Lines (one JSON object per line) into CSV rows.

Generate a large placeholder CSV, by row/column count, for load-testing parsers and pipelines.

Parse a Markdown pipe table (header + --- separator + rows) back into CSV.

Extract a simple, table-like text PDF's rows and columns back into CSV.

Convert pipe-delimited PSV into standard comma-delimited CSV.

Minimize a fully-quoted "qCSV" file's quoting back to ordinary CSV.

Parse simple INSERT INTO ... VALUES statements back into CSV rows.

Read a simple, single-table SQLite database file's rows back into CSV.

Convert semicolon-delimited SSV into standard comma-delimited CSV.

Parse whitespace-aligned, fixed-width text columns back into proper comma CSV.

Convert tab-delimited TSV into comma-delimited CSV.

Re-offer a .txt file's content as .csv, wrapping unstructured lines into valid CSV when needed.

Extract name, email, phone, org, and title from vCard blocks into CSV rows.