✨Text Cleanup
Clean CSV Column
Normalize a single column from a CSV for import.
Explanation
Often CSV data contains inconsistent padding or case which breaks database unique constraints.
Examples
CSV Column
Input
SKU_1 sku_1 sku_2
Output
sku_1 sku_1 sku_2
Code Examples
JavaScript
const cleanList = input.split('\n')
.map(line => line.trim().toLowerCase())
.filter(line => line !== '');Try it Now
💡 Tips
- Standardize casing before importing to a database
- Remove trailing spaces which are invisible in Excel
- Useful for generating unique keys
⚠️ Common Pitfalls
- Don't lowercase if the values are case-sensitive IDs