Mock CSV Data for Canada
Canadian mock data has its own shape: A1A 1A1 postal codes, prices in CAD, +1 (NANP) phone numbers, and a mix of English and French names reflecting bilingual reality. CSV.si lets you generate it without writing locale logic yourself.
What Canadian data should look like
- Postal codes: letter-digit-letter, space, digit-letter-digit —
M5V 3L9. The first letter encodes the province (M = Toronto, V = BC, H = Quebec).
- Phone numbers:
+1 416 555 0123— same NANP format as US numbers.
- Currency:
CA$1,234.56or$1,234.56 CAD.
- Provinces: 2-letter codes (ON, QC, BC, AB, MB, SK, NS, NB, NL, PE, YT, NT, NU).
- Names: a realistic dataset mixes Anglo (Jack, Emma), French-Canadian (Mathieu, Camille), and Indigenous or recent-immigrant names.
Generating it in CSV.si
Add columns for name, email, phone, postal code, province, and amount. Pick row count, download. The export is UTF-8 with BOM so French accents (é, à, ç) render correctly in Excel on Windows.
Frequently asked questions
Do you generate SIN numbers?
No — generating plausible Social Insurance Numbers, even for testing, can be misused. Use obvious placeholder values like '000-000-000' instead.
Are addresses in French or English?
Generic addresses use English street names. For Quebec-specific tests, customize the city column to QC values.