Turn a list of numbers or text into an IN clause ready to copy.
Separate values with a new line, comma, semicolon or tab. Use quotes for values containing separators.
Apostrophes are doubled to form SQL text literals.
IN ('Roma', 'Milano', 'O''Connor')Paste values separated by lines, commas, semicolons or tabs. The tool validates numbers, quotes text and escapes SQL apostrophes. Quoted values can contain separators. Everything runs in your browser.