data.cleaner Browser local
THE COMPLETE TOOLKIT

36 tools, one tidy workspace.

Search by the data problem you're solving. Each tool includes local input, an explanation, an output preview and a downloadable result when applicable.

CSVCSV CleanerRemove excess whitespace and empty rows while preserving quoted CSV fields.Open workbench CSVCSV Duplicate Row RemoverFind and remove duplicate records with a clear count of removed rows.Open workbench CSVCSV Column RenamerRename CSV headers without editing data cells.Open workbench CSVCSV Column ExtractorChoose and export selected CSV columns in the order you need.Open workbench CSVCSV Missing Value CheckerCount blank values by column and inspect completeness.Open workbench CSVCSV Fill Missing ValuesFill blank CSV cells with a chosen safe value.Open workbench CSVCSV Email ValidatorFlag rows with invalid-looking email addresses in a chosen column.Open workbench CSVCSV Phone Number CleanerNormalize formatting characters in phone columns without guessing countries.Open workbench CSVCSV Delimiter ConverterConvert valid CSV records into TSV, semicolon or pipe-delimited text.Open workbench CSVCSV Row SorterSort CSV records by a selected column.Open workbench CSVCSV Row FilterKeep rows where a selected column contains a search term.Open workbench CSVCSV File MergerMerge two CSV datasets using aligned column names.Open workbench CSVCSV Text Case ConverterChange the letter case of a selected CSV column.Open workbench PrivacyCSV Personal Data ScannerEstimate possible email and phone patterns in CSV data.Open workbench PrivacyCSV Personal Data RedactorMask email and phone-like patterns before sharing a dataset.Open workbench CSVCSV Date NormalizerNormalize explicitly supported dates into ISO YYYY-MM-DD.Open workbench DiagnosticsCSV Data ProfilerInspect row counts, distinct values and numeric ranges.Open workbench SecurityCSV Formula Injection CheckerFind spreadsheet formula-like cells that may be unsafe to import.Open workbench JSONJSON FormatterValidate and pretty-print JSON data with readable indentation.Open workbench JSONJSON Syntax ValidatorCheck whether JSON parses and find the error location.Open workbench JSONJSON Object FlattenerFlatten nested JSON objects into dotted keys.Open workbench JSONJSONL Line ValidatorValidate JSON Lines records and keep valid lines.Open workbench ConversionTSV to CSV ConverterConvert tab-separated files into properly quoted CSV.Open workbench TextDuplicate Text Line RemoverRemove repeated text lines and keep the first occurrence.Open workbench ExcelXLSX Sheet to CSVExport a selected worksheet as UTF-8 CSV using cached cell values, without executing formulas.Open workbench ExcelXLSX Worksheet InspectorList worksheet names, row counts and formula presence before exporting.Open workbench ExcelXLSX Duplicate Row CleanerRemove identical rows from one worksheet and download a new CSV.Open workbench ExcelXLSX Blank Row CleanerRemove completely blank rows from one worksheet and export CSV.Open workbench ExcelXLSX Column ExtractorChoose worksheet columns by header name and export selected CSV fields.Open workbench ExcelCSV to XLSX WorkbookBuild a real one-sheet XLSX workbook from valid CSV with all cells stored as text.Open workbench CSVCSV Deduplicate by KeyRemove rows sharing one selected key while keeping the first record.Open workbench CSVCSV Literal Find and ReplaceReplace literal text in a selected column without regular expressions.Open workbench CSVCSV Data Type AuditProfile likely number, ISO date, blank and text values by column.Open workbench CSVCSV Whitespace ReportFind leading, trailing and repeated whitespace in CSV cells.Open workbench CSVCSV Join by KeyLeft-join two CSV datasets using a unique key field.Open workbench CSVCSV Split Text ColumnSplit one CSV text column into two fields at the first literal separator.Open workbench