Fake CRM Contacts CSV for Testing Imports, Email Flows and Lead Reports
Before you import a list into a CRM or send a test campaign, you need contacts that cannot reach a real person. Generate a fake contacts file with safe email addresses in your browser, free.
Why the email domain matters
A test file full of realistic addresses is risky: one test send to a real-looking domain can land in a stranger's inbox. The contacts in this dataset use only the reserved domains example.com, example.org and example.net. These are set aside for documentation and testing and are not meant to receive mail, so a test send cannot reach a real person.
The ordinary Email column type in the generator uses a few made-up domains, and some real domains could be in use. For anything you might send, use the CRM contacts dataset or the Email (reserved example domains) column type.
What is in the file
Open the Data Generator, choose Marketing and pick CRM contacts. Each row has a contact id, first and last name, email, phone (empty on about 15 percent of rows), company, job title, lead source, lifecycle stage, lead score from 0 to 100, an opted-in flag (true for about 70 percent) and a creation date. Lead sources and lifecycle stages are weighted, so most contacts are early-stage leads and few are customers, as in real databases.
Things to test with it
Field mapping: check that your CRM maps each column to the right field and that names with spaces or accents survive. Missing values: the empty phones show how the import treats blank cells. Consent: filter on opted_in to confirm that your email flow skips contacts who did not agree. Reports: build a funnel by lifecycle stage and a lead-source table, and check the totals.
Check the file before you import
Run it through the Data Profiler to see blanks and duplicates, and remember that duplicate rules differ between tools, so test that part with a few rows you add yourself. Each generated contact id is unique.
If you must use a real list
Do not copy a live customer list into a test system. If you need real structure, mask customer data first or create GDPR-safe test data from the shape of the real file. The email-marketing rules that apply to real people, such as consent, do not apply to this fake data, but they apply the moment you use a real list. This is not legal advice.
Related tool pages
- Fake Data Generator: Generate realistic fake data online: names, emails, addresses, dates and more, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
- Test Data Generator: Generate test data for databases and apps: names, emails, addresses, dates and numbers, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
- Student Data Generator: Fake Student Records: Generate fake student data for class projects: IDs, names, courses, marks and attendance. Download CSV, Excel, JSON or Parquet. Free.
- Student Marks Dataset Generator: Create a student marks dataset by student, subject and exam for SQL, Excel pivot tables and charts. Free, in your browser.
- Sample Data for SQL Practice: Generate sample tables for SQL practice (students, orders, employees), download CSV and query it in your browser. Free.
- Dummy Data for Excel Practice: Generate dummy sales, student or employee data and download Excel to practise filters, pivot tables and VLOOKUP. Free.
Also try
- Mask customer data before sharing reports
- GDPR test data generator
- Sample marketing campaign dataset
- Data Profiler
How to use the Data Generator: step by step
- Open the Data Generator and choose CRM contacts.
- Choose the number of rows.
- Download CSV (or Excel).
- Import it into your test CRM or email tool.
When to use the Data Generator
- Test a CRM or email tool import without real people
- Check field mapping and blank handling
- Test opt-in filtering in an email flow
- Build a lead funnel report before real data arrives
Example
Input: Dataset: Customers, 3 rows
Output: id,name,email 1,Maya Patel,maya.patel@example.com 2,Leo Fischer,leo.fischer@example.com
Frequently asked questions
Can a test email to these contacts reach a real person?
No. They use only example.com, example.org and example.net, which are reserved for testing and are not meant to receive mail.
Are the names and companies real?
No. They are random combinations from word lists, so a contact may happen to share a name with a real person, but none describes a real contact.
How many contacts can I generate?
Up to 500,000 rows in the Data Generator. Download CSV, Excel, JSON or Parquet.
Tip: Keep a copy of the generated file. If an import goes wrong you can fix the mapping and try again with the same rows.