Test Data Generator

Generate realistic structured data in seconds for development, API testing, and database mocking. Your data is generated entirely in the browser.

How to Use
1 Design Your Schema: Enter the column names for your table. When you select one of the system's data types for each column, your column name will be automatically updated according to the data type. You can change this name if you wish.
2 Determine the Empty Data Rate: In real-life databases, not every field is populated. Use the "Empty %" setting to determine the ratio of "null" values for that column. You can enter a value manually into the box or use the slider.
3 Generate and Export Data: Select the number of records (up to 10,000) from the bottom section and click the "Generate Data" button. You can instantly view the results with pagination and download them to your computer as a CSV, JSON, or direct SQL file.