Frequently Asked Questions

What is csvwithquotes.com?

csvwithquotes.com is a free online tool that helps you quickly format a list of items into a comma-separated values (CSV) format, useful for building ad-hoc SQL and Salesforce SOQL queries.

How do I convert my list into a CSV output wrapped with quotes?

  • Paste your list of items into the input field
  • Choose a quote style: single, double, or no quotes
  • Click the "Generate CSV" button to convert your list
  • Copy the output and drop it into your SQL or SOQL queries

How do the various options impact the output?

Separator

Comma (default) example with 'single quotes':

Input: item1 item2 item3

Output: 'item1','item2','item3'

Semicolon example with "double quotes":

Input: item1 item2 item3

Output: "item1";"item2";"item3"


Split Input By

  • New line: Each line of the input is treated as a separate element
  • Space: The input is split into elements based on spaces.

Input:
item 1
item 2 with spaces
item 3


Output with new line:
'item 1','item 2 with spaces','item 3'


Output with space:
'item','1','item','2','with','spaces','item','3'

Do you store my data?

No, we do not store your data. When you input your list of items, the backend processes it on demand to generate the CSV output. There is no database involved, so your data is not saved or stored on our servers.

Do you offer any warranty or guarantee?

We do not provide any guarantees or warranties regarding the accuracy, reliability, or completeness of the output generated by csvwithquotes.com. The tool is intended to be a helpful resource, but it is not a substitute for careful review and verification of your data. Please use the generated CSV output with caution and ensure that it meets your specific requirements. We are not responsible for any errors, omissions, or consequences that may arise from the use of this tool.