Explore

How it works:

Simply define your table names, record counts, data parameters and let generator do the rest! You can preview the generated data, modify parameters and download it when you're ready.

For data types definitions and available options - check this out.

Benefits of Being an Authorized User:

Feature Non-authorized Authorized
Generation of all 35+ data types available (more to come)
Real-time results preview
Download single tables in CSV & XLSX format
Download all tables ZIPed in CSV & XLSX format
Number of generations per day unlimited unlimited
Maximum number of records per table 1000 10000
Dataset save & load
Dataset structure page (ERD & SQL generation)
No-spam newsletters with important updates

Data Types Definitions

Data Type Comments
Numbers
Integer Generates a list of integers in selected min-max range with chosen distribution type, outliers, repeats and missing values percentage. Distribution types are - ['uniform', 'normal', 'logarithmic', 'exponential', 'reverse_exponential'], outliers are generated in 1/2 of min-max range and can be from both sides of the range of just from top/bottom. Repeats % sets how often generated values will be repeated, missing values are filled by None and spread randomly across whole generated values list.
Float A number that has a decimal place, you can set number of decimals. Other options are the same as for Integer.
Ordinals Generates a list of incrementing ordinal elements starting from start_value with chosen increment, prefix, suffix and padding for each value, repeats and missing values percentage. Let's say, to get "user_001, user_002" etc. you need to set prefix to "user_", start to 1, increment to 1 and padding to 3 - these are number of decimal places filled with 0. Can be used as a PRIMARY KEY by checkbox option
Booleans Generates a list of booleans with set True probability and missing values percentage True probability of 50% (default) makes both options (true or false) equal in terms of probability - as when you flip a coin.
Text
Custom texts Generates a list of randomized values from user-provided list with set repeats and missing values percentage. Perfect for making data based on your input. Just type some words separated by commas "," and it will use this list as a source. PRO TIP: use AI to make a list of everything you need (product types, medicine names, airport names, plants etc.) and paste it to generator.
Catch phrase Generates a catch phrase in selected language, repeats and missing values percentage. Sounds weird most of the time but good enough for some department name.
Sentences Generates sentences in selected language, repeats and missing values percentage. Sounds weird all the time but sometimes even funny. You can change the number of generated sentences from 1 to 10 to make a short story.
Text string Generates words, phrases, or even a paragraph in selected language, repeats and missing values percentage. Set approx number of letters, default 20, max = 1000, min = 10. The bigger the number - result will change from single words to a new Hemingway story.
Dates
Date / datetime Generates a list of dates or datetimes with desired repeats, missing values, and outliers percentage. Dates use "YYYY-MM-DD" format, datetime include time without timezone "YYYY-MM-DD HH:MM:SS".
Geographical
Latitude / Longitude Generates a list of latitude-longitude pairs, with optional address in selected country, repeats and missing values percentage.
Country Random country names in selected language with optional repeats and missing values.
City Random city names in selected language with optional repeats and missing values.
Address Random addresses in selected language with optional repeats and missing values.
Primary and foreign keys
Primary key Generates a PRIMARY KEY - a simple enumeration from start value up to number of table rows with 1 increment (1,2,3,4....). Ideal for index-like data or row numbers. Must-have for almost every table.
Foreign key This field type is for making a link to another's table PRIMARY KEY to make the most of a TRUE RELATIONAL DATABASE approach.
Colors
Color names Just color names in selected language if you need it.
Colors in HEX If you speak HEX - these color names are made for you.
Colors in RGB Is RGB your native language? Use those color names then.
People
Full names Generates a list of people names (not real) in selected language, repeats and missing values percentage. And yes - only 2 sex options.
Professions Makes a list of real-life professions in selected language.
Phone numbers Generates phone numbers by following format_str: a set of symbols telling generator the pattern for the phone number
  1. Blocks for country code, area code and number, separated by '-'.
  2. Digits in brackets () are static.
  3. Other digits give us a length of a number to generate (2 means 2-digit number, 7 = seven digits etc.)
For example: (9)2-3-(12)5 will give us a number of country code (starting with "9", then 2 random digits), area code (3 random digits) and a phone number (starting with "12" then random 5 digits). Results should look like: 9314531256940, 9650201245061 etc.
Business
Company names Generates a list of company names in selected language, repeats and missing values percentage.
Credit card numbers Generates a list of valid credit card numbers of the selected card type, repeats and missing values percentage.
Automotive
Car brands and models Generates a list of car names (brand and model), repeats and missing values percentage.
VIN numbers Generates a list of VIN numbers, repeats and missing values percentage.
Car registration plates Generates a list of car registration plates, repeats and missing values percentage.
IT
IP addresses Generates random IP addresses, repeats and missing values percentage.
MAC addresses Generates random MAC addresses, repeats and missing values percentage.
User agent strings Generates random User agent strings, repeats and missing values percentage.
Passwords Generates random passwords from 4 to 20 symbols long, repeats and missing values percentage.
UUID's Generates random UUIDs with primary key option, repeats and missing values percentage.
Image URL's Generates random image URLs, repeats and missing values percentage.
Emails Generates email from given format string, repeats and missing values percentage.
Websites Generates website addresses from given format string, repeats and missing values percentage.