# Fun Data Playground > No-signup, browser-based realistic synthetic test data generator at > https://fundata.dev. Design a schema from 68 field types (names, emails, > addresses, dates, UUIDs, prices, patterns, custom lists…) and export up to > 100,000 rows as CSV, TSV, JSON, NDJSON, SQL or XML — entirely client-side, > so the generated rows never leave the user's browser. Key facts: - No account required; generation runs locally in the browser. An optional account syncs schemas, datasets, generation history and settings across devices. - Optional seed string makes output fully reproducible (same seed + schema = byte-identical data). - Any field can have a Blank % to emit nulls/empty values for missing-data testing. - Credit card numbers use official payment-gateway test PANs; IBANs are country-length-shaped but not bank-valid; emails and network addresses use reserved documentation domains/ranges. - Generation is deterministic, not cryptographic. Values are for fixtures and demos, never for tokens, keys or anything whose security depends on being unguessable. - Person fields (name/email) and location fields (city/country) resolve per row, so a row reads coherently; everything else is drawn independently by design. - Schemas are shareable as URLs (encoded in the hash) and auto-saved to localStorage; signed-in users can also save reusable datasets and create revocable cloud share links. - Every control has a stable data-testid, so the site doubles as a UI-automation practice target. - Every content section has a stable anchor, so a page can be cited by section rather than as a whole; every field type has one too, at https://fundata.dev/types#, and those ids are the ones api/types.json publishes. - Where a page names a standard — RFC 4180, RFC 2606/6761, RFC 4122, ISO 8601, E.164, JSON Schema draft 2020-12 — it links the document that defines it. - Every page shows the date it was last updated, and that date matches its sitemap and its JSON-LD dateModified. - The per-field generator and sample pages generate a live example in the page itself; the button beside it opens the same schema in the full builder. Full text of every page in one file: https://fundata.dev/llms-full.txt Machine-readable field catalogue: https://fundata.dev/api/types.json ## Pages - [Generator](https://fundata.dev/): the schema builder and export tool. - [Field type reference](https://fundata.dev/types): all 68 field types with options and examples. - [Getting started guide](https://fundata.dev/guide): workflow, format cheat sheet, seeds, recipes. - [Use cases](https://fundata.dev/use-cases): database, mock API, QA automation and spreadsheet workflows. - [Database test data](https://fundata.dev/database-test-data): schema, seeding, null and format guidance. - [Mock API data](https://fundata.dev/api-mock-data): typed JSON fixtures and response-state patterns. - [QA test data](https://fundata.dev/qa-test-data): repeatable automation fixtures and edge cases. - [Excel sample data](https://fundata.dev/excel-sample-data): CSV and TSV workflows for spreadsheets. - [Methodology](https://fundata.dev/methodology): generation, privacy and safety details. - [About](https://fundata.dev/about): what the project is, the three decisions behind it, and its deliberate limits. - [Changelog](https://fundata.dev/changelog): what has changed, newest first. Atom feed at https://fundata.dev/feed.xml - [Field types as JSON](https://fundata.dev/api/types.json): the same catalogue as /types, machine-readable and CORS-open. - [CSV export](https://fundata.dev/csv): CSV test data generator details. - [TSV export](https://fundata.dev/tsv): tab-separated export details. - [JSON export](https://fundata.dev/json): typed JSON array export details. - [NDJSON export](https://fundata.dev/ndjson): newline-delimited JSON export details. - [SQL export](https://fundata.dev/sql): INSERT + optional CREATE TABLE export details. - [XML export](https://fundata.dev/xml): well-formed XML records export details. ## Format converters Client-side converters for data the user already has (nothing is uploaded). Each page documents the decisions the conversion has to make. - [CSV to JSON](https://fundata.dev/csv-to-json-converter): optional type detection; a leading zero is never converted to a number. - [JSON to CSV](https://fundata.dev/json-to-csv-converter): nested objects flatten to dotted columns, arrays stay JSON-encoded in one cell. - [CSV to SQL](https://fundata.dev/csv-to-sql-converter): CREATE TABLE with inferred column types plus one batched INSERT. - [JSON to SQL](https://fundata.dev/json-to-sql-converter): same, with nesting flattened to underscored column names. - [XML to JSON](https://fundata.dev/xml-to-json-converter): attributes prefixed @, text-only elements become strings, repeated siblings become arrays. ## Type generators Infer a type declaration from data the user pastes. These read every record, not the first one, so an absent key is optional and mixed numbers collapse. - [JSON to TypeScript](https://fundata.dev/json-to-typescript): nested objects become named interfaces; optional and nullable are kept distinct. - [JSON to Zod](https://fundata.dev/json-to-zod): string refinements (uuid, datetime, email, url); nested schemas emitted before use. - [JSON to Pydantic](https://fundata.dev/json-to-pydantic): aliases for keys that are not legal Python names; only the imports actually used. - [JSON to JSON Schema](https://fundata.dev/json-to-json-schema): draft 2020-12; required derived from presence, nullable as a type array. - [CSV to TypeScript](https://fundata.dev/csv-to-typescript): types depend on whether your parser casts; leading zeros stay strings. ## Per-field generators Each page covers what the field produces, what it deliberately does not do, and where the output is safe to use. - [Random names](https://fundata.dev/random-name-generator): eight locales, row-coherent with email. - [Fake emails](https://fundata.dev/fake-email-generator): RFC 2606/6761 reserved domains that cannot receive mail. - [UUIDs](https://fundata.dev/uuid-generator): valid v4 shape, seeded and therefore NOT cryptographically secure. - [Fake addresses](https://fundata.dev/fake-address-generator): city and country coherent per row; postcodes are shaped, not real. - [Phone numbers](https://fundata.dev/random-phone-number-generator): pattern-driven; no globally reserved range exists, so pick one deliberately. - [Random dates](https://fundata.dev/random-date-generator): ranges, four formats, random or sequential order. - [Test card numbers](https://fundata.dev/fake-credit-card-numbers): the four published payment-gateway test PANs only. - [Fake IBANs](https://fundata.dev/fake-iban-generator): correct country length, random check digits, so mod-97 validation fails by design. ## Ready-made sample datasets Each of these pages carries a live generator and a table of static, committed files under https://fundata.dev/samples/. The files are generated from a fixed seed, so a link to one always returns the same bytes, and they are public domain (CC0). Available as -.: users, employees, orders (csv, json, sql) and sensor-readings (csv, json), at 100 and 1000 rows — e.g. https://fundata.dev/samples/employees-1000.csv - [Sample CSV files](https://fundata.dev/sample-csv-files): configurable columns and row counts. - [Sample JSON data](https://fundata.dev/sample-json-data): typed values and nested objects via dot notation. - [Employee sample data](https://fundata.dev/employee-sample-data): HR schema with departments, hire dates and salaries. - [Sales sample data](https://fundata.dev/sales-sample-data): orders, revenue, regions and a clean time axis. ## Databases and test tooling - [PostgreSQL](https://fundata.dev/postgresql-test-data): COPY, sequences, deferred constraints. - [MySQL](https://fundata.dev/mysql-test-data): LOAD DATA, utf8mb4, AUTO_INCREMENT. - [MongoDB](https://fundata.dev/mongodb-test-data): nested documents and mongoimport. - [Playwright](https://fundata.dev/playwright-test-data): committed fixtures, route mocking, globalSetup seeding. - [Cypress](https://fundata.dev/cypress-test-data): cy.fixture, cy.intercept, cy.task seeding. - [Mockaroo alternative](https://fundata.dev/mockaroo-alternative): what this does, and when a hosted service is the better answer. - [Faker.js alternative](https://fundata.dev/faker-js-alternative): library versus generated file; when the library is right. - [generatedata alternative](https://fundata.dev/generatedata-alternative): self-hosted application versus a static page. - [JSON generator alternative](https://fundata.dev/json-generator-alternative): schema builder versus a template language. - [Random user API alternative](https://fundata.dev/randomuser-api-alternative): local generation versus a runtime fetch. ## Translations English is the default and x-default. Translated pages live in a locale subdirectory and are part of a reciprocal hreflang cluster with their English original. A locale is only published once its page is fully written, never as a machine translation. - [CSV'den JSON'a dönüştürücü (Türkçe)](https://fundata.dev/tr/csv-to-json-converter) - [Convertidor de CSV a JSON (Español)](https://fundata.dev/es/csv-to-json-converter) ## Related - [Fun UI Playground](https://funui.dev): sibling site for practicing UI test automation. - [Fun API Playground](https://funapi.dev): sibling site providing mock REST APIs.