Build Lists for Spreadsheets and Code With a Text Repeater

The real power of a text repeater is in its separator, prefix and suffix options. Combine them and you can generate structured lists for spreadsheets and code in a few clicks. Here are copy-ready recipes for the text repeater.

How the pieces fit

Each repeat is built as:

[number. ] + prefix + text + suffix

and repeats are joined by the separator. Use \n for a new line and \t for a tab inside custom fields.

Spreadsheets

One value per row

Text: Yes · Separator: New line · Count: 100

Paste into a cell. Each line fills its own row.

One value per column

Text: Yes · Separator: Tab · Count: 12

Paste into a cell. Tabs split values across columns, which is perfect for a row of month headers you’ll edit afterwards.

A CSV row

Text: 0 · Separator: Comma · Count: 12 → 0,0,0,0,0,0,0,0,0,0,0,0

SQL

VALUES rows

Text: (DEFAULT, 'sample', 0) · Separator: Comma + space · Count: 50

INSERT INTO items (id, name, qty) VALUES
(DEFAULT, 'sample', 0), (DEFAULT, 'sample', 0), …;

Placeholders for a parameterised IN clause

Text: ? · Separator: Comma + space · Count: 10 → ?, ?, ?, ?, ?, ?, ?, ?, ?, ?

JSON

Array of strings

Text: item · Prefix: " · Suffix: " · Separator: Comma + space · Count: 5

Result: "item", "item", "item", "item", "item". Wrap it in square brackets and you have a valid array. Check it with the JSON formatter.

Array of objects

Text: {"name": "test", "active": true} · Separator: custom ,\n · Count: 20

Wrap in [ ], paste into the JSON formatter and press Format to pretty-print it.

HTML and front-end

List items

Text: Item · Prefix: <li> · Suffix: </li> · Separator: New line · Count: 8

Grid cards for a prototype

Text: <div class="card">Card</div> · Separator: New line · Count: 12

Markdown

Table rows

Text: | | | | · Separator: New line · Count: 10

Add a header row and separator line above it, and you have an empty Markdown table to fill in.

Task lists

Text: Task · Prefix: - [ ] · Separator: New line · Numbering off

Quoted lists for code

Turn a value into a quoted, comma-separated list:

Text: value · Prefix: ' · Suffix: ' · Separator: Comma + space

'value', 'value', 'value'

Tips

After generating, use your editor’s multi-cursor or find-and-replace to vary values.
Keep generated SQL and JSON in version control alongside the settings used, so tests are reproducible.
Validate JSON output with the JSON formatter before using it.

For QA-style recipes, see How to Generate Test Data Quickly With Repeated Text. For more everyday uses, see 10 Practical Uses for a Text Repeater.