Clean, sort and de-duplicate lines

Trim spaces, remove duplicates, sort, change case, and add text to every line. Free, and your data never leaves your browser.

Input
Result
Ad space: paste your AdSense code here

How to use it

  1. Paste your lines into the input box.
  2. Tick the clean-up options you need and choose a sort order.
  3. Copy the cleaned list.

Frequently asked questions

Can I add quotes around every line?

Yes. Use Add before and Add after, for example a single quote in both.

Does sorting handle numbers?

Yes. Numbers inside text sort naturally, so item2 comes before item10.

More SQL tools

📋 List to IN clausePaste a column from Excel and get a quoted, comma-separated list for WHERE ... IN (...).🔄 Rows ↔ columnsSwap pasted data so vertical becomes horizontal, and the other way round.✂️ Split to rowsTurn one line like a,b,c into one value per row.📥 Excel to INSERTPaste rows copied from Excel and get one INSERT statement per row.⚖️ Compare two listsFind what is in one list but not the other, what both share, or all unique values.✨ SQL formatterPut each major clause on its own line and uppercase keywords.