mielony.com
— software and AI by day, CAD and games by night
blog
~
tools
columns
—
add column
dataset
table
users — people: name, contact, role, plan, activity
clients — companies: contact, address, tax ids, status
payments — invoices per client: amount, method, status
orders — line items per client: totals consistent with quantity x unit price
rows
100
1,000
10,000
100,000
500,000
1,000,000
custom…
count
format
CSV — comma-separated
TSV — tab-separated
JSON — array of objects
JSON Lines — one object per line
SQL — CREATE TABLE + INSERTs
Markdown — table
fixed-width — padded columns
delimiter
,
;
tab
|
table name
seed
header row
quote every field
CRLF
UTF-8 BOM
include CREATE TABLE
keep child rows linked to real parent rows
linked rows
preview
table
text
—
loading…
preview
generate
copy
download
idle
first name
last name
full name
username
email
phone
UUID v4
job title
department
avatar URL
company name
domain
industry
VAT id
IBAN
SWIFT/BIC
street address
city
postal code
country
country code
latitude
longitude
SKU
product
category
quantity
unit price
total (quantity x unit_price)
currency
discount %
invoice number
payment method
payment status
order status
transaction id
date (past 3y)
datetime ISO (past 3y)
date (past 90d)
datetime ISO (past 90d)
unix timestamp
time of day
IPv4
URL
slug
user agent
HTTP status
boolean
integer
decimal
percent
enum (fixed list)
sentence
colour hex
tag
plan
client status
user id (own)
client id (own)
payment id (own)
order id (own)
client id (linked)
user id (linked)