Example input
apple
banana
cherry
Quote lines for SQL values
Wrap each value with single quotes so copied IDs, names, or labels are ready for SQL value lists, inserts, or quick query cleanup.
Quoted output
'apple'
'banana'
'cherry'
Steps
- Open Quote Each Line Online.
- Keep the single-quote preset enabled.
- Paste one value per line.
- Copy the quoted values as separate rows or switch delimiters for a joined output.
When this helps
- Preparing SQL value lists before joining them
- Cleaning spreadsheet rows before a query
- Quoting labels or enum values for quick inserts
Related tools
If you need parentheses and commas too, use the SQL IN guide. If you only need commas, use Split / Join.
FAQ
Can I use double quotes instead?
Yes. The quote tool also supports double quotes and backticks.
Can I join the quoted lines with commas?
Yes. Change the delimiter in the quote tool to a comma-based output when you need a single row.
Can I reverse the process later?
Yes. Unquote mode can turn quoted rows or a quoted CSV list back into plain values.