Locale Number Formats — twelve locales (CSV)
The same number, 1234567.89, rendered for twelve locales, with the group and decimal separator that produced each one named by code point and present literally in the cell. Four of the separators are not ASCII — U+00A0, U+202F, U+2019 and U+066C — and ar-EG additionally switches the digits themselves.
locale,language,groupSeparatorName,groupSeparator,decimalSeparator,formatted_1234567_89,numberingSystem
en-US,English (United States),COMMA,",",.,"1,234,567.89",latn
en-GB,English (United Kingdom),COMMA,",",.,"1,234,567.89",latn
en-IN,English (India),"COMMA (3,2,2 grouping)",",",.,"12,34,567.89",latn
de-DE,German (Germany),FULL STOP,.,",","1.234.567,89",latn
de-CH,German (Switzerland),U+2019 RIGHT SINGLE QUOTATION MARK,’,.,1’234’567.89,latn
fr-FR,French (France),U+202F NARROW NO-BREAK SPACE, ,",","1 234 567,89",latn
es-ES,Spanish (Spain),FULL STOP,.,",","1.234.567,89",latn
pl-PL,Polish (Poland),U+00A0 NO-BREAK SPACE, ,",","1 234 567,89",latn
ru-RU,Russian (Russia),U+00A0 NO-BREAK SPACE, ,",","1 234 567,89",latn
ja-JP,Japanese (Japan),COMMA,",",.,"1,234,567.89",latn
zh-CN,"Chinese (Simplified, China)",COMMA,",",.,"1,234,567.89",latn
ar-EG,Arabic (Egypt),U+066C ARABIC THOUSANDS SEPARATOR,٬,٫,١٬٢٣٤٬٥٦٧٫٨٩,arab
Specifications
- Rows
- 12
- Columns
- 7
- Sample Value
- 1234567.89
- Separator Code Points
- U+002C, U+002E, U+00A0, U+202F, U+2019, U+066B, U+066C
- Numbering Systems
- latn, arab
- Delimiter
- ,
- Header
- true
- Seed
- 20260807
- Wave
- p7
- Line Endings
- LF
Testing contract
Reference control- Scenario
- Parse each formatted value back to 1234567.89 using the separators in the same row.
- Expected result
- A parser that strips only ASCII commas and spaces fails on fr-FR, pl-PL, ru-RU, de-CH and ar-EG; the non-breaking and narrow-no-break spaces must survive the CSV round trip rather than collapsing to U+0020.
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
How to use this file for testing
“Locale Number Formats — twelve locales (CSV)” is a deterministic Novus Examples fixture for Internationalization, CSV parsing, Encoding detection. Parallel text and accented, multi-script content — for testing translation pipelines, Unicode handling, and localization tooling.
Documented properties for this file: seed 20260807 · 12 rows · 7 columns · LF. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such — expect parsers to fail loudly rather than silently accept them.
Translation-catalog fixtures carry the same message set across formats, each with its native placeholder syntax. Test your i18n loader, catalog converter, or translation-memory tool, and use the RTL and CJK variants to check bidirectional text and Unicode handling.
Load the catalog with your i18n framework and verify placeholder interpolation and plural handling; the RTL and CJK variants exercise bidirectional text and font fallback.
Code examples
import pandas as pd
df = pd.read_csv("number-formats.csv")
print(df.head())
print(df.dtypes)Related files
- csvCSV — Shift-JIS JapaneseA Shift-JIS encoded Japanese CSV — for CJK charset detection and Shift-JIS→UTF-8 conversion in importers.
- txtLocale Separator and Digit Characters — literal specimensEvery separator, sign and digit set a locale-aware formatter has to survive, each present literally between ASCII guards: the no-break and narrow-no-break spaces, de-CH's U+2019 group separator, the Arabic decimal and thousands separators, the four numbering systems' digits, and CLDR's U+2212 MINUS SIGN, which is not the ASCII hyphen.
- stringsApple .strings — UTF-16 LE with BOM (Japanese)The encoding fixture the .strings format needs: a Japanese catalog written as UTF-16 Little Endian with a byte-order mark, which is what Xcode has historically produced and what a UTF-8-only reader turns into mojibake or a decode error. Also carries full-width punctuation and an ideographic space for width and line-breaking tests.
- txtBidi — bracket mirroring in RTL paragraphs (Hebrew and Arabic)Mirroring is a rendering property of the bidi algorithm, not a transformation of the text: a U+0028 LEFT PARENTHESIS inside an RTL run is DRAWN as ')' while the stored byte never changes. These Hebrew and Arabic lines make that testable, and list the neutral characters that look like they should mirror but do not.
- txtBidi — where a mark is actually required (Arabic)Six Arabic sentences containing a Latin filename, a phone number, a version range, a mixed-script path, a percentage and a bracketed insertion — each shown first as a translator usually delivers it and then with the one invisible character that makes it render correctly. The two forms differ by exactly one code point.
- csvBidi Test-Case Matrix — eight rendering casesA flat index of the bidi cases in this wave — which mark each one uses, what it should render as, and why the neutral characters involved need help. Row b8 is the control case with no marks, against which the other seven are compared.
Generated by generation/localization_p7.py. Free for any use, no attribution required — license.