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.
- Rating
- 4.8(1.7K)
- Monthly uses
- 208K
- Price
- Free
or drag it here
.xlsx, .xls, .csv · processed locally, never uploaded
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
What people say
Exactly what I needed. Text Formatter used to be a twenty-minute job with a macro I did not trust; now it takes one drag and one click.
Fast, no signup wall, no watermark. I have sent the Text Formatter link to half my department.
Handled a file with well over 200,000 rows without complaining. That is more than I can say for the desktop add-in we pay for.
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