universal-data-cleaner

📘 Universal Data Cleaner (CSV, Excel & Dataset) Clean, normalize, and standardize your datasets with one click.

The Universal Data Cleaner automatically transforms messy datasets into clean, uniform, business-ready data.

It supports:

CSV files

Excel files (.xlsx)

Apify datasets

and outputs:

Clean CSV

Clean Excel

Clean JSON

Clean Dataset (Apify Dataset)

✨ Features 🔹 Intelligent Data Cleaning

Automatically detects and cleans:

Name fields (Title Case, remove duplicates & noise)

Email fields (lowercase domain, trim whitespace)

Phone numbers

Detect PH mobile numbers

Convert to E.164 international format

Strip invalid characters

URL fields

Force HTTPS

Lowercase domain

Remove trailing slashes

Addresses

Trim spaces

Normalize casing

Collapse double spaces

🔹 Dataset Normalization

Remove duplicate rows

Remove duplicate rows using specific keys

Trim all whitespace

Standardize column casing globally (lower, upper, title)

Auto-detect column types

🔹 Multiple Output Formats

Choose the output format:

CSV

Excel (.xlsx)

JSON

Apify Dataset

📥 Input Configuration Example input: { "input_mode": "file", "input_file": "https://.../yourfile.csv", "output_format": "csv", "deduplicate_rows": true, "trim_whitespace": true, "standardize_case": "lower" } 📤 Output Your cleaned file appears in: Storage → Key-value store → OUTPUT You may also choose dataset output to load cleaned rows into an Apify dataset. 🧪 Example Cleaning

Before cleaning:

Name Email Phone URL aNThoNy Anthony.Dicosimo@DOMAIN.COM 112123809500 https://FACEBOOK.com/NationalGeneral

jAson jason.mccarthy@Domain.com 115715266000 https://facebook.COM/LeidosInc/

After cleaning:

Name Email Phone URL Anthony Anthony.Dicosimo@domain.com +112123809500 https://facebook.com/nationalgeneral

Jason jason.mccarthy@domain.com +115715266000 https://facebook.com/leidosinc 📊 Ideal Use Cases

CRM imports (HubSpot, Salesforce, GoHighLevel)

Lead lists from scrapers

Shopify product data cleanup

Excel normalization for analytics

Pre-processing before ML modeling

Cleaning of enterprise contact datasets 🧩 Integrations

Compatible with:

Zapier

Make.com

AWS Lambda

Python scripts

Google Sheets connectors

Any Apify Actor

No-code workflows 🚀 Publish & Monetize

This Actor is optimized for:

Apify Store (public listing)

Apify $1M Challenge

Fiverr lead-cleaning gigs

Upwork data-prep contracts

Enterprise workflows

❤️ Author

Built by Leoncio “Leo” Coronado Jr. — Python Automation Specialist — Apify Actor Developer — Data Pipeline Engineer — CRM & Shopify Data Automation