Price & Currency Formatting
Extract numeric prices, detect currencies, and standardize money formats.
Price data in spreadsheets mixes currencies, symbols, commas, and even written-out amounts. Price normalization extracts clean numeric values and identifies the currency, making your data ready for product feeds and structured data.
Price (Decimal)
Extracts just the numeric value from price data, stripping currency symbols, commas, and extra formatting.
Before
$19.99
$1,234.56
€15,50
19.99
After
19.99
1234.56
15.50
19.99
Returns the number only — no currency symbol or code. Useful when you store price and currency separately.
Price + Currency Code
Formats prices as "amount CURRENCY_CODE". Detects currency from symbols ($, €, £, ¥) or words (dollars, euros, pounds, yen).
Before
$19.99
twenty dollars
fifty euros
£25.00
After
19.99 USD
20.00 USD
50.00 EUR
25.00 GBP
This format is ideal for schema markup, which requires separate price and currency values.
When to Use This
- E-commerce product feeds
- Price comparison datasets
- Schema markup (Product, Offer)
- Financial data processing