模拟数据生成器
生成逼真的假用户、商品和订单，支持自定义列，可导出 JSON、CSV 或 SQL。 所有处理都在本地完成，不会上传任何内容。
- 输入
- Template · your own columns
- 输出
- JSON · CSV · SQL · YAML · TypeScript
列
14/60
{ }
预览
JSON · 前 50 行，共 100 行
[
{
"id": 1,
"name": "杨欣怡",
"email": "xinyiyang@126.com",
"username": "xinyi_yang",
"phone": "+86 138 8731 5660",
"gender": "female",
"age": 39,
"address": {
"street": "光明路210号",
"city": "上海",
"region": "上海市",
"postcode": "200502"
},
"is_active": false,
"created_at": "2024-08-04T05:56:52Z"
},
{
"id": 2,
"name": "韩华",
"email": "huahan@qq.com",
"username": "hua52",
"phone": "+86 158 2623 7852",
"gender": "male",
"age": 26,
"address": {
"street": "胜利路74号",
"city": "上海",
"region": "上海市",
"postcode": "200666"
},
"is_active": false,
"created_at": "2024-04-17T12:38:26Z"
},
{
"id": 3,
"name": "徐芳",
"email": "fang48@sina.com",
"username": "fang78",
"phone": "+86 186 2715 8195",
"gender": "female",
"age": 24,
"address": {
"street": "友谊路109号",
"city": "成都",
"region": "四川省",
"postcode": "610353"
},
"is_active": true,
"created_at": "2025-07-13T01:34:48Z"
},
{
"id": 4,
"name": "何婷",
"email": "ting.he@126.com",
"username": "the",
"phone": "+86 186 0481 9176",
"gender": "female",
"age": 65,
"address": {
"street": "和平路104号",
"city": "重庆",
"region": "重庆市",
"postcode": "400632"
},
"is_active": true,
"created_at": "2025-05-18T12:00:28Z"
},
{
"id": 5,
"name": "王平",
"email": "ping74@sina.com",
"username": "pingwang",
"phone": "+86 158 4107 7223",
"gender": "male",
"age": 24,
"address": {
"street": "中山路56号",
"city": "厦门",
"region": "福建省",
"postcode": "361591"
},
"is_active": true,
"created_at": "2024-03-08T13:02:24Z"
},
{
"id": 6,
"name": "徐平",
"email": "pingxu@163.com",
"username": "ping611",
"phone": "+86 158 2323 6216",
"gender": "male",
"age": 38,
"address": {
"street": "长安街32号",
"city": "东莞",
"region": "广东省",
"postcode": "523052"
},
"is_active": false,
"created_at": "2025-09-27T05:45:56Z"
},
{
"id": 7,
"name": "林雅琪",
"email": "y.lin@163.com",
"username": "yaqi147",
"phone": "+86 186 2359 4887",
"gender": "female",
"age": 39,
"address": {
"street": "人民路18号",
"city": "重庆",
"region": "重庆市",
"postcode": "400567"
},
"is_active": false,
"created_at": "2025-07-06T07:49:05Z"
},
{
"id": 8,
"name": "冯琳",
"email": "linfeng@sina.com",
"username": "lin_feng",
"phone": "+86 186 1300 6798",
"gender": "female",
"age": 46,
"address": {
"street": "光明路177号",
"city": "天津",
"region": "天津市",
"postcode": "300210"
},
"is_active": false,
"created_at": "2025-02-24T03:25:26Z"
},
{
"id": 9,
"name": "林秀英",
"email": "xiuyinglin@163.com",
"username": "xiuying_lin",
"phone": "+86 139 1525 5641",
"gender": "female",
"age": 55,
"address": {
"street": "中山路38号",
"city": "沈阳",
"region": "辽宁省",
"postcode": "110084"
},
"is_active": false,
"created_at": "2023-03-04T04:21:20Z"
},
{
"id": 10,
"name": "张鑫",
"email": "x.zhang@126.com",
"username": "xin796",
"phone": "+86 186 5100 0266",
"gender": "male",
"age": 29,
"address": {
"street": "朝阳路245号",
"city": "北京",
"region": "北京市",
"postcode": "100332"
},
"is_active": true,
"created_at": "2025-10-31T22:47:59Z"
},
{
"id": 11,
"name": "董佳怡",
"email": "jiayi68@sina.com",
"username": "jiayi_dong",
"phone": "+86 186 5655 9973",
"gender": "female",
"age": 30,
"address": {
"street": "东风路167号",
"city": "青岛",
"region": "山东省",
"postcode": "266383"
},
"is_active": true,
"created_at": "2024-08-07T00:21:56Z"
},
{
"id": 12,
"name": "陈欣怡",
"email": "x.chen@163.com",
"username": "xinyi275",
"phone": "+86 186 7718 9540",
"gender": "female",
"age": 47,
"address": {
"street": "光明路224号",
"city": "西安",
"region": "陕西省",
"postcode": "710446"
},
"is_active": true,
"created_at": "2023-07-03T16:20:34Z"
},
{
"id": 13,
"name": "唐浩然",
"email": "haoran.tang@qq.com",
"username": "haoran270",
"phone": "+86 139 8698 3062",
"gender": "male",
"age": 23,
"address": {
"street": "光明路70号",
"city": "深圳",
"region": "广东省",
"postcode": "518754"
},
"is_active": false,
"created_at": "2025-01-25T05:51:06Z"
},
{
"id": 14,
"name": "徐芳",
"email": "fang.xu@sina.com",
"username": "fxu",
"phone": "+86 139 6077 3275",
"gender": "female",
"age": 23,
"address": {
"street": "建国路21号",
"city": "长沙",
"region": "湖南省",
"postcode": "410487"
},
"is_active": true,
"created_at": "2023-06-09T11:11:08Z"
},
{
"id": 15,
"name": "黄诗涵",
"email": "shihan14@126.com",
"username": "shihanhuang",
"phone": "+86 186 5709 5203",
"gender": "female",
"age": 50,
"address": {
"street": "南京路191号",
"city": "深圳",
"region": "广东省",
"postcode": "518841"
},
"is_active": true,
"created_at": "2025-07-23T08:08:26Z"
},
{
"id": 16,
"name": "高杰",
"email": "jie51@163.com",
"username": "jiegao",
"phone": "+86 186 8325 7442",
"gender": "male",
"age": 24,
"address": {
"street": "光明路9号",
"city": "青岛",
"region": "山东省",
"postcode": "266342"
},
"is_active": false,
"created_at": "2023-03-12T23:33:07Z"
},
{
"id": 17,
"name": "李子萱",
"email": "zixuan59@163.com",
"username": "zixuan_li",
"phone": "+86 139 5070 6137",
"gender": "female",
"age": 54,
"address": {
"street": "友谊路70号",
"city": "武汉",
"region": "湖北省",
"postcode": "430940"
},
"is_active": true,
"created_at": "2024-05-28T07:20:16Z"
},
{
"id": 18,
"name": "董莉",
"email": "lidong@qq.com",
"username": "lidong",
"phone": "+86 158 4656 8699",
"gender": "female",
"age": 23,
"address": {
"street": "团结路203号",
"city": "厦门",
"region": "福建省",
"postcode": "361810"
},
"is_active": true,
"created_at": "2025-08-16T05:15:48Z"
},
{
"id": 19,
"name": "朱佳怡",
"email": "jiayi92@163.com",
"username": "jiayi_zhu",
"phone": "+86 158 0126 3694",
"gender": "female",
"age": 55,
"address": {
"street": "北京路185号",
"city": "北京",
"region": "北京市",
"postcode": "100682"
},
"is_active": true,
"created_at": "2024-02-22T22:39:35Z"
},
{
"id": 20,
"name": "林琳",
"email": "lin.lin@126.com",
"username": "lin75",
"phone": "+86 186 4583 5191",
"gender": "female",
"age": 48,
"address": {
"street": "复兴路178号",
"city": "成都",
"region": "四川省",
"postcode": "610568"
},
"is_active": true,
"created_at": "2023-04-15T17:43:58Z"
},
{
"id": 21,
"name": "李洁",
"email": "jie74@qq.com",
"username": "jli",
"phone": "+86 139 1760 6585",
"gender": "female",
"age": 18,
"address": {
"street": "新华路148号",
"city": "宁波",
"region": "浙江省",
"postcode": "315511"
},
"is_active": true,
"created_at": "2025-10-08T22:30:20Z"
},
{
"id": 22,
"name": "罗红",
"email": "h.luo@126.com",
"username": "hluo",
"phone": "+86 158 9213 9590",
"gender": "female",
"age": 38,
"address": {
"street": "复兴路151号",
"city": "厦门",
"region": "福建省",
"postcode": "361292"
},
"is_active": false,
"created_at": "2024-03-03T06:18:18Z"
},
{
"id": 23,
"name": "吴斌",
"email": "binwu@163.com",
"username": "bin177",
"phone": "+86 186 6585 8464",
"gender": "male",
"age": 31,
"address": {
"street": "朝阳路166号",
"city": "武汉",
"region": "湖北省",
"postcode": "430410"
},
"is_active": true,
"created_at": "2023-01-21T18:33:17Z"
},
{
"id": 24,
"name": "朱强",
"email": "qiang.zhu@126.com",
"username": "qiang_zhu",
"phone": "+86 158 3364 8013",
"gender": "male",
"age": 49,
"address": {
"street": "科技路215号",
"city": "厦门",
"region": "福建省",
"postcode": "361416"
},
"is_active": false,
"created_at": "2024-03-20T04:04:33Z"
},
{
"id": 25,
"name": "杨波",
"email": "b.yang@qq.com",
"username": "bo534",
"phone": "+86 158 9565 9802",
"gender": "male",
"age": 25,
"address": {
"street": "友谊路97号",
"city": "郑州",
"region": "河南省",
"postcode": "450543"
},
"is_active": false,
"created_at": "2025-08-13T06:08:52Z"
},
{
"id": 26,
"name": "林颖",
"email": "ying73@163.com",
"username": "yinglin",
"phone": "+86 139 0101 3754",
"gender": "female",
"age": 29,
"address": {
"street": "文化路250号",
"city": "郑州",
"region": "河南省",
"postcode": "450437"
},
"is_active": true,
"created_at": "2023-05-04T14:39:14Z"
},
{
"id": 27,
"name": "李美玲",
"email": "meiling75@qq.com",
"username": "mli",
"phone": "+86 138 8294 4030",
"gender": "female",
"age": 36,
"address": {
"street": "文化路121号",
"city": "宁波",
"region": "浙江省",
"postcode": "315097"
},
"is_active": true,
"created_at": "2025-01-25T07:34:58Z"
},
{
"id": 28,
"name": "黄雅琪",
"email": "yaqi70@sina.com",
"username": "yaqihuang",
"phone": "+86 186 9921 0966",
"gender": "female",
"age": 64,
"address": {
"street": "人民路159号",
"city": "西安",
"region": "陕西省",
"postcode": "710708"
},
"is_active": true,
"created_at": "2023-03-27T05:46:20Z"
},
{
"id": 29,
"name": "赵鑫",
"email": "x.zhao@qq.com",
"username": "xin_zhao",
"phone": "+86 186 9713 2065",
"gender": "male",
"age": 61,
"address": {
"street": "东风路165号",
"city": "成都",
"region": "四川省",
"postcode": "610086"
},
"is_active": false,
"created_at": "2023-09-03T21:46:45Z"
},
{
"id": 30,
"name": "赵勇",
"email": "yong61@126.com",
"username": "yong_zhao",
"phone": "+86 139 4706 6688",
"gender": "male",
"age": 22,
"address": {
"street": "光明路195号",
"city": "天津",
"region": "天津市",
"postcode": "300464"
},
"is_active": false,
"created_at": "2024-04-19T01:54:40Z"
},
{
"id": 31,
"name": "唐颖",
"email": "yingtang@sina.com",
"username": "ying344",
"phone": "+86 139 9097 4223",
"gender": "female",
"age": 61,
"address": {
"street": "胜利路52号",
"city": "北京",
"region": "北京市",
"postcode": "100712"
},
"is_active": true,
"created_at": "2025-03-14T17:36:25Z"
},
{
"id": 32,
"name": "郭秀英",
"email": "x.guo@sina.com",
"username": "xiuying739",
"phone": "+86 139 3592 4426",
"gender": "female",
"age": 39,
"address": {
"street": "文化路48号",
"city": "武汉",
"region": "湖北省",
"postcode": "430759"
},
"is_active": false,
"created_at": "2024-07-11T05:04:44Z"
},
{
"id": 33,
"name": "马强",
"email": "qiang.ma@126.com",
"username": "qiangma",
"phone": "+86 138 3947 8828",
"gender": "male",
"age": 59,
"address": {
"street": "文化路64号",
"city": "上海",
"region": "上海市",
"postcode": "200778"
},
"is_active": false,
"created_at": "2024-11-27T15:34:47Z"
},
{
"id": 34,
"name": "马斌",
"email": "b.ma@163.com",
"username": "bma",
"phone": "+86 138 8782 1835",
"gender": "male",
"age": 60,
"address": {
"street": "科技路103号",
"city": "杭州",
"region": "浙江省",
"postcode": "310502"
},
"is_active": false,
"created_at": "2024-08-05T09:14:05Z"
},
{
"id": 35,
"name": "周超",
"email": "chao99@qq.com",
"username": "chaozhou",
"phone": "+86 138 8963 7154",
"gender": "male",
"age": 22,
"address": {
"street": "朝阳路89号",
"city": "南京",
"region": "江苏省",
"postcode": "210446"
},
"is_active": false,
"created_at": "2024-11-08T09:16:39Z"
},
{
"id": 36,
"name": "张建国",
"email": "j.zhang@163.com",
"username": "jianguo_zhang",
"phone": "+86 138 7426 5589",
"gender": "male",
"age": 33,
"address": {
"street": "解放路1号",
"city": "济南",
"region": "山东省",
"postcode": "250750"
},
"is_active": false,
"created_at": "2024-05-22T01:48:30Z"
},
{
"id": 37,
"name": "郑凯",
"email": "kaizheng@sina.com",
"username": "kai911",
"phone": "+86 186 3105 6299",
"gender": "male",
"age": 31,
"address": {
"street": "南京路245号",
"city": "广州",
"region": "广东省",
"postcode": "510703"
},
"is_active": false,
"created_at": "2025-04-13T17:13:14Z"
},
{
"id": 38,
"name": "唐子萱",
"email": "z.tang@163.com",
"username": "zixuantang",
"phone": "+86 139 2726 2720",
"gender": "female",
"age": 56,
"address": {
"street": "建国路48号",
"city": "沈阳",
"region": "辽宁省",
"postcode": "110933"
},
"is_active": true,
"created_at": "2023-12-30T20:30:35Z"
},
{
"id": 39,
"name": "韩凯",
"email": "kai83@126.com",
"username": "kai_han",
"phone": "+86 139 2915 8399",
"gender": "male",
"age": 45,
"address": {
"street": "南京路46号",
"city": "重庆",
"region": "重庆市",
"postcode": "400584"
},
"is_active": true,
"created_at": "2024-11-06T07:01:17Z"
},
{
"id": 40,
"name": "赵建国",
"email": "jianguo.zhao@qq.com",
"username": "jzhao",
"phone": "+86 186 3435 2264",
"gender": "male",
"age": 24,
"address": {
"street": "光明路244号",
"city": "苏州",
"region": "江苏省",
"postcode": "215085"
},
"is_active": true,
"created_at": "2024-08-25T14:01:15Z"
},
{
"id": 41,
"name": "高娟",
"email": "juangao@126.com",
"username": "juangao",
"phone": "+86 139 7102 2498",
"gender": "female",
"age": 33,
"address": {
"street": "东风路105号",
"city": "武汉",
"region": "湖北省",
"postcode": "430291"
},
"is_active": false,
"created_at": "2024-11-02T18:42:47Z"
},
{
"id": 42,
"name": "高涛",
"email": "taogao@163.com",
"username": "tao_gao",
"phone": "+86 139 2332 7048",
"gender": "male",
"age": 49,
"address": {
"street": "复兴路115号",
"city": "上海",
"region": "上海市",
"postcode": "200511"
},
"is_active": false,
"created_at": "2024-03-21T12:56:55Z"
},
{
"id": 43,
"name": "马子萱",
"email": "zixuan.ma@126.com",
"username": "zma",
"phone": "+86 186 8611 1974",
"gender": "female",
"age": 45,
"address": {
"street": "青年路73号",
"city": "武汉",
"region": "湖北省",
"postcode": "430834"
},
"is_active": false,
"created_at": "2023-01-14T15:43:22Z"
},
{
"id": 44,
"name": "李静",
"email": "jingli@sina.com",
"username": "jing856",
"phone": "+86 138 9363 4778",
"gender": "female",
"age": 62,
"address": {
"street": "长安街46号",
"city": "天津",
"region": "天津市",
"postcode": "300427"
},
"is_active": false,
"created_at": "2024-11-25T08:44:01Z"
},
{
"id": 45,
"name": "王娜",
"email": "na.wang@qq.com",
"username": "na_wang",
"phone": "+86 139 4079 4430",
"gender": "female",
"age": 31,
"address": {
"street": "团结路144号",
"city": "上海",
"region": "上海市",
"postcode": "200100"
},
"is_active": false,
"created_at": "2024-02-24T19:42:55Z"
},
{
"id": 46,
"name": "陈军",
"email": "j.chen@163.com",
"username": "junchen",
"phone": "+86 186 5944 4176",
"gender": "male",
"age": 37,
"address": {
"street": "解放路229号",
"city": "沈阳",
"region": "辽宁省",
"postcode": "110642"
},
"is_active": true,
"created_at": "2024-12-28T12:27:42Z"
},
{
"id": 47,
"name": "于艳",
"email": "yanyu@163.com",
"username": "yan363",
"phone": "+86 186 7401 0850",
"gender": "female",
"age": 36,
"address": {
"street": "北京路187号",
"city": "郑州",
"region": "河南省",
"postcode": "450467"
},
"is_active": false,
"created_at": "2024-04-16T20:36:04Z"
},
{
"id": 48,
"name": "杨慧",
"email": "hui.yang@sina.com",
"username": "hui956",
"phone": "+86 186 2175 0151",
"gender": "female",
"age": 64,
"address": {
"street": "团结路241号",
"city": "苏州",
"region": "江苏省",
"postcode": "215344"
},
"is_active": true,
"created_at": "2023-04-28T00:29:06Z"
},
{
"id": 49,
"name": "杨敏",
"email": "minyang@126.com",
"username": "myang",
"phone": "+86 139 7540 2197",
"gender": "female",
"age": 24,
"address": {
"street": "北京路127号",
"city": "深圳",
"region": "广东省",
"postcode": "518357"
},
"is_active": false,
"created_at": "2023-02-21T00:05:08Z"
},
{
"id": 50,
"name": "王杰",
"email": "j.wang@sina.com",
"username": "jie_wang",
"phone": "+86 139 2290 3111",
"gender": "male",
"age": 59,
"address": {
"street": "和平路242号",
"city": "深圳",
"region": "广东省",
"postcode": "518372"
},
"is_active": false,
"created_at": "2023-05-25T08:09:15Z"
}
]与你的数据结构一致的测试数据
每个项目在有用户之前都需要数据：在演示中填满一张表、为开发数据库灌入种子数据，或者看看布局如何应对很长的姓名。从模板或空列表开始，添加你的表结构中的列，生成器就会按你的代码能读取的格式填充所需数量的行。
合乎逻辑的行
- 每行对应一个人。姓名、邮箱、用户名、性别、年龄和出生日期描述的是同一个人，所以
siti.rahma@…会与 Siti Rahma 放在一起，绝不会和 John 配对。 - 每行对应一个地点。城市、地区和邮编相互匹配，所以 Bandung 会搭配 Jawa Barat 和 40xxx 的邮编。
- 对象与列表。可以把多列归入一个对象，如
address；也可以创建由记录组成的数组，如订单的items，或由单个值组成的数组，如tags。数组的每一项都是独立的一条记录。 - 可重复。相同的列和相同的种子会生成相同的行，因此测试夹具可以被精确重新生成。点击“重新生成”即可获得一组新数据。
- 有意留空。可以为任意列设置一定比例的空行，用来测试你的代码如何处理
null。
输出格式
- JSON：对象数组，适用于 API、测试夹具和模拟服务器。
- CSV：一行表头加每条记录一行，可直接用于电子表格或批量导入。对象会变成带点号的列，如
address.city；数组以 JSON 形式写入单元格。 - SQL：针对你指定的表的一条
INSERT语句，字符串已转义，空值写作NULL，对象和数组则作为 JSON 文本写入 JSON 列。 - YAML：映射列表，适用于种子文件和配置。
- TypeScript：导出的数组，可直接导入测试或 stories 中。
- Rust、Kotlin、Java、C# 、C 和 C++：根据你的列生成类型声明——每个对象对应一个 struct、record 或 data class，含空行的列则使用可选字段——随后是数据本身。PHP 和 Ruby：普通的数组和哈希，可直接
require。
常见问题
- 如何生成假的用户数据？
- 选择“用户”模板，设置行数和输出格式，数据会立即生成。你可以添加、删除或重命名列以匹配自己的表结构，然后复制或下载结果。
- 可以自定义列吗？
- 可以。选择“空白”模板即可从没有列开始，也可以编辑其他任何模板。添加一列，填入你的表结构中使用的名称，并选择类型：人物、地址、公司和商品、互联网数据、数字和日期、你自己的取值列表，或类似 INV-##### 的模式。选择“对象”或“数组”，即可在其中嵌套列。
- 可以生成包含对象和数组的嵌套 JSON 吗？
- 可以。把某一列的类型设为“对象”，即可给它添加自己的列；设为“数组”，则是包含 0 到 20 项的列表，每一项可以是对象或单个值。最多可嵌套三层。“订单”模板同时展示了这两种：一个客户对象和一个商品列表。
- 最多能生成多少行？
- 一次最多 10,000 行。预览只显示前几行；复制或下载时始终包含全部行。
- 生成的数据是真实的吗？
- 不是。姓名、城市和公司是从常见词汇中随机挑选的，邮箱、电话号码和 ID 都是编造的。如有与真人雷同，纯属巧合，这也正是它适合用于测试的原因。
- 数据可以使用哪些语言？
- 本站支持的 13 种语言都可以。姓名、城市、地区、邮政编码、电话号码、街道地址、公司和商品都遵循该国的惯例；对于日语、俄语或阿拉伯语等文字，邮箱和用户名使用罗马字母转写后的姓名，因此仍是有效的地址。
- 可以获得适用于我所用编程语言的代码形式的数据吗？
- 可以。除了 JSON、CSV、SQL 和 YAML，还可以输出为 TypeScript、Rust、Kotlin、Java、C#、C、C++、PHP 或 Ruby。对于有类型的语言，类型会根据你的列生成，嵌套对象会成为各自独立的 struct 或类，结果无需修改即可编译。
其他工具
Data Studio在 JSON、YAML、TOML、CSV 和 Markdown 之间转换结构化文本。JWT 密钥生成器随机的 HS256、HS384 和 HS512 密钥，支持 hex 或 Base64，可直接用于 .env。JWT 解码器查看令牌的头部和声明，检查是否过期，并验证签名。密码生成器强随机密码，并以位显示强度。图像转换器重新编码、缩放和矢量化图片，实时对比转换前后效果。压缩与归档用 gzip 或 Brotli 压缩任何文件，或把整个文件夹打包成 ZIP。DOCX 转 PDF把 Word 文档转换成文字可选中的真正 PDF。PDF 转 DOCX从 PDF 的文本层还原出可编辑的 Word 文档。消除背景自动 AI 检测、智能选区与精准手动工具。PDF编辑器直接在浏览器中签署文档、编辑文本、插入图片并涂白遮盖PDF。大小写转换把文本转换为 kebab-case、camelCase、snake_case、Title Case 等十多种格式。Lorem Ipsum 生成器按段落、句子或单词生成占位文本，支持纯文本或 HTML。图片转 ASCII把照片变成 ASCII 字符画，黑白或全彩均可。