Strip non-ASCII symbols, control codes, and unwanted characters
Strip invisible control characters, non-ASCII symbols, smart quotes, and unwanted punctuation from spreadsheet cells.
🛡️ Your rows never leave your browser.
Why Onfyt: Processes remove special characters entirely in-browser with dedicated Web Workers so your rows never leave your machine.
Interactive Sample Data
| id | user_handle | feedback_text | clean_id |
|---|---|---|---|
| 1 | @john_doe™ | Great product! “Fast delivery” 🚀 | ID#4501-A |
| 2 | jane_smith© | Issue with login… error code | ID#4502-B |
| 3 | peter_ke® | Super service—recommend 100% | ID#4503-C |
| 4 | mary_w | Five stars ★★★★★ | ID#4504-D |
How this tool works
Data extracted from web scraping, customer reviews, mobile apps, and legacy databases frequently contains unwanted characters:
- Non-printable ASCII control characters (such as bell \x07, form feed \x0C, null \x00, or backspace \x08) that crash database ingestion scripts.
- Microsoft Word "smart quotes" (“ ” ‘ ’) and em-dashes (—) that break legacy SQL parsers.
- Trademark and copyright symbols (™, ©, ®) that disrupt ERP SKU lookups.
- Emojis, pictographs, and rating stars (★★★) that cause encoding mismatches in legacy systems.
Cleaning these characters manually with find-and-replace is time-consuming and often misses invisible control codes. This tool scans your dataset and strips or normalizes characters according to your rules:
- Strip non-ASCII characters completely (retaining only standard characters 0–127).
- Retain alphanumeric characters and spaces only.
- Normalize smart quotes to standard ASCII quotes (" and ') and em-dashes to standard hyphens (-).
All processing executes locally in your browser sandbox via Web Workers. Your proprietary text and customer data never leave your computer.
From an ETL pipeline perspective, non-printable control characters (such as bell , null , or backspace ), smart quotes, and unescaped symbols cause database ingestion scripts to crash. Legacy database systems and enterprise data warehouses require clean ASCII or UTF-8 text free of invisible control codes. DataFix sanitizes text by stripping control characters, normalizing typographic smart quotes and em-dashes to standard ASCII equivalents, and removing non-printable symbols.
From an enterprise governance perspective, customer feedback databases, support tickets, and proprietary product catalogs contain confidential business information. Transmitting these datasets to external web formatters introduces data leakage liabilities. DataFix executes all sanitization logic locally within your browser sandbox via Web Workers, ensuring that your data remains strictly confidential and secure.
In legacy ERP migrations and mainframe database integrations, non-standard ASCII characters and invisible control codes frequently cause fatal syntax errors. When importing customer records into legacy SQL databases or AS/400 systems, smart quotes (“ ”), em-dashes (—), and control characters cause character encoding exceptions or truncate text unexpectedly. By sanitizing text columns to remove unwanted symbols and normalize typographic punctuation, technical teams ensure smooth data migration without unexpected system halts.
Things that usually go wrong
- Accidental Stripping of Accents: Stripping non-ASCII removes accented letters (é, ñ, ü). Choose "Normalize smart quotes" if you want to keep accents.
- Removing Email @ and Dots: If you choose "Alphanumeric only", email symbols (@, .) will be removed. Apply rules to specific columns.
- Invisible Control Codes Remaining: Some control characters cannot be seen on screen. DataFix scrubs the entire ASCII 0-31 range.
Edge cases we tested
🧪 Empty cells or missing values
Safely handled without schema corruption.
🧪 Leading or trailing cell whitespace
Sanitized prior to processing.
🧪 Large files with 25,000+ rows
Streamed via client-side Web Worker without tab freezing.
Frequently Asked Questions
Can I normalize smart quotes to straight quotes without removing letters?
Yes! Select the "Normalize smart quotes" chip to convert curly quotes and em-dashes to standard ASCII.
Does this remove emojis?
Yes. You can choose to strip emojis and pictographs while preserving standard text.
Can I apply this to specific columns only?
Yes. You can select target columns so you don't strip punctuation from email or URL fields.
Is my data private?
Your rows never leave your browser. All processing runs in a JavaScript Web Worker inside this tab.
Related tools
Clean
Remove Emojis from Text
Remove emojis, pictographs, and Unicode symbols from social media text, customer reviews, and feedback.
Open Tool →
Clean
Fix Garbled Characters (Encoding)
Repair character encoding glitches (mojibake) caused by Windows-1252 or ISO-8859-1 interpreted as UTF-8 (e.g. é -> é, ’ -> ').
Open Tool →
Clean
Trim Whitespace
Clean up accidental leading, trailing, and duplicate spaces across all columns in your spreadsheet.
Open Tool →