convert-csv.com logo convert-csv.com

Generate Test Data to CSV / Excel / JSON

Build realistic mock datasets (names, emails, dates, numbers) and export to CSV, Excel, or JSON.

100% Secure - your files are processed in your browser and never sent to a server.

Mock Data Generator

Design columns and build sample files in your browser.

Test data generation is a critical part of software development, quality assurance, and data pipeline testing. This tool generates realistic mock datasets with configurable row counts and column types. You can generate columns containing names, email addresses, phone numbers, dates, numbers, addresses, and custom text patterns. The generator uses seeded randomness to produce data that looks realistic without containing actual personally identifiable information (PII). This is important for testing applications that process user data, as it avoids privacy risks associated with using real customer data for development. The generated data can be exported as CSV, Excel (XLSX), or JSON, making it compatible with any testing framework, database import tool, or data pipeline. All generation happens in your browser, so test datasets containing simulated sensitive data never leave your device. The tool is useful for load testing, UI development, database seeding, and data format validation.

How to use the Generate Test Data tool

  1. Design your schema: Add columns by specifying a column name and selecting a data type: id, uuid, name, email, phone, address, company, date, or number.
  2. Configure fields: For number and date types, set min and max values to control the generated range.
  3. Set row count: Enter how many rows of mock data you want to generate.
  4. Generate data: Click the "Generate Mock Data" button to create a realistic dataset.
  5. Export results: Copy the generated data to your clipboard or download it as a CSV file.

Frequently asked questions

What types of test data can I generate?
The tool generates names, email addresses, phone numbers, dates, integers, decimals, addresses, and custom text patterns. You can mix column types in a single dataset.
Is the generated data real PII?
No. The generator produces realistic-looking but fictional data. Names are randomly generated, email addresses use fake domains, and phone numbers are not assigned to real people.
What export formats are available?
Generated data can be exported as CSV, Excel (XLSX), or JSON. Choose the format that matches your testing framework or data pipeline requirements.
Can I generate a specific number of rows?
Yes. You configure the row count before generation. The tool supports generating from 1 to 100,000 rows of test data.
Can I use this for database seeding?
Yes. Generate CSV or SQL-format test data and import it into your database using standard tools. The realistic data makes it useful for development and staging environments.

Related tools