測試資料產生器

產生逼真的測試姓名、電子郵件、地址等，匯出 CSV 或 JSON

檔案不會離開你的裝置
在瀏覽器本機執行
免費、免註冊、無浮水印

不會產生銀行帳號、信用卡號、IBAN、稅號、社會安全號碼、護照號碼或其他證件號碼。電子郵件只用 example.com/.org/.net，IP 只用文件專用位址段，美國電話使用保留的 555-01xx 號段。

欄位

從範本開始

起始
隨機國家
最小年齡
最大年齡
為真的比例 %

預覽 · 共 100 列，顯示前 8 列

id	name	email	username	phone	city	country	birth_date	active
1	Olivia Hernandez	olivia.hernandez@example.com	oliviah23	(889) 555-0100	Austin	United States	1952-06-13	true
2	Susan Taylor	susantaylor@example.net	susantaylo837	(398) 555-0137	New York	United States	1994-12-11	false
3	Jennifer Wilson	jennifer84@example.net	jennifer.wilson880	(672) 555-0158	Seattle	United States	1997-12-23	true
4	Noah Lewis	noah.lewis@example.org	noah_lewis315	(369) 555-0128	New York	United States	1961-03-18	true
5	John White	jwhite@example.com	john_white542	(436) 555-0113	New York	United States	1995-12-15	false
6	Mary Thomas	mthomas@example.com	mary.thomas205	(709) 555-0110	Boston	United States	2001-02-24	true
7	Susan Perez	susan87@example.net	susanper610	(838) 555-0179	Portland	United States	1986-04-17	false
8	John Brown	john76@example.com	john_brown422	(970) 555-0173	Chicago	United States	1965-01-15	true

JSON

