Normalization Rules
How dataclean.to transforms messy, inconsistent data into clean, standardized formats.
What Is Normalization?
Real-world data is messy. Phone numbers come in dozens of formats. Prices mix currencies and symbols. Dates use different conventions depending on the country. Email addresses have random capitalization. Product codes are inconsistent.
Normalization is the process of taking this inconsistent data and converting it into a single, standardized format. When your data is normalized, it becomes reliable for use in APIs, structured data (JSON-LD), product feeds, advertising campaigns, and analytics.
dataclean.to automatically detects what type of data each column contains and suggests the best normalization rule. You can also choose or change the rule manually for any column.
How It Works
Upload your data
Import a CSV, Excel file, Google Sheet, or Airtable base.
Auto-detection
Each column is analyzed to detect its data type (phone, email, price, date, etc.) and a normalization rule is suggested.
Review and adjust
Preview the before/after results. Override the suggested rule if needed.
Export or use via API
Download your cleaned data as CSV, JSON, or Excel. Or access it via the hosted API and JSON-LD schema markup.
All Normalization Categories
dataclean.to includes over 30 normalization rules organized into the following categories. Click any category to learn more about its rules and see examples.
Text Cleaning
Trim whitespace, remove special characters, and clean text for safe output.
" Hello World " → "Hello World"
Email Normalization
Validate email format and standardize to lowercase.
"John@GMAIL.COM" → "john@gmail.com"
Phone Number Formatting
Convert any phone format to international E.164 standard.
"(555) 123-4567" → "+15551234567"
URL Normalization
Ensure all URLs have proper HTTPS protocol and clean formatting.
"example.com" → "https://example.com"
Price & Currency
Extract numeric prices, detect currencies, and standardize formats.
"$19.99" → "19.99 USD"
Date Formatting
Convert various date formats to ISO 8601 standard.
"January 15, 2026" → "2026-01-15"
Boolean Values
Convert yes/no, true/false, in stock/out of stock, and more to standard booleans.
"available" → "TRUE"
Number Conversion
Convert number words to digits.
"twenty-five" → "25"
Location Formatting
Standardize city/state names with proper capitalization and abbreviations.
"austin, texas" → "Austin, TX"
SEO Text Formatting
Title case, sentence case, URL slugs, meta tags, HTML stripping, and more.
"hello world" → "Hello World"
Google Ads Formatting
Truncate headlines and descriptions to Google Ads character limits.
30-char headlines, 90-char descriptions, keyword cleaning
Product Identifiers
Validate and format SKUs, GTINs/UPCs/EANs, and ISBNs.
"abc-1234" → "ABC-1234"
Currency Codes
Convert currency words and symbols to ISO codes or symbols.
"dollars" → "USD" or "$"
Rating Normalization
Extract clean numeric ratings from various formats.
"4.5/5" → "4.5"
Looking for the complete reference?
See every normalization rule with detailed before/after examples on a single page.
Complete Rules Reference