~/fake-data ☀ LIGHT apps ← about me

🌐 Language

███████╗ █████╗ ██╗ ██╗ ███████╗ ██████╗ █████╗ ████████╗ █████╗ ██╔════╝ ██╔══██╗ ██║ ██╔╝ ██╔════╝ ██╔══██╗ ██╔══██╗ ╚══██╔══╝ ██╔══██╗ █████╗ ███████║ █████╔╝ █████╗ ██║ ██║ ███████║ ██║ ███████║ ██╔══╝ ██╔══██║ ██╔═██╗ ██╔══╝ ██║ ██║ ██╔══██║ ██║ ██╔══██║ ██║ ██║ ██║ ██║ ██╗ ███████╗ ██████╔╝ ██║ ██║ ██║ ██║ ██║ ╚═╝ ╚═╝ ╚═╝ ╚═╝ ╚═╝ ╚══════╝ ╚═════╝ ╚═╝ ╚═╝ ╚═╝ ╚═╝ ╚═╝

Fake Data Generator_

Build a schema → generate up to 1000 rows of realistic test data. 45+ field types · CSV · JSON · SQL · TSV · YAML · XML
Output | CSV | 0 rows | 0 fields | — | — 

        

          

          

        

        

          

┌──────────────────────────────────────┐
│  id,name,email,status                │
│  1,Alice,alice@ex.com,active         │
│  2,Bob,bob@ex.com,inactive           │
│  3,Carol,carol@ex.com,pending        │
│  ...                                 │
└──────────────────────────────────────┘

          
Build your schema and hit Generate

          
45+ field types · CSV · JSON · SQL · TSV · YAML · XML

        

        

          
          
Generating…

        

      

    


  








  
What is a Fake Data Generator?

  
A fake data generator (also called a test, mock, dummy or sample data generator) creates realistic but entirely fictional records — names, emails, addresses, IBANs, IP addresses, UUIDs, dates and more — that you can drop straight into a database, API or spreadsheet. Instead of testing your app with real customer information, you build a schema of the fields you need, choose how many rows to generate, and export the result. Everything on this page runs 100% in your browser: no data is uploaded, so it is safe for GDPR-sensitive work.


  
45+ Field Types

  
Build any schema you need from over 45 field types across nine categories. Each produces realistic, locale-aware values:

  

  
Why Generate Test Data?

  
Realistic test data is essential across development and QA: seeding a database so a new environment looks real, mocking API responses for front-end work before the backend exists, UI and QA testing with edge cases like long names or missing values, building demos and screenshots without exposing real users, and load testing with thousands of rows. Because the data is fictional, you avoid the legal and privacy risks of copying production data — no real personal information ever leaves your machine.


  
Export to CSV, JSON, SQL, TSV, YAML & XML

  
Generate up to 1000 rows and export in six formats: CSV (with header row), JSON (array of objects), SQL (INSERT statements with a configurable table name), TSV, YAML and XML (configurable root and element names). You can also set a null percentage per field to test how your app handles missing data, and save or share your schema as JSON.


  
Free Mockaroo Alternative

  
This tool offers the core of what paid generators like Mockaroo provide — custom schemas, 45+ field types, a live table preview and six export formats — with no row-count paywall, no account and no sign-up. It runs entirely client-side, so it also works offline once loaded and never sends your schema or generated data to a server.







  FAQ — Frequently Asked Questions about Fake Data Generator
  

    
Frequently Asked Questions — Fake Data Generator


    

      What is a fake data generator and how does it work?
      
A fake data generator creates realistic but entirely fictional datasets — names, addresses, emails, IBANs, IP addresses, coordinates, slugs, and more. Build a schema by adding fields and choosing types, set the row count, and click Generate. All processing runs locally in your browser — nothing is sent to a server.

    


    

      What field types are available?
      
Over 45 field types across 9 categories: Identity (first/last/full name, username, gender, age, blood type), Contact (email, phone, URL), Location (street, city, state, ZIP, country, country code, latitude, longitude), Business (company, job title), Finance (price, credit card, IBAN, currency code), Network (IPv4, IPv6, MAC, port, user agent, HTTP status, HTTP method, protocol), Technical (integer, float, boolean, date, datetime, time, timestamp, UUID, slug, semver, password, hex color, log level, file name, language code, emoji), Text (sentence, lorem, paragraph), Special (number sequence, rating, custom list).

    


    

      What export formats are supported?
      
Six formats: CSV (comma-separated, with header row), JSON (array of objects), SQL (INSERT statements with configurable table name), TSV (tab-separated), YAML (sequence of mappings), and XML (records with configurable root/element name). Switch formats in Settings before or after generating.

    


    

      What is the null % (∅%) option per field?
      
Every field row has a small ∅% input (default 0). Set it to e.g. 20 to make 20% of values in that column null/empty. In CSV/TSV this outputs an empty string; in JSON it outputs null; in SQL it outputs NULL; in YAML it outputs null; in XML it outputs an empty element. This is useful for testing how your app handles missing data.

    


    

      How do I save and load schemas?
      
Click 💾 Save schema to persist your current field configuration in browser localStorage. Click 📂 Load schema to restore it later. Click ⎘ Copy schema to copy the schema as a JSON string you can paste elsewhere or share. The saved schema survives page refreshes.

    


    

      What is the Table view?
      
The ⊞ Table toggle in the output toolbar switches from raw text view to a formatted HTML table, making it easy to visually inspect your generated data. The table shows up to the first 200 rows with sticky headers and null value highlighting. Switch back with  Raw to see the full exportable output.

    


    

      Is the generated data GDPR safe?
      
Yes. All generated data is entirely fictional. It never corresponds to real individuals or organizations and is safe to use in development, testing, and demo environments without GDPR, HIPAA, or other privacy regulation concerns.

    


    

      Is this a free Mockaroo alternative?
      
Yes. Similar functionality to Mockaroo — custom schemas, 45+ field types, six export formats, table preview — completely free, no row limits, no account required, 100% in-browser.