Import CleanerImport Cleaner

Guides

Guides to data cleaning and data validation

Duplicates, encoding, ambiguous dates, data quality: practical guides to prepare a CSV or Excel file before importing it into a database, CRM or ERP.

  • How to remove duplicates in Excel and CSV files (step by step)

    Strict duplicates, duplicate emails, repeated IDs: the three families of duplicates and how to handle each without losing information.

    6 minRead the guide

  • Data cleaning software: a practical guide for CSV and Excel files

    Broken encoding, ambiguous dates, lost leading zeros, inconsistent nulls: the full run-through of a successful data cleaning pass.

    7 minRead the guide

  • CSV file validation: the checks to run before importing

    Delimiter, encoding, missing columns, unclosed quotes: the checks that prevent a failed import.

    5 minRead the guide

  • Data quality: the metrics to track on every import

    Completeness, uniqueness, validity, consistency, format accuracy: five simple metrics to judge a file.

    5 minRead the guide