CSV & Spreadsheet Tools

Give a headerless CSV a proper header row.

Insert a sequential number column at the start of every row.

Find the rows that exist in one file but not the other, and spot header changes.

Add or remove the UTF-8 byte order mark so Excel opens your file correctly.

Delete named columns from a CSV, which is the safe way to redact a field before sharing.

Rename columns in bulk with a simple old = new list.

Move columns into the order you specify, keeping or dropping the rest.

Keep only the columns you name, in the order you name them.

Reorder the columns of a CSV alphabetically by name.

Profile every column: type, fill rate, distinct values, and min, max and mean for numbers.

Convert between comma, semicolon, tab and pipe separated files.

Replace text across the whole file or in named columns only, with optional regular expressions.

Convert a CSV between Windows (CRLF) and Unix (LF) line endings.

Append one CSV to another, checking that the columns match first.

Keep only the rows where a column matches your condition.

Sort rows by any column, numerically or alphabetically.

Find every cell containing a value, with its row number and column name.

Split a large CSV into numbered files of a fixed number of rows, each keeping the header.

Turn CSV data into a formatted XLSX workbook with a frozen header row.

Turn a CSV into a semantic HTML table with a proper header row.

Convert CSV rows into a JSON array of objects, with optional type detection.

Convert CSV into a Markdown table, ready for a README or an issue.

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

Generate INSERT statements and a matching CREATE TABLE from a CSV, with types inferred per column.

Convert comma-separated values to tab-separated values.

Convert a CSV table into XML, one element per row.

Open a CSV as a proper table, with a profile of every column and any parsing problems listed.

Open an XLSX workbook and read its sheets, properties and contents without Excel.

List the worksheets in a workbook, including hidden ones.

Split a workbook so each worksheet becomes its own XLSX file.

Convert an XLSX workbook to CSV - one file per worksheet.

Convert a workbook into JSON, with each row as an object keyed by the header.

Pull a single column out as a plain list, optionally deduplicated and sorted.

Pull out specific rows or ranges, keeping the header.

Report blank rows, rows with gaps, and which columns have the most missing values.

Report which rows repeat and how often, without changing the file.

Extract an HTML table into CSV, with entities decoded and tags stripped.

Convert an HTML table into Markdown for documentation.

Combine two or more columns into one, with a separator of your choice.

Turn a JSON array into CSV, flattening nested objects into dotted column names.

Turn a Markdown table back into CSV data.

Convert a Markdown table directly into an HTML table.

Flatten newline-delimited JSON records into a CSV table.

Delete repeated rows from a CSV, comparing whole rows or just the columns you name.

Drop columns that contain no data at all.

Delete rows where every cell is blank - the phantom records that break an import.

Strip the first row so the file is pure data.

Split one column into several on a separator, in place.

Remove leading and trailing whitespace from every cell and collapse internal runs.

Convert tab-separated values into proper quoted CSV.