About the Random CSV Generator
Testing a spreadsheet import, a database loader or a chart usually needs a CSV file with plenty of rows, and typing them by hand is slow. This generator makes the rows for you. Choose how many rows you want, tick the columns, and decide whether the first line should be a header. Every row is one consistent made-up person, so the email matches the name and the city matches the postal code. Values that contain a comma, a quote or a line break are wrapped in quotes the way spreadsheets expect. Emails end in example.com and phone numbers use the fictional 555-01xx range, so nothing can reach a real person. The data is made in your browser and never uploaded.
Updated October 2026
How to use the Random CSV Generator
- 1Enter how many rows you want, from 1 to 500.
- 2Tick the columns to include, such as full name, email, city and date of birth.
- 3Leave Include a header row ticked if you want column names on the first line.
- 4Press Generate. Press it again for a new set of rows.
- 5Copy the CSV, or download it as random.csv and open it in Excel, Google Sheets or Numbers.
What the rows look like
With the default columns, each row has a full name, an email, a city and a date of birth. The extra columns add the rest of the person: first and last name, phone, username, company, job title, street, state, postal code, country, IP address and website.
- fullName: a first and last name, for example Mia Ortiz
- email: the same name in lower case on example.com
- city, state and postalCode: one city per row, so they agree
- birthDate: a year-month-day date between 1950 and 2005
When random CSV is useful
- Trying out a spreadsheet formula, a pivot table or a chart on realistic rows.
- Testing a CSV import in a CRM, a shop, a mailing tool or your own code.
- Filling a database table during development.
- Making a training file for a class, a tutorial or a screenshot.
- Checking how a program copes with hundreds of rows and values that need quoting.
Choosing the columns
Match the columns to what you are testing. An email import needs a name and an email. An address import needs the street, city, state, postal code and country. Fewer columns keep the file small and the problems easy to spot.
If your importer is strict about column names, rename the header line after generating. Our CSV Column Replacer and the other CSV tools can also add, remove or reorder columns.
Safe sample data
Real customer lists do not belong in test files. Generated rows carry no personal data, and example.com is reserved so test emails can never be delivered to a real inbox.
Phone and computer
The options stack in one column on a phone. The result box scrolls sideways when rows are long, and Copy and Download are under it.
Features
- Sixteen columns to choose from, including names, email, phone, company, address parts and website
- Up to 500 rows per press
- Optional header row
- Proper CSV quoting for commas, quotes and line breaks
- Safe placeholders: example.com emails and fictional phone numbers
- Made on your device with the browser's secure random generator
Frequently asked questions
Does the CSV open in Excel and Google Sheets?
Yes. The file uses commas between columns and a line break between rows, with quotes around any value that needs them, which is the layout both programs expect.
Is the data real?
No. Names come from lists of common first and last names mixed at random, emails end in example.com, and phone numbers use the fictional 555-0100 to 555-0199 range.
Can I leave out the header row?
Yes. Untick Include a header row and the result starts directly with the first data row, which suits importers that add their own column names.
Why do some values have quotes around them?
A value that contains a comma, for example a job title such as Director, Sales, must be quoted or it would split into two columns. Spreadsheets remove the quotes when they open the file.
Can I get a semicolon or tab separated file?
For tabs use our Random TSV Generator. For semicolons, make the CSV and then run it through the CSV Delimiter Changer.
How many rows can I make?
Up to 500 rows per press. Press Generate again and join the results for more, or use the Fake Data Generator for up to 1,000 rows.
Is the result the same each time?
No. Each press uses your browser's random generator and makes new data, so copy or download the result if you want to keep it.
Is my data sent to a server?
No. Everything is made in your browser, and nothing is uploaded.