Transform CSV columns with 25+ operations: text manipulation (uppercase, lowercase, trim), number formatting, date conversion, extraction patterns, and custom pipelines
Clean and reshape CSV column values by stacking predefined transformations. Pick a column, choose an operation from a menu, set its parameters, and the tool rewrites that column. Change case, trim and pad, find-and-replace, take a substring, extract digits or letters, format numbers and dates, build a slug, or mask sensitive values, all without writing a script.
Initializing in your browser…
Convert between CSV and JSON formats
Convert images between PNG, JPG, WebP, AVIF, BMP formats. Features quality control, transparency support, and batch conversion for efficient workflow.
Convert audio files between WAV, MP3, OGG, AAC, M4A, FLAC formats online. Adjust bitrate and quality settings. Free browser-based conversion with no file uploads to servers.
You need to add a `full_name` column from `first` + `last` and uppercase the `code` column in one pass.
Transforms
new full_name = first + " " + last · code = UPPER(code)
Output
first,last,code,full_name Dana,Lee,ab12,DANA LEE ... (full_name added, code upper-cased)
Column-level transforms (concatenate, case, split, derive) are applied across every row at once, so reshaping a file does not require a script. Chaining several steps before export turns a messy source into pipeline-ready data in one screen.
Clean and reshape CSV column values by stacking predefined transformations. Pick a column, choose an operation from a menu, set its parameters, and the tool rewrites that column. Change case, trim and pad, find-and-replace, take a substring, extract digits or letters, format numbers and dates, build a slug, or mask sensitive values, all without writing a script.
Each transformation targets one column and is chosen from a categorized menu rather than written as a formula. Text operations include uppercase, lowercase, title case, trim (both sides, left, or right), remove all whitespace, find-and-replace, add a prefix or suffix, substring, split-and-keep a part, concatenate with another column using a separator, pad left or right to a target length, reverse, and dedupe repeated words. Extraction operations keep only digits, keep only letters, or pull the domain from an email address. Number operations cover rounding to a number of decimals, absolute value, thousands separators, percentage, and currency formatting. There is also date reformatting, a URL-slug builder, and a mask operation that hides the middle of a value (for example, a credit card number) while leaving a few characters visible at each end.
You can stack several operations and they run top to bottom, so each step feeds the next, and any step can be toggled off without deleting it. Transformations are applied in place to the chosen column; the tool does not evaluate arithmetic expressions or create brand-new computed columns, though concatenate can join one other column into the target. A preview lets you check results before applying to all rows and downloading.
Standardize inconsistent formatting, trim spaces, unify date formats, normalize case, across an entire column.
Concatenate a First name column into a Last name column (with a space separator) to build a single name field.
Convert dates from MM/DD/YYYY to ISO 8601 format (YYYY-MM-DD) for database import.
Replace sensitive column values with masked versions (e.g., show only last 4 digits of a phone number).
The Concatenate operation can join one other column into the target column, with a separator you choose. There is no general arithmetic or expression engine that references multiple columns.
Transformations are previewed before applying, and each step can be toggled off without deleting it. You can also re-upload the original file to start over.
Yes. The Format Date operation converts a date column from one format to another. The data is changed in place rather than added as a new column.
Rows and columns are parsed and transformed in memory in your browser. No record ever reaches a server.