All Tools Directory
Browse all 169 browser-based data conversion and cleaning utilities. Your rows never leave your browser.
CSV to JSON
Transform tabular CSV spreadsheets into structured JSON arrays of objects in your browser.
Open Tool →JSON to CSV
Transform complex JSON arrays and nested API responses into clean, spreadsheet-ready CSV tables.
Open Tool →CSV to TSV
Convert CSV data into tab-delimited values (TSV) for seamless copy-pasting directly into Excel, Sheets, and bioinformatics tools.
Open Tool →TSV to CSV
Convert tab-separated datasets (TSV) into standardized comma-separated (CSV) spreadsheets compatible with all platforms.
Open Tool →TSV to JSON
Transform tab-delimited records (TSV) into structured JSON arrays of objects for web APIs and NoSQL databases.
Open Tool →JSON to TSV
Convert JSON documents and API arrays into tab-delimited values (TSV) for seamless copy-pasting directly into spreadsheet cells.
Open Tool →CSV to Markdown Table
Transform CSV files and spreadsheets into clean, padded GitHub-Flavored Markdown tables for documentation and READMEs.
Open Tool →JSON to Markdown Table
Transform JSON API payloads and data objects into clean, formatted Markdown tables for technical documentation and READMEs.
Open Tool →CSV to SQL INSERT
Transform spreadsheet rows into clean, batched SQL INSERT statements with proper string escaping and NULL detection.
Open Tool →JSON to SQL INSERT
Transform JSON API payloads and arrays of objects into structured SQL INSERT statements ready for database migration.
Open Tool →CSV to TypeScript Interface
Generate strongly-typed TypeScript interfaces, types, and JSDoc comments directly from CSV column headers and sample data rows.
Open Tool →JSON to TypeScript Interface
Convert JSON payloads and API responses into strongly-typed TypeScript interfaces with recursive sub-type generation.
Open Tool →Excel to CSV
Convert Excel workbooks (.xlsx, .xls) into clean, standard CSV files with date repair and multi-sheet selection.
Open Tool →CSV to Excel
Transform CSV files into native Excel workbooks (.xlsx) with preserved leading zeros and styled header rows.
Open Tool →Excel to JSON
Transform Microsoft Excel workbooks (.xlsx, .xls) directly into clean, structured JSON arrays and objects.
Open Tool →JSON to Excel
Transform complex JSON documents and API responses into styled, auto-fitted Microsoft Excel workbooks (.xlsx).
Open Tool →CSV to JSON for Postman
Format CSV test cases and parameters into Postman collection runner JSON data files for automated API testing.
Open Tool →CSV to JSON Lines
Transform CSV spreadsheets into newline-delimited JSON Lines (JSONL / NDJSON) for BigQuery, Elasticsearch, and AI training datasets.
Open Tool →JSON Lines to CSV
Transform newline-delimited JSON Lines (JSONL / NDJSON) log files and datasets into clean, tabular CSV spreadsheets.
Open Tool →Split Full Name into First and Last
Separate full name columns into dedicated first_name and last_name columns in CSV and Excel spreadsheets.
Open Tool →Combine First and Last Name
Merge separate first and last name columns into a single clean full_name column, trimming extra spaces.
Open Tool →Remove Duplicate Rows
Eliminate duplicate rows across your entire dataset or based on specific unique key columns.
Open Tool →Fix Phone Numbers
Strip punctuation, resolve leading zeros, and format phone numbers with proper country codes.
Open 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.
Open Tool →Change Text Case
Transform column text into UPPERCASE, lowercase, Title Case, Sentence case, or camelCase across your spreadsheet.
Open Tool →Remove Empty Rows
Delete blank lines and rows containing only empty cells or whitespace across your entire spreadsheet.
Open Tool →Remove Empty Columns
Detect and remove completely blank columns or columns containing only empty values across your dataset.
Open Tool →Standardize Dates to ISO
Transform mixed and regional date formats into standardized ISO 8601 strings (YYYY-MM-DD).
Open Tool →Fix Mixed Date Formats
Harmonize columns containing a mixture of slashes, dashes, text months, and timestamps into one uniform format.
Open Tool →Remove Special Characters
Strip invisible control characters, non-ASCII symbols, smart quotes, and unwanted punctuation from spreadsheet cells.
Open Tool →Merge Columns
Concatenate multiple columns into a single unified column using custom delimiters (space, comma, hyphen, slash).
Open Tool →Split a Column by Delimiter
Divide single cell values into multiple new columns based on delimiters like commas, slashes, hyphens, or spaces.
Open Tool →Extract Domain from Email
Parse email addresses to extract website domain names into a dedicated column for lead enrichment and corporate classification.
Open Tool →Clean an Email List
Scrub email lists by fixing syntax errors, trimming spaces, removing duplicates, and lowercasing addresses.
Open Tool →Fix Currency and Number Formats
Strip currency symbols ($ , € , £ , KES), resolve thousands commas, and format numbers into clean numeric decimals.
Open Tool →Fix a Messy CSV Export
Diagnose and repair common CSV corruptions: unclosed quotes, broken delimiters, jagged row lengths, and encoding glitches.
Open Tool →Remove Duplicate Emails
Deduplicate subscriber and customer lists based exclusively on normalized email addresses.
Open Tool →Fix Name Capitalization
Transform SHOUTING all-caps or all-lowercase names into natural Title Case with cultural naming rule support.
Open Tool →Add or Remove Leading Zeros
Pad numbers with leading zeros to meet fixed-width requirements (e.g. 00123) or strip unnecessary leading zeros.
Open Tool →Fix ZIP and Postal Codes
Repair postal codes damaged by Excel auto-truncation, format US ZIP+4, and standardize UK and Canadian formats.
Open 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.
Open 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.
Open Tool →Remove HTML Tags from Cells
Strip HTML markup tags and decode HTML entities from product descriptions, CMS exports, and scraped text.
Open Tool →Remove Line Breaks Inside Cells
Remove internal carriage returns and newline characters inside cells that cause broken CSV rows and database parsing errors.
Open Tool →Fix Garbled Characters (Encoding)
Repair character encoding glitches (mojibake) caused by Windows-1252 or ISO-8859-1 interpreted as UTF-8 (e.g. é -> é, ’ -> ').
Open Tool →Remove Emojis from Text
Remove emojis, pictographs, and Unicode symbols from social media text, customer reviews, and feedback.
Open Tool →Standardize Yes/No Values
Normalize inconsistent boolean flags across your dataset into standard True/False, Yes/No, or 1/0 formats.
Open Tool →JSON Formatter
Beautify and indent unformatted JSON strings into clean, human-readable structured trees.
Open Tool →JSON Minifier
Compress structured JSON files into single-line minified strings to reduce payload size.
Open Tool →Change CSV Delimiter
Switch spreadsheet delimiters between commas, semicolons, tabs, and pipes seamlessly.
Open Tool →Add a Header Row to CSV
Insert column headers to raw CSV files that lack a top header row.
Open Tool →Remove the Header Row
Remove the top header row or metadata lines from a CSV dataset.
Open Tool →Sort CSV by Column
Sort tabular CSV records ascending or descending by any column value.
Open Tool →Rename CSV Columns
Rename column headers or standardize them into snake_case / camelCase.
Open Tool →Escape Quotes in CSV
Escape internal quotation marks to prevent broken rows in standard parsers.
Open Tool →Wrap CSV Values in Quotes
Wrap all cells or specific text columns in quotation marks.
Open Tool →Validate CSV
Audit CSV files for structural errors, encoding problems, and row-length inconsistencies.
Open Tool →Validate JSON
Parse and validate JSON strings to expose syntax errors at exact line and column positions.
Open Tool →Find Duplicate Rows
Identify and count duplicate rows in CSV files by exact match or by key column selection.
Open Tool →Find Missing Values
Audit CSV columns for empty, null, and whitespace-only cells and produce a completeness report.
Open Tool →Validate an Email List
Check every email in a CSV column for valid RFC 5322 format without sending test messages.
Open Tool →Validate Phone Numbers
Scan a CSV phone column for format errors, missing country codes, and invalid digit counts.
Open Tool →Check Column Consistency
Audit CSV columns to detect mixed data types, inconsistent formats, and type anomalies.
Open Tool →Find Invalid Dates
Scan date columns for invalid entries: impossible dates, ambiguous formats, and future or past-range anomalies.
Open Tool →Find Outliers in a Number Column
Identify statistical outliers in numeric columns using IQR or Z-score threshold methods.
Open Tool →CSV Row and Column Counter
Count data rows, header columns, total cells, and non-empty cell percentages in any CSV.
Open Tool →Profile a CSV
Automatically profile every CSV column: type inference, null rate, unique count, min/max, mean, and top-5 values.
Open Tool →Transpose CSV
Flip a CSV matrix by turning rows into columns and columns into rows.
Open Tool →Pivot a CSV
Summarise long-format CSV data into pivot tables grouped by row and column keys.
Open Tool →Group By and Count
Aggregate CSV rows by one or more group-by columns with count, sum, mean, min, or max.
Open Tool →Filter CSV Rows by Condition
Keep or discard CSV rows based on flexible conditions applied to any column.
Open Tool →Select or Remove Columns
Select columns to keep or specify columns to drop from a CSV, with optional reordering.
Open Tool →Add a Calculated Column
Create new columns derived from existing columns using arithmetic, string, or conditional expressions.
Open Tool →Pick Random Sample Rows
Extract a reproducible random sample of rows from large CSV datasets.
Open Tool →Keep the First or Last N Rows
Extract the first N or last N data rows from a CSV file, preserving the header.
Open Tool →Add Row Numbers or Unique IDs
Add sequential row numbers or UUID/ULID unique identifiers to every row in a CSV.
Open Tool →Shopify Customer Export Cleaner
Normalize Shopify customer exports: merge split address fields, clean phones, and strip internal metadata.
Open Tool →Stripe CSV to JSON
Convert Stripe balance and payment CSV exports to clean JSON with amount conversion and metadata parsing.
Open Tool →Google Contacts CSV Fixer
Fix Google Contacts CSV exports to import into Outlook, Apple Contacts, or CRM platforms.
Open Tool →Mailchimp List Cleanup
Clean Mailchimp subscriber exports: remove unsubscribes, deduplicate, fix emails, and strip metadata.
Open Tool →WooCommerce Order Export Cleaner
Clean WooCommerce order CSV exports: fix address fields, strip HTML entities, and normalise totals.
Open Tool →Fix Excel Exports with Merged Cells
Fill down blank cells in CSV exports caused by merged cell regions in Excel workbooks.
Open Tool →LinkedIn Connections Export Cleaner
Clean LinkedIn connections CSV: strip header notice, split company/position, validate emails, normalize dates.
Open Tool →Google Ads Report Cleaner
Clean Google Ads CSV exports: strip summary rows, convert percentages/currency to numbers, normalise column names.
Open Tool →Bank Statement CSV Cleaner
Standardize bank statement CSVs: detect debit/credit, normalize dates, strip metadata rows.
Open Tool →Accounting Export Cleaner
Normalize QuickBooks, Xero, Wave, and FreshBooks CSV exports for data analysis.
Open Tool →Column to Comma-Separated List
Extract a CSV column and convert it to a comma-separated list for SQL IN clauses or code arrays.
Open Tool →Comma-Separated List to Column
Convert a comma-separated, line-separated, or SQL IN list into a single-column CSV.
Open Tool →Lines to CSV
Convert plain-text newline-delimited records into structured CSV tables.
Open Tool →CSV to Lines
Convert a CSV to a newline-delimited text file with configurable field separators.
Open Tool →Find and Replace in CSV
Replace text values across all cells or within specific columns in a CSV file.
Open Tool →Regex Replace in CSV
Apply regex patterns with capture groups to transform cell values across CSV columns.
Open Tool →Add Prefix or Suffix to Values
Prepend a prefix or append a suffix to every value in a CSV column.
Open Tool →Truncate Text in Cells
Trim CSV cell values to a specified maximum character length with optional ellipsis.
Open Tool →Count Word Frequency
Count word frequency across a text column in a CSV and output a frequency table.
Open Tool →Count Unique Values
Count distinct values per CSV column and generate a value-count frequency table for each.
Open Tool →Top N Values in a Column
Extract the top N or bottom N rows from a CSV ranked by a numeric column.
Open Tool →Fill Down Blank Cells
Forward-fill blank cells by propagating the last non-blank value down through a CSV column.
Open Tool →Fill Missing Values
Replace blank CSV cells with a constant, column mean, median, previous value, or 'Unknown'.
Open Tool →Convert Text to Numbers
Strip formatting from text-formatted number columns to produce clean numeric values.
Open Tool →Convert Numbers to Text
Format numeric CSV values as human-readable text with currency symbols, commas, and decimal precision.
Open Tool →Round Numbers in a Column
Round numeric CSV column values to a specified decimal precision or nearest integer/multiple.
Open Tool →Add Thousands Separators
Add thousands separators (comma or period) to numeric CSV columns for display formatting.
Open Tool →Convert Percentages
Convert percentage strings to decimal fractions or decimal fractions to percentage strings in CSV columns.
Open Tool →Rank Rows
Rank CSV rows by a numeric column and add a rank column with configurable tie-breaking.
Open Tool →Running Total
Add a running (cumulative) total column to a numeric CSV column, with optional group reset.
Open Tool →Percent of Total
Add a percentage-of-total column showing each row's share of the column sum.
Open Tool →Normalize Numbers (Min-Max)
Scale numeric CSV column values to the 0–1 range using min-max normalization.
Open Tool →Unpivot (Wide to Long)
Convert wide-format pivot tables to long format by stacking multiple columns into variable/value pairs.
Open Tool →Pivot (Long to Wide)
Convert long-format (tidy) CSV to wide pivot format by spreading a variable column into column headers.
Open Tool →CSV to Key-Value Pairs
Convert CSV rows to key=value or key:value pair strings for config files, ENV files, or logs.
Open Tool →CSV to Vertical Records
Convert CSV rows into vertical field:value blocks, one block per row, for human-readable review.
Open Tool →CSV to Mail-Merge Output
Fill a text template with {{field_name}} placeholders from each CSV row to generate personalized output.
Open Tool →Extract Emails, Phones or URLs from a Column
Extract email addresses, phone numbers, or URLs embedded in free-text CSV cells into separate columns.
Open Tool →Clean URLs (Remove Tracking Parameters)
Strip UTM parameters, fbclid, gclid, and marketing tracking tokens from CSV URL columns.
Open Tool →Extract Domain from URL
Extract the root domain, subdomain, path, or protocol from full URL strings in a CSV column.
Open Tool →Split an Address into Parts
Split unformatted postal addresses into clean structured address columns.
Open Tool →Normalize Company Names
Harmonize company name variations, legal suffixes, and capitalization across your account list.
Open Tool →Find Similar Duplicates (Fuzzy Match)
Identify subtle duplicates and typos in your CSV using configurable fuzzy matching algorithms.
Open Tool →Parse Names with Titles and Suffixes
Extract professional titles (Dr., Rev.) and suffixes (Jr., III, Ph.D.) into distinct columns.
Open Tool →Detect and Fix Delimiter Problems
Scan for ragged rows where unescaped commas or semicolons broke table alignment.
Open Tool →Fix Unclosed Quotes
Detect mismatched quotes that cause entire rows of data to be swallowed into a single cell.
Open Tool →Remove the Byte-Order Mark (BOM)
Remove the hidden 3-byte BOM sequence that breaks database imports and pandas scripts.
Open Tool →Convert Encoding to UTF-8
Fix mangled accented characters (mojibake) by decoding legacy encodings into clean UTF-8.
Open Tool →Convert Line Endings
Switch between Windows CRLF and Linux LF line breaks across your files.
Open Tool →Remove Columns by Name Pattern
Delete batches of columns matching regex or text patterns from wide exports.
Open Tool →Keep Columns by Name Pattern
Extract a focused subset of columns matching a name pattern from massive wide tables.
Open Tool →Convert Time Zones in a Column
Shift timestamps between UTC and local regional time zones with full daylight saving support.
Open Tool →Date to Weekday
Derive day-of-week names or numeric values from date columns for cohort analytics.
Open Tool →Calculate Age from Date of Birth
Derive current age in full completed years from birthday columns.
Open Tool →Date Difference Between Two Columns
Calculate elapsed time between two date columns in days, working days, or hours.
Open Tool →Combine Date and Time Columns
Join isolated date and time fields into single standard timestamp columns.
Open Tool →Split Date and Time
Separate composite timestamp columns into distinct date and time components.
Open Tool →Excel Date Serial to Date
Translate cryptic Excel 5-digit serial numbers back into human-readable calendar dates.
Open Tool →Date to Excel Serial
Convert standard calendar dates into Excel-compatible numeric serial day values.
Open Tool →Convert Units in a Column
Convert numeric measurements across metric and imperial units (lbs to kg, miles to km).
Open Tool →Unmerge Cells and Fill
Repair spreadsheets corrupted by merged cells by filling parent values down across all rows.
Open Tool →Split an Excel File by Sheet
Export all worksheets from a multi-tab workbook into individual CSV tables.
Open Tool →Merge Excel Files
Consolidate multiple Excel workbooks into a single master spreadsheet or CSV table.
Open Tool →Remove Formulas and Keep Values
Freeze calculated spreadsheet formulas into static values and strip formula overhead.
Open Tool →Excel to Import-Ready CSV for Google Sheets
Format and clean Excel files so they import into Google Sheets without corrupted dates or fonts.
Open Tool →Flatten Nested JSON
Transform deeply nested JSON objects into flat dot-notated key-value pairs.
Open Tool →Extract a Field from a JSON Array
Pluck a single attribute (like email or id) across all objects in a JSON array.
Open Tool →Remove Null Values
Recursively purge null, empty string, and undefined attributes from JSON payloads.
Open Tool →Rename JSON Keys
Remap property keys across JSON records to align with target API or database schemas.
Open Tool →JSON Array to CSV with Nested Columns
Export hierarchical JSON arrays into clean CSV tables with flattened dot-notated columns.
Open Tool →JSON to Table
Render complex JSON payloads as an interactive, searchable spreadsheet grid.
Open Tool →Compare Two JSON Arrays
Diff two JSON arrays to find added, deleted, and modified records based on a shared key.
Open Tool →Merge JSON Files
Combine multiple JSON documents or arrays into a single consolidated JSON file.
Open Tool →Deduplicate a JSON Array
Remove duplicate records from JSON arrays based on designated key properties or full object equality.
Open Tool →Sort a JSON Array by Field
Sort JSON objects alphabetically, numerically, or chronologically by any property key.
Open Tool →Filter a JSON Array
Filter JSON array records based on conditional criteria, status flags, or numeric thresholds.
Open Tool →Case Converter
Convert text between any capitalisation style: uppercase, lowercase, title case, sentence case, camelCase, PascalCase, snake_case, and kebab-case.
Open Tool →Remove Duplicate Lines
Remove repeated lines from any text block, with options for case sensitivity and whitespace handling.
Open Tool →Sort Lines Alphabetically
Sort any block of text lines alphabetically, reverse alphabetically, or numerically.
Open Tool →Remove Empty Lines
Remove all blank and whitespace-only lines from any block of text.
Open Tool →Remove Extra Spaces
Collapse multiple consecutive spaces into one and strip leading/trailing spaces from any text.
Open Tool →Find and Replace Text
Replace any word, phrase, or regex pattern in any block of text.
Open Tool →Text Diff Checker
Compare two versions of a text document and highlight additions, deletions, and changes.
Open Tool →Extract Emails from Text
Extract all email addresses from any block of text or document paste.
Open Tool →Extract URLs from Text
Extract all URLs and hyperlinks from any block of text or document paste.
Open Tool →Extract Numbers from Text
Extract all numbers — integers, decimals, and formatted amounts — from any block of text.
Open Tool →Extract Hashtags
Extract all hashtags from social media posts, captions, or any text block.
Open Tool →Text to URL Slug
Turn any text title into a lowercase, hyphen-separated URL slug safe for web addresses.
Open Tool →Remove Accents and Diacritics
Strip all diacritical marks from accented characters, converting to plain ASCII equivalents.
Open Tool →Markdown to HTML
Convert Markdown documents to clean, semantic HTML in your browser.
Open Tool →HTML to Markdown
Convert HTML documents and fragments into clean, readable Markdown.
Open Tool →