Learn
History for this tool
The most recent data you entered in this tool, stored only in this browser.
Save what you type here, in this browser? Your work would go into this browser's local storage, so a refresh or a trip to another tool does not wipe it. You also get a short list of previous entries under the form, each one restorable with a click. Nothing is ever uploaded, and there is no account.
Being straight about the trade-off: anything kept there can be read by anyone who can use this browser profile, and by any script that later runs on this site. A tool page can hold a private key, a password or a signed token. Saving is convenient; it is not private.
Saved on this device
Your inputs and history are stored locally.
Not saved
This page forgets your work when you leave it.
About this tool
Turn a list into the shape you need: one item per line, comma-separated, a JSON array, a SQL IN clause or a numbered list. Useful for turning a column pasted out of a spreadsheet into something a query or a script will accept.Questions
- Does it deduplicate or sort?
- No. This tool has no sort or deduplicate control. It keeps the order and duplicates from the input (after optional trimming and empty-line removal). Use another tool if you need to clean the list first.
- Why is my SQL IN clause broken?
- Almost always because an item contained a single quote. The tool escapes what it can, but read the output before running it.