Clean Data Tools
Browse all 48 free in-browser clean utilities. Your rows never leave your browser.
Split Full Name into First and Last
Separate full name columns into dedicated first_name and last_name columns in CSV and Excel spreadsheets.
Launch Tool →Combine First and Last Name
Merge separate first and last name columns into a single clean full_name column, trimming extra spaces.
Launch Tool →Remove Duplicate Rows
Eliminate duplicate rows across your entire dataset or based on specific unique key columns.
Launch Tool →Fix Phone Numbers
Strip punctuation, resolve leading zeros, and format phone numbers with proper country codes.
Launch Tool →Phone Numbers to E.164
Standardize phone numbers into strict E.164 format (+
Trim Whitespace
Clean up accidental leading, trailing, and duplicate spaces across all columns in your spreadsheet.
Launch Tool →Change Text Case
Transform column text into UPPERCASE, lowercase, Title Case, Sentence case, or camelCase across your spreadsheet.
Launch Tool →Remove Empty Rows
Delete blank lines and rows containing only empty cells or whitespace across your entire spreadsheet.
Launch Tool →Remove Empty Columns
Detect and remove completely blank columns or columns containing only empty values across your dataset.
Launch Tool →Standardize Dates to ISO
Transform mixed and regional date formats into standardized ISO 8601 strings (YYYY-MM-DD).
Launch Tool →Fix Mixed Date Formats
Harmonize columns containing a mixture of slashes, dashes, text months, and timestamps into one uniform format.
Launch Tool →Remove Special Characters
Strip invisible control characters, non-ASCII symbols, smart quotes, and unwanted punctuation from spreadsheet cells.
Launch Tool →Merge Columns
Concatenate multiple columns into a single unified column using custom delimiters (space, comma, hyphen, slash).
Launch Tool →Split a Column by Delimiter
Divide single cell values into multiple new columns based on delimiters like commas, slashes, hyphens, or spaces.
Launch Tool →Extract Domain from Email
Parse email addresses to extract website domain names into a dedicated column for lead enrichment and corporate classification.
Launch Tool →Clean an Email List
Scrub email lists by fixing syntax errors, trimming spaces, removing duplicates, and lowercasing addresses.
Launch Tool →Fix Currency and Number Formats
Strip currency symbols ($ , € , £ , KES), resolve thousands commas, and format numbers into clean numeric decimals.
Launch Tool →Fix a Messy CSV Export
Diagnose and repair common CSV corruptions: unclosed quotes, broken delimiters, jagged row lengths, and encoding glitches.
Launch Tool →Remove Duplicate Emails
Deduplicate subscriber and customer lists based exclusively on normalized email addresses.
Launch Tool →Fix Name Capitalization
Transform SHOUTING all-caps or all-lowercase names into natural Title Case with cultural naming rule support.
Launch Tool →Add or Remove Leading Zeros
Pad numbers with leading zeros to meet fixed-width requirements (e.g. 00123) or strip unnecessary leading zeros.
Launch Tool →Fix ZIP and Postal Codes
Repair postal codes damaged by Excel auto-truncation, format US ZIP+4, and standardize UK and Canadian formats.
Launch Tool →Standardize Country Names and Codes
Convert inconsistent country names ("USA", "US", "United States") to standardized ISO 3166-1 alpha-2, alpha-3, or full country names.
Launch Tool →Standardize State Abbreviations
Convert US, Canadian, and Australian state names to official 2-letter postal codes (e.g. CA, NY) or expand codes to full names.
Launch Tool →Remove HTML Tags from Cells
Strip HTML markup tags and decode HTML entities from product descriptions, CMS exports, and scraped text.
Launch Tool →Remove Line Breaks Inside Cells
Remove internal carriage returns and newline characters inside cells that cause broken CSV rows and database parsing errors.
Launch Tool →Fix Garbled Characters (Encoding)
Repair character encoding glitches (mojibake) caused by Windows-1252 or ISO-8859-1 interpreted as UTF-8 (e.g. é -> é, ’ -> ').
Launch Tool →Remove Emojis from Text
Remove emojis, pictographs, and Unicode symbols from social media text, customer reviews, and feedback.
Launch Tool →Standardize Yes/No Values
Normalize inconsistent boolean flags across your dataset into standard True/False, Yes/No, or 1/0 formats.
Launch Tool →Find and Replace in CSV
Replace text values across all cells or within specific columns in a CSV file.
Launch Tool →Regex Replace in CSV
Apply regex patterns with capture groups to transform cell values across CSV columns.
Launch Tool →Truncate Text in Cells
Trim CSV cell values to a specified maximum character length with optional ellipsis.
Launch Tool →Fill Down Blank Cells
Forward-fill blank cells by propagating the last non-blank value down through a CSV column.
Launch Tool →Fill Missing Values
Replace blank CSV cells with a constant, column mean, median, previous value, or 'Unknown'.
Launch Tool →Convert Text to Numbers
Strip formatting from text-formatted number columns to produce clean numeric values.
Launch Tool →Clean URLs (Remove Tracking Parameters)
Strip UTM parameters, fbclid, gclid, and marketing tracking tokens from CSV URL columns.
Launch Tool →Split an Address into Parts
Split unformatted postal addresses into clean structured address columns.
Launch Tool →Normalize Company Names
Harmonize company name variations, legal suffixes, and capitalization across your account list.
Launch Tool →Parse Names with Titles and Suffixes
Extract professional titles (Dr., Rev.) and suffixes (Jr., III, Ph.D.) into distinct columns.
Launch Tool →Remove the Byte-Order Mark (BOM)
Remove the hidden 3-byte BOM sequence that breaks database imports and pandas scripts.
Launch Tool →Unmerge Cells and Fill
Repair spreadsheets corrupted by merged cells by filling parent values down across all rows.
Launch Tool →Remove Formulas and Keep Values
Freeze calculated spreadsheet formulas into static values and strip formula overhead.
Launch Tool →Remove Null Values
Recursively purge null, empty string, and undefined attributes from JSON payloads.
Launch Tool →Deduplicate a JSON Array
Remove duplicate records from JSON arrays based on designated key properties or full object equality.
Launch Tool →Remove Duplicate Lines
Remove repeated lines from any text block, with options for case sensitivity and whitespace handling.
Launch Tool →Remove Extra Spaces
Collapse multiple consecutive spaces into one and strip leading/trailing spaces from any text.
Launch Tool →Remove Accents and Diacritics
Strip all diacritical marks from accented characters, converting to plain ASCII equivalents.
Launch Tool →