[
  {
    "id": 1,
    "name": "Olivia Hernandez",
    "email": "olivia.hernandez@example.com",
    "username": "oliviah23",
    "phone": "(889) 555-0100",
    "city": "Austin",
    "country": "United States",
    "birth_date": "1952-06-13",
    "active": true
  },
  {
    "id": 2,
    "name": "Susan Taylor",
    "email": "susantaylor@example.net",
    "username": "susantaylo837",
    "phone": "(398) 555-0137",
    "city": "New York",
    "country": "United States",
    "birth_date": "1994-12-11",
    "active": false
  },
  {
    "id": 3,
    "name": "Jennifer Wilson",
    "email": "jennifer84@example.net",
    "username": "jennifer.wilson880",
    "phone": "(672) 555-0158",
    "city": "Seattle",
    "country": "United States",
    "birth_date": "1997-12-23",
    "active": true
  },
  {
    "id": 4,
    "name": "Noah Lewis",
    "email": "noah.lewis@example.org",
    "username": "noah_lewis315",
    "phone": "(369) 555-0128",
    "city": "New York",
    "country": "United States",
    "birth_date": "1961-03-18",
    "active": true
  },
  {
    "id": 5,
    "name": "John White",
    "email": "jwhite@example.com",
    "username": "john_white542",
    "phone": "(436) 555-0113",
    "city": "New York",
    "country": "United States",
    "birth_date": "1995-12-15",
    "active": false
  },
  {
    "id": 6,
    "name": "Mary Thomas",
    "email": "mthomas@example.com",
    "username": "mary.thomas205",
    "phone": "(709) 555-0110",
    "city": "Boston",
    "country": "United States",
    "birth_date": "2001-02-24",
    "active": true
  },
  {
    "id": 7,
    "name": "Susan Perez",
    "email": "susan87@example.net",
    "username": "susanper610",
    "phone": "(838) 555-0179",
    "city": "Portland",
    "country": "United States",
    "birth_date": "1986-04-17",
    "active": false
  },
  {
    "id": 8,
    "name": "John Brown",
    "email": "john76@example.com",
    "username": "john_brown422",
    "phone": "(970) 555-0173",
    "city": "Chicago",
    "country": "United States",
    "birth_date": "1965-01-15",
    "active": true
  },
  {
    "id": 9,
    "name": "Mary Gonzalez",
    "email": "mary_gonzalez@example.org",
    "username": "mary_gonzal977",
    "phone": "(847) 555-0124",
    "city": "Austin",
    "country": "United States",
    "birth_date": "1955-01-12",
    "active": false
  },
  {
    "id": 10,
    "name": "Lisa Jones",
    "email": "lisa.jones@example.net",
    "username": "lisa_jo342",
    "phone": "(354) 555-0161",
    "city": "Phoenix",
    "country": "United States",
    "birth_date": "1986-12-24",
    "active": true
  },
  {
    "id": 11,
    "name": "Lisa Walker",
    "email": "lisa71@example.org",
    "username": "lisa.w715",
    "phone": "(944) 555-0189",
    "city": "Portland",
    "country": "United States",
    "birth_date": "1951-04-29",
    "active": true
  },
  {
    "id": 12,
    "name": "Nancy Lewis",
    "email": "nancylewis@example.net",
    "username": "nancy_lewis456",
    "phone": "(945) 555-0102",
    "city": "Portland",
    "country": "United States",
    "birth_date": "1960-08-15",
    "active": false
  },
  {
    "id": 13,
    "name": "Thomas Wilson",
    "email": "thomas12@example.com",
    "username": "thomasw502",
    "phone": "(584) 555-0196",
    "city": "San Diego",
    "country": "United States",
    "birth_date": "1991-09-18",
    "active": true
  },
  {
    "id": 14,
    "name": "Charles Miller",
    "email": "charles_miller@example.net",
    "username": "charles.m753",
    "phone": "(389) 555-0115",
    "city": "Los Angeles",
    "country": "United States",
    "birth_date": "1973-11-30",
    "active": true
  },
  {
    "id": 15,
    "name": "Daniel Thomas",
    "email": "daniel_thomas@example.org",
    "username": "daniel_t24",
    "phone": "(570) 555-0163",
    "city": "San Antonio",
    "country": "United States",
    "birth_date": "2000-09-15",
    "active": true
  },
  {
    "id": 16,
    "name": "Karen Hall",
    "email": "khall@example.net",
    "username": "karenhal384",
    "phone": "(800) 555-0106",
    "city": "Austin",
    "country": "United States",
    "birth_date": "2005-01-25",
    "active": false
  },
  {
    "id": 17,
    "name": "Anthony Harris",
    "email": "anthonyharris@example.net",
    "username": "anthonyharr974",
    "phone": "(444) 555-0145",
    "city": "Phoenix",
    "country": "United States",
    "birth_date": "2000-05-20",
    "active": false
  },
  {
    "id": 18,
    "name": "Elizabeth Young",
    "email": "elizabeth38@example.org",
    "username": "elizabeth_youn323",
    "phone": "(968) 555-0156",
    "city": "Miami",
    "country": "United States",
    "birth_date": "1954-02-23",
    "active": true
  },
  {
    "id": 19,
    "name": "Elizabeth Clark",
    "email": "elizabeth.clark@example.org",
    "username": "elizabeth.cla304",
    "phone": "(339) 555-0168",
    "city": "Los Angeles",
    "country": "United States",
    "birth_date": "1973-02-01",
    "active": false
  },
  {
    "id": 20,
    "name": "Jennifer Harris",
    "email": "jharris@example.com",
    "username": "jennifer.harri741",
    "phone": "(989) 555-0198",
    "city": "Austin",
    "country": "United States",
    "birth_date": "1988-08-20",
    "active": false
  },
  {
    "id": 21,
    "name": "Jessica Davis",
    "email": "jdavis@example.org",
    "username": "jessica.da131",
    "phone": "(880) 555-0151",
    "city": "San Diego",
    "country": "United States",
    "birth_date": "2000-12-27",
    "active": true
  },
  {
    "id": 22,
    "name": "Emily Moore",
    "email": "emoore@example.com",
    "username": "emilymoore1",
    "phone": "(754) 555-0121",
    "city": "Boston",
    "country": "United States",
    "birth_date": "1963-07-08",
    "active": false
  },
  {
    "id": 23,
    "name": "Emily Brown",
    "email": "emily_brown@example.org",
    "username": "emily.b791",
    "phone": "(821) 555-0137",
    "city": "New York",
    "country": "United States",
    "birth_date": "1947-07-26",
    "active": true
  },
  {
    "id": 24,
    "name": "Mark Clark",
    "email": "mark29@example.com",
    "username": "mark_cl816",
    "phone": "(749) 555-0115",
    "city": "Denver",
    "country": "United States",
    "birth_date": "1952-02-12",
    "active": false
  },
  {
    "id": 25,
    "name": "Charles White",
    "email": "cwhite@example.net",
    "username": "charleswhite889",
    "phone": "(396) 555-0118",
    "city": "Miami",
    "country": "United States",
    "birth_date": "1973-03-07",
    "active": true
  },
  {
    "id": 26,
    "name": "Anthony Brown",
    "email": "anthony25@example.com",
    "username": "anthony_brown950",
    "phone": "(404) 555-0100",
    "city": "Phoenix",
    "country": "United States",
    "birth_date": "1961-06-07",
    "active": true
  },
  {
    "id": 27,
    "name": "Noah Jones",
    "email": "noah_jones@example.com",
    "username": "noah.jon644",
    "phone": "(646) 555-0128",
    "city": "Atlanta",
    "country": "United States",
    "birth_date": "2000-02-08",
    "active": false
  },
  {
    "id": 28,

僅顯示前 300 行（共 1,102 行），複製和下載包含全部內容。

name

username

phone

city

country

birth_date

active

Olivia Hernandez

olivia.hernandez@example.com

oliviah23

(889) 555-0100

Austin

United States

1952-06-13

true

Susan Taylor

susantaylor@example.net

susantaylo837

(398) 555-0137

New York

United States

1994-12-11

false

Jennifer Wilson

jennifer84@example.net

jennifer.wilson880

(672) 555-0158

Seattle

United States

1997-12-23

true

Noah Lewis

noah.lewis@example.org

noah_lewis315

(369) 555-0128

New York

United States

1961-03-18

true

John White

jwhite@example.com

john_white542

(436) 555-0113

New York

United States

1995-12-15

false

Mary Thomas

mthomas@example.com

mary.thomas205

(709) 555-0110

Boston

United States

2001-02-24

true

Susan Perez

susan87@example.net

susanper610

(838) 555-0179

Portland

United States

1986-04-17

false

John Brown

john76@example.com

john_brown422

(970) 555-0173

Chicago

United States

1965-01-15

true

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300

如何使用測試資料產生器

產生逼真的測試假資料：姓名、電子郵件、地址、電話、UUID、IP 等，最多 10,000 列，可匯出 JSON、CSV、SQL 等 6 種格式。相同種子可重複產生同一份資料，絕不會產生真實證件號碼或銀行帳號。

從範本（使用者、聯絡人、裝置與網路）開始，或用「新增欄位」自行建立欄位清單。

為每個欄位選擇類型、修改欄位名稱，並設定選項，例如數字的最小值與最大值，或「從清單中選」的可選值。

在「資料」中設定列數、「姓名與地址」的語言和隨機種子。

選擇輸出格式；選 SQL 時再填寫資料表名稱。

確認預覽後按「全部複製」或「下載」。

常見問題

產生的是真人的資料嗎？

不是，全部隨機產生。電子郵件只用 example.com、example.org、example.net，IP 來自文件專用位址段，美國電話使用保留的 555-01xx 號段。

能產生身分證字號或信用卡號嗎？

不能。本工具不會產生銀行帳號、信用卡號、IBAN、稅號、社會安全號碼、護照號碼或其他證件號碼。

怎樣再次得到完全相同的資料？

使用相同的隨機種子、相同的欄位和列數即可。想要新資料時按骰子按鈕換一個種子。

SQL 格式長什麼樣子？

依你填寫的資料表名稱產生 INSERT INTO 陳述式，每段最多 500 列。不含建立資料表的語法，請先自行執行 CREATE TABLE。

姓名和地址支援哪些語言？

支援英語（美國）、中文、日語、韓語和德語。