Guides
Deduplicating Lists, Extracting Contacts & Normalizing Case Locally
Clean messy CRM lists and log dumps in browser RAM: remove duplicate lines, extract deduplicated emails and URLs to CSV, and standardize identifier case.
Quick Answer: Clean noisy CRM lists, logs, and identifier lists locally without spreadsheet formulas or cloud uploads: deduplicate lines with case and sort controls, extract unique emails, URLs, and phone numbers into a 2-column type,value CSV, and convert variable names across 9 case styles while preserving uppercase acronyms like API and HTTP.
Turning noisy logs, CRM dumps, and mixed identifiers into clean data
Marketing teams, support engineers, and backend developers constantly inherit messy text blobs: subscriber exports full of uppercase/lowercase duplicates, incident logs buried in emails and URLs, or schema fields mixing snake_case and PascalCase.
Handling that cleanup locally in browser RAM prevents customer email lists and internal hostnames from leaking into untrusted web utilities.
- Deduplication strips leading/trailing spaces and flags mixed-case repeats like [email protected] vs [email protected].
- Contact extraction filters raw logs, HTML, or CSV dumps straight into an import-ready type,value CSV.
- Acronym-aware case conversion normalizes API, HTTP, JSON, SQL, and UUID names cleanly.
Removing duplicate lines with case, whitespace & sort controls
Remove Duplicate Lines strips UTF-8 BOMs, trims whitespace per line when trimWhitespace is enabled, drops blank lines, and tracks seen keys case-insensitively by default—or strictly when caseSensitive is checked.
Choose keep to preserve the exact original appearance order of first-seen lines, or switch sortOrder to asc or desc while reviewing the exact duplicatesRemoved count in stats.
Extracting emails, URLs & phone numbers to structured CSV
When contacts or links sit inside unstructured support tickets, HTML fragments, or application logs, Extract Emails & URLs scans the text locally with independent toggles for extractEmails, extractUrls, and extractPhones.
Matched URLs automatically shed trailing sentence punctuation and unbalanced closing parentheses, email deduplication ignores letter case, and results export as a clean RFC 4180 CSV with type,value columns.
type,value
email,[email protected]
email,[email protected]
url,https://status.acme-corp.io/incident/408Standardizing code & title casing while preserving acronyms
Before importing column headers or renaming TypeScript/SQL fields, Case Converter transforms every line across camelCase, PascalCase, snake_case, SCREAMING_SNAKE_CASE, kebab-case, titleCase, sentenceCase, UPPERCASE, and lowercase.
Keep preserveAcronyms enabled so 45+ technical terms—including API, HTTP, JSON, XML, SQL, JWT, UTF, and ID—stay uppercase instead of turning into Api or Http, then verify list edits side-by-side with Diff Checker.
Convert text & identifiers across 9 case styles
| Target Case | Input: api_url_id | Acronym Preserved |
|---|---|---|
| camelCase | apiURLID | Yes (after first word) |
| PascalCase | APIURLID | Yes |
| snake_case | api_url_id | Lowercase by spec |
| kebab-case | api-url-id | Lowercase by spec |
| titleCase | API URL ID | Yes |
References
Frequently asked questions
Can Remove Duplicate Lines keep my original line order instead of sorting A–Z?
Yes. Leave Sort Order set to Keep Original Order to drop later duplicates while keeping every unique line in its original position.
How does Extract Emails & URLs handle trailing periods or parentheses around URLs?
The extractor trims trailing sentence punctuation (periods, commas, semicolons, quotes) and strips extra unmatched closing parentheses automatically.
Why does preserveAcronyms matter in Case Converter?
Enabling preserveAcronyms keeps acronyms like HTTP, API, JSON, SQL, and ID uppercase in Title Case, camelCase, and PascalCase instead of forcing them to Http or Json.
Related formats
Related Comparisons
Related Guides
- Offline JWT Decoding, Base64URL & Semantic JSON DiffingInspect JWT headers and claims, encode Base64URL without padding, run key-order-agnostic semantic JSON diffs, and scrub Bearer tokens offline.
- Why Excel Garbles UTF-8 CSVs — and How UTF-8 BOM Fixes ItStop Microsoft Excel from turning Chinese, Japanese, Korean, Spanish, and German CSV text into mojibake by adding a 3-byte UTF-8 BOM locally.
- Fixing GBK, Big5, Shift-JIS & EUC-KR Garbled Text LocallyDiagnose and repair garbled Chinese, Japanese, and Korean text files (GBK, GB18030, Big5, Shift-JIS, EUC-KR) to clean UTF-8 without uploading.