Data Processing
Spreadsheet-shaped data: merging, splitting, pivoting, converting between CSV, JSON and table formats. The tools exist because the interesting part is never the conversion itself — it is what happens to leading zeros, merged cells and headers with trailing spaces.
If a file will be read by a program afterwards, prefer the tool that shows you the resulting structure instead of one that only produces a download.
- BMI CalculatorBody Mass Index calculator with metric (cm+kg) and imperial (in+lb) units, four standards (International/Chinese/Japanese/Singapore), and BMI history tracking
- Chinese ID Card Validator & ParserValidate the check digit of an 18-digit Chinese ID number and parse the issuing region, birth date, gender and zodiac sign — all done locally in your browser.
- Currency ConverterConvert currency values using live exchange rates
- Group and pivotGroup a pasted table by any columns and aggregate the amount columns with sum, average, min, max, count, distinct count or median; also melt a wide table into a long one. The result can be pasted straight back into Excel
- Merge Identical CellsScan a sheet for vertically adjacent identical cells and merge them. Preview the count, then download.
- Multi-Workbook MergerMerge multiple Excel or CSV files into one workbook. Supports vertical stacking, one sheet per file, and key-column matching. Runs entirely in your browser.
- Number ProcessingBatch process numbers - add/remove thousands separators, convert to/from scientific notation, and convert between Roman and Arabic numerals (including Unicode variant). One-click copy and export.
- Number RoundingRound a column of numbers to a fixed number of decimals with half-up, banker's rounding, ceiling or floor, and apply one uniform arithmetic operation to all of them
- RMB Uppercase ConverterConvert numeric amounts into RMB/Renminbi capitalization (壹贰叁肆伍陆柒捌玖拾佰仟万亿元角分) following Chinese financial document conventions, for expense reports, invoices and contracts. Also supports English amount in words (SAY + currency + ONLY) and number-to-English/English-to-number conversion, one entry per line with per-row copy and Excel export.
- Split Merged CellsUnmerge merged cells and fill the original value into each cell as needed. Preview the count, then download.
- Table converterEditable grid that accepts pasted Excel/CSV/JSON/Markdown tables, converts to JSON, CSV, Markdown, HTML or TSV in one click, and exports to Excel (.xlsx).
- Table lookupA free VLOOKUP in the browser. Paste two Excel ranges, look rows up by key and choose which columns to return; supports exact, contains and starts-with matching, several conditions that must all match, one-to-many hits and a direct join of the two tables
- Table TransposePaste a TSV/CSV table to transpose, split into column-blocks, flatten into a single column, or merge into one row. All processing is local.
- Unit Converter
- XML Formatter and to JSONBeautify or minify XML, convert it to JSON while keeping attributes, and check tag pairing with an element count. Nothing is uploaded.
- YAML to JSON ConverterConvert between YAML and JSON both ways. Indentation mistakes are reported with line and column numbers. Supports any indent width.
Guides in this category
Common questions
Why did my leading zeros disappear?
The spreadsheet type-inferred the column as a number. Import with the column typed as Text, or keep the file away from Excel entirely.