Free Online Test Data Generators

Most of your software testing activities will require to use data. 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 begin to require 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 online test generation tool that are listed in this article.

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.

Free Online Test Data Generators

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.

Free Online Test Data Generators

Website: https://www.mockaroo.com/

DatabaseTestData.com

DatabaseTestData.com is a free simple online tool to generate test data. Use an existing data model and customize it to reproduce your table structure or create one from scratch.

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 and 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