Text Cleaner
Text Cleaner
Clean, dedupe, sort, and format line-based text for Excel, SQL, tickets, and logs. Runs in your browser. No uploads.
Runs locally in your browser. No uploads.
Shortcuts: Ctrl/⌘+Enter Apply · Ctrl/⌘+S Download · Ctrl/⌘+C Copy output · Esc Clear
Input
Processing order
Use arrows to reorder.
Step settings
Output
Stats will appear after you click Apply.
Use cases
- Clean log lines for tickets and incident notes.
- Prepare SQL IN lists from pasted IDs.
- Deduplicate email/ID lists before imports.
- Normalize messy text pasted from PDFs/Excel.
- Sort lists for diffs and code reviews.
Common problems & fixes
My list has hidden whitespace / zero-width characters
Enable Sanitize whitespace and Trim each line, then Apply.
Sorting breaks numbers
Enable Numeric sort to sort values like ports, IDs, and amounts safely.
Dedupe removed too much
Disable Case-insensitive dedupe, or switch to stable mode to preserve order.
Output looks wrong for SQL
Use the single-quote or SQL IN list presets in Prefix/suffix.
Examples
Dedupe + sort
Before
b\na\na\nB\n
After
a\nB\nb\n
SQL IN formatting (quotes + comma)
Before
123\n456\n789\n
After
'123',\n'456',\n'789',\n
Join lines with comma
Before
alpha\nbeta\ngamma\n
After
alpha, beta, gamma
Search intents we cover
remove line breaks onlinetext cleaner onlineremove extra spaces tooldedupe lines onlineremove duplicate lines toolsort lines alphabetically toolsort lines numeric toolmake sql in list from lineswrap lines in quotesadd prefix to each lineadd suffix to each linenumber lines onlinefind and replace text onlinetabs to spaces converternormalize line endings toolremove empty lines onlinejoin lines with comma onlinejoin lines with delimiter
Text Cleaner FAQ
›Is my text uploaded?
No. Processing happens locally in your browser; nothing is uploaded.
›Does it support large inputs?
Yes. Heavy operations run in a Web Worker to keep the UI responsive, and transforms apply only when you click Apply.
›Can I preserve original order when deduping?
Yes. Use the “Preserve original order (stable)” dedupe mode.
›Can it sort numbers correctly?
Enable Numeric sort to handle lines that are numbers (ports, IDs, amounts). Mixed lines fall back to a normal string sort.
›How do I create SQL IN lists?
Enable Prefix/suffix and use the single-quote or SQL IN list preset to wrap each line and add commas.
›Why are there invisible characters in my pasted text?
Some sources include non-breaking or zero-width spaces. Enable Sanitize whitespace to remove them.
›What’s the difference between Clear and Reset?
Clear empties the input/output. Reset keeps your text but restores default processing steps and settings.
›Does Find & replace support regex?
No. It’s plain-text find/replace only. For regex, use the Regex Tester tool.
Related tools