Clean currency symbols, commas, and decimal separators into pure numbers
Strip currency symbols ($ , € , £ , KES), resolve thousands commas, and format numbers into clean numeric decimals.
🛡️ Your rows never leave your browser.
Why Onfyt: Processes fix currency and number formats entirely in-browser with dedicated Web Workers so your rows never leave your machine.
Interactive Sample Data
| invoice_id | client_name | raw_currency | vat_amount |
|---|---|---|---|
| INV-01 | Bamburi Cement | KES 450,000.00 | KES 72,000.00 |
| INV-02 | TotalEnergies | $12,450.50 | $1,992.08 |
| INV-03 | Heineken BV | € 1.250,75 | € 200,12 |
| INV-04 | Standard Chartered | £ 8,900.00 | £ 1,424.00 |
How this tool works
Financial datasets exported from accounting platforms (QuickBooks, Xero, SAP, NetSuite) or web dashboards commonly format numeric values as human-readable currency strings: "$12,450.50", "KES 450,000.00", or "€ 1.250,75". While visually attractive on printed invoices, these symbols make it impossible to perform mathematical operations (=SUM, =AVERAGE), calculate financial metrics, or ingest data into database numeric columns.
Furthermore, international regional conventions cause severe calculation errors:
- US and UK formats use commas for thousands and periods for decimals: 1,234.56
- European and South American formats invert this, using periods for thousands and commas for decimals: 1.234,56
- Negative amounts are often enclosed in accounting parentheses: ($1,250.00), which database systems interpret as non-numeric text.
This tool cleans and standardizes currency and number columns:
- Strips currency symbols ($, €, £, ¥, KES, UGX, TZS) and text codes.
- Strips thousand-separator commas.
- Converts European comma decimals into standard decimal points.
- Converts accounting parentheses like ($500.00) into standard negative numbers (-500.00).
All calculations execute client-side in your local browser sandbox via Web Workers. Your corporate financial statements, invoices, and payroll ledgers remain completely confidential.
From a financial analytics standpoint, converting human-readable currency strings ("$12,450.50", "KES 450,000.00", "€ 1.250,75") into pure numeric decimals is essential for mathematical modeling and database ingestion. Database engines reject currency symbols and thousand-separator commas in numeric columns. DataFix strips currency symbols, resolves European comma/dot decimal inversions, and converts accounting parentheses (e.g., ($500.00)) into standard negative numbers (-500.00).
From a corporate finance and security perspective, financial ledgers, invoice totals, and payroll spreadsheets contain highly confidential corporate metrics that cannot be uploaded to third-party web conversion portals under corporate governance policies. DataFix executes all currency and number standardization locally in-browser via Web Workers, ensuring complete confidentiality, zero latency, and total data protection.
In financial audits, tax reconciliations, and e-commerce revenue reporting, numerical integrity is paramount. When sales receipts and revenue figures are exported with currency symbols (KES, $, €), thousand commas, or European comma decimals, spreadsheet software treats them as text, preventing automatic summing (=SUM) and formula calculations. Sanitizing currency columns into clean numeric floats allows finance teams to execute reconciliations, calculate margins, and prepare tax filings with speed and absolute numerical precision.
Things that usually go wrong
- European Decimals (1.234,56): Treating European decimals as standard numbers results in 123456. Select the European decimal option to handle dots and commas properly.
- Accounting Parentheses (100.00): Parentheses indicate negative amounts in accounting. DataFix converts (100.00) into -100.00.
- Trailing Space in Currency Codes: Codes like "KES 450" have spaces after the currency code. DataFix strips both letters and adjacent spaces.
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.
🧪 Cell value "45.5%" in a numeric column
Percent sign stripped → "45.5". The tool does not divide by 100; it only removes non-numeric formatting characters.
Frequently Asked Questions
Will this convert negative numbers in parentheses like (50.00)?
Yes! It converts accounting parentheses into standard negative numbers (-50.00).
Can it handle European notation like 1.250,75?
Yes. Select the European decimal chip to convert dot thousands and comma decimals into standard 1250.75.
Can I preserve the currency symbol in a separate column?
Yes. You can extract the currency code (KES, USD, EUR) into its own currency column.
Is my financial data uploaded anywhere?
No. All processing happens locally in your browser memory.
Related tools
Clean
Trim Whitespace
Clean up accidental leading, trailing, and duplicate spaces across all columns in your spreadsheet.
Open Tool →
Clean
Trim Whitespace
Clean up accidental leading, trailing, and duplicate spaces across all columns in your spreadsheet.
Open Tool →
Clean
Add or Remove Leading Zeros
Pad numbers with leading zeros to meet fixed-width requirements (e.g. 00123) or strip unnecessary leading zeros.
Open Tool →