UlvixorNormalize Text Data in a CSV
Normalize the text in the columns you choose from a CSV: trim spaces, convert to uppercase or lowercase, strip accents, and collapse repeated internal spaces. Perfect for standardizing data before importing it into another system. Everything runs in your browser, with no file ever uploaded to a server.
How it works
- Paste your CSV with a header row into the input panel (or use the built-in example).
- Select one or more columns from the automatically detected list.
- Choose the normalization operations to apply: trim spaces, uppercase, lowercase, strip accents, or collapse internal spaces.
- The operations are applied in order to every value in the columns you selected.
- Copy the resulting CSV or download it as a .csv file.
Use cases
- Standardize city or category names that arrive with inconsistent capitalization.
- Strip accents from columns that will be used as identifiers or keys in another system.
- Clean up double or triple spaces introduced when copying data from a form or PDF.
- Prepare a CSV for comparison or matching against another data source that uses a different text format.