Fake Canada Data Generator

What data types can you generate?

This fake Canadian data generator covers 27 field types across six categories, all produced with Canada-appropriate values:

• Person — full name, first name, last name, email address, phone number, username, password, birth date, gender, job title
• Location — street address, city, province, postal code, country, latitude, longitude
• Business — company name, website URL
• Internet — IPv4 address, MAC address
• IDs & numbers — UUID, random number, boolean
• Text — lorem ipsum word, sentence, paragraph

Combine any mix of these into a single dataset. A typical Canada test dataset might include first name, last name, email, phone, street address, city, postal code, and company — all generated together in one click.

Why generate Canadian data?

When you generate Canadian data, the names, addresses, and phone numbers follow Canada conventions — not just translated labels, but structurally correct data. That means Canadian names, Canada phone formats, and addresses with a proper province and postal code. This is essential for testing internationalised applications, checking that your UI handles Canada characters, or demoing a product to a Canada audience with locally appropriate data.

Need a different locale? Use the selector above, or visit the US fake data generator.

Example Canadian dataset

Here is a sample of the Canadian data this generator produces — Canada names, emails, phone numbers, and cities (all fictional):

Build a complete schema — not just one field at a time

Most simple fake data generators let you pick one field and copy a list. That works for a quick email address, but it's useless when you need a full user table for a database seed script or a realistic CSV for an import test.

This tool works like a lightweight schema builder. Add as many columns as you need, give each one a name and a data type, and generate all the rows in one pass. Four presets cover the most common cases:

• Person — first name, last name, email, phone, birth date
• Address — street, city, province, postal code, country
• Company — company name, job title, email, website
• Full Profile — ID, name, email, phone, address, country, company, and job title in one table

Column names are editable, so you can match your exact database schema or field naming convention before exporting.

Export fake data as CSV, JSON, or SQL

Once you've generated your rows, pick the export format that fits your workflow:

• CSV — a header row followed by comma-separated values, ready to open in Excel, Google Sheets, or Numbers. Also works for database import wizards, pandas read_csv, and any tool that accepts flat files.
• JSON — an array of objects with your column names as keys. Drop it straight into a REST API mock, a Node.js fixture file, a json-server database, or a front-end component that consumes JSON.
• SQL — a ready-to-run INSERT INTO statement compatible with MySQL, MariaDB, PostgreSQL, and SQLite. Set the table name before exporting to match your schema. String values are properly single-quote escaped; booleans and numbers are unquoted.

Hit Download to save the file directly, or Copy to paste it wherever you need it. Up to 1,000 rows per generation.

Completely free — no account, no limits

There is no account to create, no API key to manage, and no daily row limit. Generate as much Canadian data as you need. All data is generated locally in your browser using Faker.js — nothing is transmitted to any server, and nothing is stored. The tool works offline once the page has loaded.