Most of your software testing activities will require to use data. Sometimes it could be just a small amount, however if you must test a feature to deliver an order confirmation on more than one page, then you need something other than a few items. An online test data generator is a tool that can assist you in this task by automatically generating hundreds or thousands of customers, products, or account items with various ID, email, name, and other attributes.
An online test data generator can generate test data files in different formats: CSV, JSON, XML or SQL. If you have long-term needs and technical skills, you could opt for an open source test data generator. Otherwise, you can use one of the readily available free online test generation tool that are listed in this article.
Updates
Nay 9 2024
* added RNDGen Data Generator, ExtendsClass Test Data Generator
GenerateData
Generatedata.com is the website of the open source project with the same name. This is essentially an engine to generate any sort of random data in any format. It currently comes with 30 or so Data Types (types of data it generates), 12 Export Types (formats for the data, like CSV, SQL, JSON), plus around 32 data sets for specific countries (city names, regions etc.). But more importantly, it can be extended in any way you want.
Website: https://generatedata.com/
Mockaroo
Mockaroo is an online tool that allows you to quickly and easily to download large amounts of randomly generated test data based on your own specs which you can then load directly into your test environment using SQL or CSV formats. Mockaroo has both paid and free plans. The free version is limited to 1,000 rows per file.
Website: https://www.mockaroo.com/
DatabaseTestData.com
DatabaseTestData.com is a free simple online tool to generate test data. You can use an existing data model and customize it to reproduce your table structure or create one from scratch to generate your testing data.
Website: https://www.databasetestdata.com/
Randat
Randat is a free online tools that allows you to generate a table with random personal information: name, age, occupation, salary, etc. To use this tool, you can simply select the preferred columns (on the left), the number of rows and then press “generate” button. You can also export (save) the generated table as MS Excel (.XLS, .XLSX) or .CSV file.
Website: http://www.randat.com/
Online Data Generator
Online Data Generator is a free online service meant to help developers and testers to generate test data for software application. As such, you can generate realistic test data that includes: fake address or random postal address, books, movies, music, brand, business, colors, country, credit card, date and time, education, gender, identification number, money numbers, person random names, random email address, programming and internet.
Website: https://www.onlinedatagenerator.com/
FillDB
FillDB is a free tool that lets you quickly generate large volumes of custom data in MySql format to use in testing software and populating databases with random data. The application will try to guess the format of data required based on column names. Then it will generate random names, dates, emails, addresses and more to fill your MySQL database with data. Just upload your database schema and this unique online service will generate database test data in multiple relational tables with Foreign Key Support. It can generate unique values, and optional data, populate with values from another table.
Website: https://filldb.info/
JSON Generator,
JSON Generator is an online tool that handles the heavy lifting for generating structured JSON objects, stuffed with sequenced and/or controllable random data. JSON Generator has an easy, but powerful templating language. This tool has a convenient REST API. You can fetch your data with the HTTP requests.
Website: https://www.json-generator.com/ and https://next.json-generator.com/
ExtendsClass Random Data Generator
ExtendsClass Random Data Generator is a free online tool that allows you generating random test data, with data close to real data. There is no limitation on the volume of data generated in your browser. This tool allows you to quickly define the content of the test data stream to be generated. It will redirect you to one of our 3 data generation tools (with your preselection). A basic data generator (CSV/JSON/XML/SQL): It allows generating data in different formats, with a single level (no sub-object, no array, no XML attribute, …).
A complex JSON data generator: This tool generates JSON data with a complex tree structure (with sub-objects, arrays, …). A complex XML data generator: This tool allows generating XML data with a complex tree structure (with sub-tags, tag attributes …).
Website: https://extendsclass.com/random-data-generator.html
RNDGen Data Generator
RNDGen Random Data Generator is a free user-friendly tool for generating test data. The data creator uses an existing data model and customizes it to create a mock data table structure for your needs. Random Data Generator also known like json generator, dummy data generator, csv generator, sql dummy or mock data generator.
The RNDGen Dummy Data Generator allows you to easily create dummy data for tests that are representative of real-life situations. You can choose from a wide range of fake data fields, such as name, email, location, address, zip and vin codes, and many more.
You can customize generated dummy data to meet your specific needs. RNDGen can quickly generate thousands of fake data rows in different formats, including CSV, SQL, JSON, XML, Excel. This makes it the ultimate tool for all your data generation needs instead of standard mock datasets.
Website: https://www.rndgen.com/data-generator
ExtendsClass Test Data Generator
ExtendsClass Test Data Generator is a free online tool that allows you to generate random test data, with data close to real data. There is no limitation on the volume of data generated in your browser. With ExtendsClass Test Data Generator you can quickly define the content of the test data stream to be generated. It will redirect you to one of our 3 data generation tools (with your preselection):
* A basic data generator (CSV/JSON/XML/SQL): It allows generating data in different formats, with a single level (no sub-object, no array, no XML attribute, …). You can also generate SQL.
* A complex JSON data generator: This tool allows generating JSON data with a complex tree structure (with sub-objects, arrays, …).
* A complex XML data generator: This tool allows generating XML data with a complex tree structure (with sub-tags, tag attributes …).
Website: https://extendsclass.com/random-data-generator.html
Very informative article. Useful tools and links.