Excel Formatter

Standardises text columns in Excel/CSV files. Converts case, adds prefixes or suffixes, runs find-and-replace, applies regex patterns.

What it does

Use this to normalise phone numbers, title-case all names, prepend a product-code prefix, or clean up badly formatted emails. Instead of editing cells one by one, you set the rule and apply it to thousands of rows at once.

How to use

  1. Drag files into the list.
  2. Pick a Worksheet and the Target Columns. To run on every text column, tick the corresponding box.
  3. Use Standard Formatting, Find & Replace, or the Regex Engine as needed.
  4. Click Run.

Standard formatting

  • Case Conversion: Keep original, UPPERCASE, lowercase, Title Case, First letter capitalised.
  • Prefix: Prepends your text (e.g. MR- makes 001 into MR-001).
  • Suffix: Appends your text (e.g. @company.com makes ali into ali@company.com).
  • Apply prefix/suffix only to filled cells: Empty cells are left alone.

Find and Replace (plain text)

Searches for your text in the cells and substitutes the replacement. Plain text, not regex. Example: LTD. -> LIMITED.

Regex engine (advanced)

For complex patterns. Pick a ready-made preset: phone number, national ID, email, URL, IBAN, postcode etc. 14 presets are included.

Action options:

  • Disabled: Regex does not run.
  • Extract: Keeps only the matching part of each cell, drops the rest.
  • Replace: Substitutes the matching part with your replacement.
  • Digits Only: Keeps all the digits, drops letters and symbols.
  • Remove Digits: Drops all the digits, keeps letters and symbols.

Examples

Title-case every name: Add the Excel, pick first_name and last_name, Case Conversion "Title Case". ali smith becomes Ali Smith.

Add product code prefix: Add the Excel, pick product_code, type PRD- in Prefix. 001 becomes PRD-001.

Strip phone numbers down to digits: Add the Excel, pick phone, set Regex Action to "Digits Only". (0532) 123-45-67 becomes 05321234567.

Change email domain: Use Find & Replace, search @oldco.com, replace @newco.com.

Fix a spelling: Find & Replace, search Istanbul, replace İstanbul.

Watch out

  • In batch mode the column list comes from the first file only. Other files must have the same columns.
  • Numeric columns are not protected from text ops, pick carefully.
  • Regex output is not reversible, test on a small file first.
  • Find & Replace is case-sensitive. Istanbul and istanbul are different.
  • Prefix/suffix apply to every cell, turning off "Apply only to filled cells" affects empty cells too.

License

Free tier has a monthly format cap. Office plan removes it.