Text Formatter
Change case, trim, pad and reshape text columns in bulk.
Apply upper, lower, title, sentence or proper case; trim and pad; add prefixes and suffixes; find and replace with or without regex. Rules chain in the order you set, and the preview updates as you build them.
- Price
- Free
- Your files
- Never uploaded
- Runs
- In your browser
or drag it here
.xlsx, .xls, .csv · up to 50 MB · processed locally, never uploaded
Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.
Files stay on your device
What it does well
- Chainable rules applied in a defined order
- Regex find-and-replace with capture group references
- Acronym and exception lists respected by case rules
How to use Text Formatter
- 1
Upload the file and choose the columns to transform.
- 2
Add transformation rules in the order you want them applied.
- 3
Watch the before/after preview update live.
- 4
Apply and download the result.
Watch a walkthrough
Common problems and fixes
The replacement inserted a literal $1.
Capture group substitution only applies in regex mode. Switch the rule from plain text to regex.
Numbers turned into text.
Text rules coerce their targets. Exclude numeric columns from the rule scope, or use the Number Formatter for those.
Frequently asked questions
More clean & format tools
Remove duplicates, trim whitespace, fix inconsistent dates and numbers, split or merge columns, and validate data quality before it reaches your reports.
Browse Clean & Format