Data & CSV
CSV numeric string cleaner
Remove declared grouping and currency wrappers while preserving decimal digits.
A clear answer. Here’s how.
Uses explicit decimal/grouping marks and optional required prefix/suffix. Grouped integer portions need 1–3 initial digits followed by groups of exactly three. Supports a single sign or enclosing negative parentheses, with outer/wrapper whitespace trimmed. Empty cells remain empty; exponents are unsupported. Decimal digits are preserved as strings, with a finite magnitude check up to 1e100. Do not use on identifiers.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- Formatted numbers CSV
Item,Amount A,"$1,234.50" B,"($2,000.00)"
- Column separator
- Comma
- Value column
- Amount
- Decimal mark
- Point
- Grouping mark
- Comma
- Required prefix (optional)
- $
- Required suffix (optional)
- Parentheses as negative
- yes
Example result
| Item | Amount |
|---|---|
| A | 1234.50 |
| B | -2000.00 |
Explicit separators/prefixes only. Output preserves decimal digits rather than rounding through floating point. Not suitable for identifier columns.