api.mockaroo.comMockaroo - Random Data Generator and API Mocking Tool | JSON / CSV / SQL / Excel

mockaroo realistic data generator COMMUNITY FORUM TUTORIALS FAQ API REFERENCE ABOUT CONTACT SUPPORT PRICING SIGN IN Create a Custom Distribution Loading... Add rules using the Mockaroo formula syntax to create a custom distribution. Each rule must evaluate to true or false. For example, month == ’August’ or price10 . Each number in the table below represents how often that value will occur relative to other values. A value with "2" will occur twice as often as a value with "1". All values are assigned a "1" when no rules are matched. add a rule or add rules for all values of... Apply Close Formula Alter the value of this field using Mockaroo formula syntax . Use this to refer to the value of this field. Examples: this + 1 = add 1 to the value of this field upper(this) = change the value of this field to upper case if this == ’January’ then ’cold’ elsif this == ’July’ then ’hot’ else ’mild’ end = transform the value of this field based on custom logic Apply Close × Import Fields From CSV Paste the header row from your CSV, TXT, or Excel file to create multiple fields at once. Cancel Add fields Replace existing fields Need some mock data to test your app? Mockaroo lets you generate up to 1,000 rows of realistic test data in CSV, JSON, SQL, and Excel formats. Download data using your browser or sign in and create your own Mock APIs . Need more data? Plans start at just $50/year. Mockaroo is also available as a docker image that you can deploy in your own private cloud. Field Name Type Options start at: step: repeat: restart at: min: max: decimals: mean: success probability: λ: std. dev: decimals: to in m/d/yyyy mm/dd/yyyy yyyy-mm-dd d/m/yyyy dd/mm/yyyy d.m.yyyy dd.mm.yyyy dd-Mon-yyyy yyyy/mm/dd SQL datetime ISO 8601 (UTC) epoch mongoDB epoch mongoDB ISO unix timestamp from to format 12 Hour 12 Hour w/seconds 12 Hour w/millis 24 Hour 24 Hour w/seconds 24 Hour w/millis at least but no more than at least but no more than at least but no more than You must be signed in to use datasets. include: protocol host path query string style: 00-10-FA-6E-38-4A 00-10-fa-6e-38-4a 00:10:FA:6E:38:4A 00:10:fa:6e:38:4a between and in $ £ € ¥ random none min elements: max elements: help... help... random custom sequential cartesian generate only US locations You must be signed in to use scenarios. types: all common code document image media text format: FileName.xxx fileName.xxx file_name.xxx random size: × size: × to × format: random png bmp jpg format: ###-###-#### (###) ###-#### ### ### #### +# ### ### #### +# (###) ###-#### +#-###-###-#### #-(###)###-#### ########## blank: % × start at: step: repeat: restart at: min: max: decimals: mean: success probability: λ: std. dev: decimals: to in m/d/yyyy mm/dd/yyyy yyyy-mm-dd d/m/yyyy dd/mm/yyyy d.m.yyyy dd.mm.yyyy dd-Mon-yyyy yyyy/mm/dd SQL datetime ISO 8601 (UTC) epoch mongoDB epoch mongoDB ISO unix timestamp from to format 12 Hour 12 Hour w/seconds 12 Hour w/millis 24 Hour 24 Hour w/seconds 24 Hour w/millis at least but no more than at least but no more than at least but no more than You must be signed in to use datasets. include: protocol host path query string style: 00-10-FA-6E-38-4A 00-10-fa-6e-38-4a 00:10:FA:6E:38:4A 00:10:fa:6e:38:4a between and in $ £ € ¥ random none min elements: max elements: help... help... random custom sequential cartesian generate only US locations You must be signed in to use scenarios. types: all common code document image media text format: FileName.xxx fileName.xxx file_name.xxx random size: × size: × to × format: random png bmp jpg format: ###-###-#### (###) ###-#### ### ### #### +# ### ### #### +# (###) ###-#### +#-###-###-#### #-(###)###-#### ########## blank: % × start at: step: repeat: restart at: min: max: decimals: mean: success probability: λ: std. dev: decimals: to in m/d/yyyy mm/dd/yyyy yyyy-mm-dd d/m/yyyy dd/mm/yyyy d.m.yyyy dd.mm.yyyy dd-Mon-yyyy yyyy/mm/dd SQL datetime ISO 8601 (UTC) epoch mongoDB epoch mongoDB ISO unix timestamp from to format 12 Hour 12 Hour w/seconds 12 Hour w/millis 24 Hour 24 Hour w/seconds 24 Hour w/millis at least but no more than at least but no more than at least but no more than You must be signed in to use datasets. include: protocol host path query string style: 00-10-FA-6E-38-4A 00-10-fa-6e-38-4a 00:10:FA:6E:38:4A 00:10:fa:6e:38:4a between and in $ £ € ¥ random none min elements: max elements: help... help... random custom sequential cartesian generate only US locations You must be signed in to use scenarios. types: all common code document image media text format: FileName.xxx fileName.xxx file_name.xxx random size: × size: × to × format: random png bmp jpg format: ###-###-#### (###) ###-#### ### ### #### +# ### ### #### +# (###) ###-#### +#-###-###-#### #-(###)###-#### ########## blank: % × start at: step: repeat: restart at: min: max: decimals: mean: success probability: λ: std. dev: decimals: to in m/d/yyyy mm/dd/yyyy yyyy-mm-dd d/m/yyyy dd/mm/yyyy d.m.yyyy dd.mm.yyyy dd-Mon-yyyy yyyy/mm/dd SQL datetime ISO 8601 (UTC) epoch mongoDB epoch mongoDB ISO unix timestamp from to format 12 Hour 12 Hour w/seconds 12 Hour w/millis 24 Hour 24 Hour w/seconds 24 Hour w/millis at least but no more than at least but no more than at least but no more than You must be signed in to use datasets. include: protocol host path query string style: 00-10-FA-6E-38-4A 00-10-fa-6e-38-4a 00:10:FA:6E:38:4A 00:10:fa:6e:38:4a between and in $ £ € ¥ random none min elements: max elements: help... help... random custom sequential cartesian generate only US locations You must be signed in to use scenarios. types: all common code document image media text format: FileName.xxx fileName.xxx file_name.xxx random size: × size: × to × format: random png bmp jpg format: ###-###-#### (###) ###-#### ### ### #### +# ### ### #### +# (###) ###-#### +#-###-###-#### #-(###)###-#### ########## blank: % × start at: step: repeat: restart at: min: max: decimals: mean: success probability: λ: std. dev: decimals: to in m/d/yyyy mm/dd/yyyy yyyy-mm-dd d/m/yyyy dd/mm/yyyy d.m.yyyy dd.mm.yyyy dd-Mon-yyyy yyyy/mm/dd SQL datetime ISO 8601 (UTC) epoch mongoDB epoch mongoDB ISO unix timestamp from to format 12 Hour 12 Hour w/seconds 12 Hour w/millis 24 Hour 24 Hour w/seconds 24 Hour w/millis at least but no more than at least but no more than at least but no more than You must be signed in to use datasets. include: protocol host path query string style: 00-10-FA-6E-38-4A 00-10-fa-6e-38-4a 00:10:FA:6E:38:4A 00:10:fa:6e:38:4a between and in $ £ € ¥ random none min elements: max elements: help... help... random custom sequential cartesian generate only US locations You must be signed in to use scenarios. types: all common code document image media text format: FileName.xxx fileName.xxx file_name.xxx random size: × size: × to × format: random png bmp jpg format: ###-###-#### (###) ###-#### ### ### #### +# ### ### #### +# (###) ###-#### +#-###-###-#### #-(###)###-#### ########## blank: % × start at: step: repeat: restart at: min: max: decimals: mean: success probability: λ: std. dev: decimals: to in m/d/yyyy mm/dd/yyyy yyyy-mm-dd d/m/yyyy dd/mm/yyyy d.m.yyyy dd.mm.yyyy dd-Mon-yyyy yyyy/mm/dd SQL datetime ISO 8601 (UTC) epoch mongoDB epoch mongoDB ISO unix timestamp from to format 12 Hour 12 Hour w/seconds 12 Hour w/millis 24 Hour 24 Hour w/seconds 24 Hour w/millis at least but no more than at least but no more than at least but no more than You must be signed in to use datasets. include: protocol host path query string style: 00-10-FA-6E-38-4A 00-10-fa-6e-38-4a 00:10:FA:6E:38:4A 00:10:fa:6e:38:4a between and in $ £ € ¥ random none min elements: max elements: help... help... random custom sequential cartesian generate only US locations You must be signed in to use scenarios. types: all common code document image media text format: FileName.xxx fileName.xxx file_name.xxx random size: × size: × to × format: random png bmp jpg format: ###-###-#### (###) ###-#### ### ### #### +# ### ### #### +#...