Mock API Data for Frontend and Backend Testing
You need believable records now, and the real API is not ready or not safe to use. Here is how to make test data in a minute.
A front end needs a list of users, orders or products to render. A back end needs rows to load. Real data brings privacy questions, and a hand-written file of five records hides the problems that appear at five thousand.
The Mock Data Generator creates realistic fake names, emails, addresses, dates and more. Choose a dataset or your own columns, set up to 500,000 rows, and download JSON, CSV, Parquet or Excel. JSON suits an API mock or a front end, CSV suits a database import.
To mirror a real table, paste a CREATE TABLE into the Schema Data Generator and get rows that fit every column type and rule. That is a quick way to test a loader or an import with the right shape.
Use test data well. Create a large file to check pagination and speed, and add odd values on purpose, such as very long names, empty fields and special characters. Mark test files clearly so they are not mistaken for real data. Generated data is random, so it will not match the statistics of production data.
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.
- Fake Database for Testing: Create a fake database for testing: paste a CREATE TABLE script and get realistic rows as INSERT statements, CSV or JSON. Free, in your browser.
How to use the Mock Data Generator: step by step
- Open the Mock Data Generator.
- Choose the fields and the number of rows.
- Download JSON or CSV.
- Add a few odd rows by hand to test edge cases.
When to use the Mock Data Generator
- Fill a front end with realistic records
- Load test rows into a database
- Test pagination and performance with a big file
- Build a demo without real customers
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
Is the data real?
No. It is random and fictional, so it is safe to share.
Can I get the same data again?
No – each click makes new data. Download to keep a set.
How many rows can the Data Generator create?
Up to 500,000 rows at a time. Choose column types such as names, emails, addresses and dates, then download as CSV, JSON, Parquet or Excel.
Tip: Generate both a small and a very large file. Many bugs only show at size.