Import-prep quoting for CSV, SQL, and JSON
Three quote characters are offered: `"` (double - CSV, JSON), `'` (single - SQL string literals, Python), and `` ` `` (backtick - Markdown inline code, JavaScript template literals). The chosen character wraps each line; no escaping is applied.
This tool pairs with Join: quote every line, then join with `, ` to get `"apple", "banana", "cherry"`. That output is valid SQL `IN (...)` fodder, a JSON array body, or a CSV row fragment.
If your items contain quote characters that need escaping (e.g. `O'Brien` with single-quote output), pre-process with Replace - doubling `'` to `''` for SQL, or backslash-escaping for JSON. This tool does not serialize, only wraps.
How to use add quotes around list items
- 1Paste your list into the input panel
- 2Pick Quote: Double (CSV/JSON), Single (SQL), or Backtick (Markdown/JS)
- 3Every line is wrapped in the chosen character - no escaping
- 4For a comma-separated one-liner, chain Join with separator `, `
- 5To strip quotes later, use Unquote
Keyboard shortcuts
Drive ListShift without touching the mouse.
Built for import-prep
The same wrap-each-line op as Quote list items, framed around data-import targets.
CSV column or row fragments
Double-quote every line, then Join with `,` to form a CSV row. Or leave as-is for a quoted column of values.
SQL `IN (...)` clauses
Single-quote every string value, join with `, `, wrap in `(` / `)` via Wrap. Warning: no escaping - pre-process apostrophes first with Replace.
JSON string arrays
Double-quote, join with `, `, wrap in `[` / `]`. For JSON-safe content (backslash-escaped quotes, control chars), serialize via convert-list-to-json instead.
Markdown inline code spans
Backtick-wrap for `` `term` `` one-per-line glossaries.
No escaping, no deduplication
The op is `line → quote + line + quote` applied to every line. Existing quotes are not escaped; duplicates are not merged; blanks become a pair of quotes.
Worked example
Double-quote every line - ready to Join with `, ` for SQL/JSON use.
apple banana cherry
"apple" "banana" "cherry"
Settings reference
How each Quote choice shapes the output using the sample above.
| Setting | What it does | Effect on the sample |
|---|---|---|
| Quote: Double (default) | Wraps each line in `"…"` - CSV / JSON target | `"apple"` / `"banana"` / `"cherry"` |
| Quote: Single | Wraps each line in `'…'` - SQL target | `'apple'` / `'banana'` / `'cherry'` |
| Quote: Backtick | Wraps each line in `` `…` `` - Markdown / JS target | `` `apple` `` / `` `banana` `` / `` `cherry` `` |
| Blank-line behaviour (automatic) | Blank lines become a pair of quotes | `""` (or `''`, or `` `` ``) |