Mock Data Generator Online — Free Fake JSON, CSV & SQL Test Data

• Auto Increment — Sequential integer starting at 1. Perfect for primary keys (id, seq). Output as a number, not a string — databases and JSON parsers treat it correctly.
• UUID — Standard v4 UUID: 550e8400-e29b-41d4-a716-446655440000. Use for distributed IDs, API resource identifiers, and GUID fields.

• Name — Culturally appropriate full name from 12 locale pools. English: John Smith, Korean: 김민준, Japanese: 田中 一郎, Arabic: محمد العلي
• Username — Login-style handle: jessica_42 or michael73. Combines a common first name with a numeric suffix.
• Email — Realistic email address: james312@gmail.com. Generated from a name pool and common domain list.
• Phone — Country-formatted phone number in 12 locales. US: +1-555-234-5678, Korea: +82-10-1234-5678, Germany: +49-151-12345678

• Integer — Random whole number within your min/max range. Output as a JSON number (not quoted).
• Float — Random decimal within range with configurable decimal places. 3.14, 99.99
• Boolean — Random true or false. Output as a JSON boolean (not a string).
• Date — Random date within a From/To range: 2023-07-15. YYYY-MM-DD format.
• Timestamp — Unix epoch seconds within a date range: 1718455800. Output as an integer. Multiply by 1000 for millisecond APIs.

• URL — Plausible HTTPS URL: https://cache.io/users
• IPv4 — Random public IP address: 203.0.113.42
• IPv6 — Full 128-bit address: 2001:0db8:85a3:0000:0000:8a2e:0370:7334
• MAC Address — Network hardware address: AA:BB:CC:DD:EE:FF

• Hex Color — CSS color value: #3a7bd5. Use for avatar color seeds, theme data, or color picker testing.
• Lorem Text — N lorem ipsum words inline: lorem ipsum dolor sit amet. Configurable word count.
• Country — Random country name from a pool of 40 countries: South Korea, Germany, Brazil
• Enum — Random pick from your comma-separated list. pending, active, suspended → always one of those three values.
• Custom (Fixed) — Same value in every record. currency: "USD", source: "api". Distinct from Enum — never random.

Example — 2 records with id (Auto Increment), name, email, active (Boolean):

[
  {
    "id": 1,
    "name": "Jessica Garcia",
    "email": "james312@gmail.com",
    "active": true
  },
  {
    "id": 2,
    "name": "김민준",
    "email": "linda77@example.com",
    "active": false
  }
]

Same schema as CSV — ready for Excel, Google Sheets, or database import:

id,name,email,active
1,"Jessica Garcia",james312@gmail.com,true
2,김민준,linda77@example.com,false

SQL INSERT — paste directly into MySQL, PostgreSQL, or SQLite:

INSERT INTO users (id, name, email, active) VALUES (1, 'Jessica Garcia', 'james312@gmail.com', true);
INSERT INTO users (id, name, email, active) VALUES (2, '김민준', 'linda77@example.com', false);

Strings are single-quoted and escaped; numbers and booleans are unquoted. Set the table name in Output Settings.

Generate modes:

• Words — lorem ipsum dolor sit amet — a flat list of N words
• Sentences — Capitalized sentences ending in a period (or 。 for CJK)
• Paragraphs — Multiple sentences grouped into paragraphs, separated by blank lines