Universal Data Cleaner V3 – CRM & Excel Data Cleaning Tool

Universal Data Cleaner V3 (Professional Mode)

Enterprise-grade CSV/XLSX data cleaning and automation tool designed for real-world business workflows.

This Actor cleans messy datasets, fixes Excel formatting issues, normalizes emails and phone numbers, and prepares data for CRM systems, analytics pipelines, and e-commerce platforms like Shopify.

It can optionally automatically upload cleaned products to Shopify or send cleaned records to a CRM webhook.

Key Features

✅ Excel-proof phone normalization (1.12E+11 → '+112123809500) ✅ Header normalization and whitespace cleanup ✅ Email validation and normalization ✅ Phone normalization for international formats ✅ Removes empty rows and duplicates ✅ Shopify-ready dataset preparation ✅ Optional automatic Shopify product upload ✅ Optional CRM webhook integration ✅ Clean CSV export via Apify Key-Value Store

Typical Use Cases

This Actor is designed for real automation workflows:

CRM Data Preparation

• Prepare messy contact datasets for:
• GoHighLevel (GHL)
• HubSpot
• Salesforce
• Pipedrive
• Zoho CRM

E-commerce Product Import

Clean supplier datasets and automatically upload products to Shopify stores.

Data Pipeline Processing

Normalize scraped datasets before sending them to:

• data warehouses
• analytics pipelines
• automation systems

What This Actor Does

Given a CSV or XLSX dataset, the Actor performs the following cleaning pipeline:

1️⃣ Header Normalization

Column names are standardized:

• trimmed whitespace
• converted to lowercase
• on-word characters replaced with _

Example: Product Name → product_name Phone Number → phone_number

3️⃣ Trim Whitespace

All string values are trimmed.

Example: " John Doe " → "John Doe"

Email Cleaning

Emails are normalized:

• converted to lowercase
• validated using regex

Invalid emails are converted to: null

5️⃣ Excel-Safe Phone Number Cleaning

Handles common spreadsheet issues.

Example: 1.12124E+11 → '+112123809500

Processing steps:

• converts scientific notation
• removes non-digit characters
• rejects values shorter than 7 digits
• outputs phone numbers as

'+

The leading ' prevents Excel from auto-formatting the number.

6️⃣ Numeric Field Cleaning

Fields such as: price compare_at_price inventory weight

are normalized to clean numeric strings.

Duplicate Removal

Duplicate rows are automatically removed.

Input file_key (required)

Direct URL to the dataset file.

Supported formats:

• CSV
• XLSX

Example: { "file_key": "https://example.com/dataset.xlsx" }

output_mode (optional)

Defines the output structure.

Supported modes: general crm shopify

Example: { "output_mode": "shopify" }

upload_to_shopify (optional)

Automatically uploads cleaned products to Shopify.

Example: { "upload_to_shopify": true }

Additional fields required: shop_domain shopify_access_token

upload_to_crm (optional)

Sends cleaned records to a CRM webhook.

Example: { "upload_to_crm": true, "crm_webhook": "https://your-crm-endpoint.com/webhook" }

Example Shopify Input { "file_key": "https://api.apify.com/v2/datasets/XXXX/items?format=csv&clean=true", "output_mode": "shopify", "upload_to_shopify": true, "shop_domain": "your-store.myshopify.com", "shopify_access_token": "shpat_xxxxxxxxx" }

Output Dataset (Run Status)

Each run produces one dataset record summarizing the cleaning job.

Example: { "status": "success", "rows_before": 100, "rows_after": 94, "output_mode": "shopify" }

Cleaned CSV File

The cleaned dataset is stored in the Key-Value Store. Key: cleaned_products Content-Type: text/csv

This file can be downloaded or used in automation pipelines.

Shopify Upload Results (Optional)

If Shopify upload is enabled, the Actor will create products using the Shopify Admin GraphQL API.

Example result: shopify_uploaded_count: 50

Products will appear directly in your Shopify store.

Pricing (Apify Store)

Pay-per-event pricing.

Typical run cost: ≈ $0.001 – $0.01

depending on dataset size.

Most runs generate 1 dataset item per execution, making it extremely cost-efficient for automation pipelines.

Best Practices

• Use format=csv&clean=true when pulling datasets from Apify.
• Phone numbers are exported with a leading ' to prevent Excel formatting.
• Columns containing phone or mobile are treated as phone fields.
• Columns containing email are treated as email fields.

Automation Pipeline Example

This Actor is commonly used in automation pipelines:

Web Scraper ↓ Universal Data Cleaner ↓ Shopify Upload / CRM Import ↓ Business System

Support

If you need:

• custom CRM mappings
• Shopify catalog automation
• data pipeline integration
• custom field rules

contact the Actor author via the Apify Store.