# List Converter Guide

Convert between line lists, CSV, JSON arrays and other list formats.

- Tool: https://ilham.dev/tools/list-converter/
- Guide URL: https://ilham.dev/guides/list-converter/
- Tool guides index: https://ilham.dev/guides/tools/
- Broader guide: Text Formatting and Cleanup (https://ilham.dev/guides/text-formatting-and-cleanup/)

## What it does

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.

## Use the tool

Open https://ilham.dev/tools/list-converter/, add the input the tool asks for, run it, and check the output before using it elsewhere.

## Input and output

- Input: text.
- Output: text.
- Category: Formats.

## Privacy and processing
Processing happens locally in your browser. This tool does not upload the input to ilham.dev.

## Questions

### Does it deduplicate or sort?

Only if you ask it to. By default the order and the duplicates are exactly as you pasted them.

### 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.