Declared CSV Number Parser
Parse explicit decimal and grouping separators across CSV columns without guessing locale or rounding source decimals.
Loading tool…
How to use Declared CSV Number Parser
Prepare imported numeric text with visible parsed, missing and invalid statuses. Original cells remain beside canonical exact decimal strings, so ambiguous separators and rejected values can be reviewed before further calculations.
- Enter input, selected columns json, exact missing tokens json, new column suffix.
- Choose the settings for declared csv number parser, then run the tool.
- Review the result and any limitations before copying or downloading it.
Good to know
- 5,000 records, 20 selected columns, 200,000 CSV characters, 100 source characters per number, 12 fractional digits and exact magnitude up to 1 e 15. Generated cell text is capped at 350,000 characters.
- Only explicit three-digit groups, ASCII digits and optional leading + or - are supported. Currency, exponents, parentheses, locale guessing and implicit missing tokens are not supported; output decimals are not rounded.
- Processing is local. Output is limited to 1,000,000 text characters unless a stricter file limit is stated.
Common questions
Is 1,234 interpreted as a decimal or a grouped integer?
Only your settings decide. A comma decimal setting means 1.234; a comma grouping setting means 1234. Conflicting settings are refused rather than guessed.
Is this input sent to a server?
No. The application processes this input inside your browser tab and does not save it to persistent storage.
Keep going with related tools
All data →Locale Number Formatter
Format a finite decimal in an explicit locale, showing the resolved locale and formatted parts.
DataSupported CSV Data Schema Validator
Check a small declared CSV schema for column types, required cells and composite primary-key uniqueness.
DataBounded CSV Arithmetic Column
Create a numeric CSV column from a fixed JSON arithmetic AST without executing spreadsheet formulas or user code.
DataExact Grouped CSV Rank Annotator
Add per-group numeric ranks to CSV rows with exact decimal ordering and explicit tie rules.
DataDeclared CSV Calendar Date Parser
Validate imported date-only columns against an explicit fixed pattern and preserve invalid-date evidence.