List Genie 🧞

List Details

No data yet. Convert first!

Exclude Characters

Characters you check (or enter below) will be removed before List Genie processes the text.

Other characters to remove:

List Genie Features & Tips 🧞‍♂️

🚀 Core Features

Convert Lists: Transform a list of items into various formats:
- Comma Delimited: item1, item2, item3
- Definition Query: ('item1', 'item2') - Great for SQL IN clauses!
- Query Builder: item1 | item2 - Useful for regex or filters.
Compare Lists: Click "➕ Add 2nd List to Compare" to input a second dataset.
- Finds matching items (intersection).
- Identifies items unique to List 1 or List 2.
Clean Data: Use "🚫 Excluded Characters" to strip unwanted symbols (like trailing commas or dots) before processing.

💡 Pro Tips

Split on Newline: Check this if your data is row-based (like from Excel). Uncheck it if your data is space-separated.
Case Sensitivity: By default, "Apple" and "apple" are treated as the same item (case-insensitive). Check "Case Sensitive" to treat them as different.
Info Button: Click "ℹ️ Additional List Info" after converting to see stats like duplicate counts and total unique items.

📝 Examples

Scenario: SQL Query Prep
Input:


        ID_123

        ID_456

Settings: Select "Definition Query"
Result: ('ID_123', 'ID_456')