Data cleaning & transformation tools

Choose the right shortcut

• Check a table before importing it into another system.
• Choose explicit cleanup rules and review what will change.

Read the selected tool’s instructions, supported formats and limits before starting. Review generated results before you use them.

18 tools that work now

• Merge & deduplicateCombine tables, review duplicate groups and choose which records to keep.
• Check data qualityFind missing values, duplicate keys and values that fail your column checks.
• Prepare catalog CSVMap product columns to a generic catalog CSV and review validation issues.
• Compress imageReduce image file size by adjusting quality or dimensions. Animation becomes one frame and camera/location metadata is removed.
• Compress PDF photosReduce supported embedded JPEG photos. Ordinary text and vectors remain; interactive features are not kept. A larger file is never offered.
• Clean spreadsheetChoose explicit text, whitespace and empty-row cleanup rules. Review the changes before exporting CSV or XLSX.
• Split & combine columnsSplit a text column by a delimiter or join selected columns. Preview the result before exporting.
• Email / lead-list cleanerNormalize email spelling, review invalid syntax and duplicates, and export clean/review lists.
• Unpivot spreadsheetTurn selected wide columns into explicit Variable / Value rows.
• Mask spreadsheet columnsReplace chosen columns with fixed masks or consistent random aliases.
• Encoding / identifier repairDecode CSV explicitly and pad or strip leading zeros in chosen digit-only columns.
• Inspect & remove metadataInspect supported image metadata or PDF document properties. Re-encode a still image as PNG or discard PDF top-level properties/XMP; embedded PDF picture metadata can remain.
• Fuzzy list matchingFind similar text keys across two tables and explicitly review suggested pairs. Original rows stay in the review export.
• Clean scanned imageWhiten paper and reduce uneven shadows with local grayscale brightness normalization. Review faint writing before using the PNG.
• Redact PDFReplace chosen visible areas with black pixels, then create and check a fresh image-only PDF. Selectable text and interactive content are discarded.
• Duplicate photo reviewCompare exact file hashes and bounded visual-similarity hints for 2–50 still photos. Review candidates yourself; nothing is deleted.
• Optimize GIFRe-encode bounded animated GIFs with preserved frame delays and loop. If it is not smaller, keep the original bytes.
• Remove portrait backgroundCreate a transparent PNG from a supported portrait using a local model. Review hair and soft edges; universal object cutouts are not promised.