How to convert database column values to lowercase before import
- Step 1Export the data as CSV — Pull the source data from your legacy system, spreadsheet, or previous database.
- Step 2Identify the string columns to normalise — Check which columns contain status values, type enums, or category strings.
- Step 3Apply lowercase to those columns — Drop the CSV into Case Converter and select the relevant columns.
- Step 4Import into your database — Download the normalised CSV and run your bulk insert or migration tool.
Frequently asked questions
Should I lowercase primary key columns too?+
For numeric IDs, no. For UUID or slug-type keys, lowercase is standard and reduces join errors.
Does this modify numeric columns?+
The converter only changes letter case. Numbers are unaffected.
Is this different from using LOWER() in SQL after import?+
It achieves the same result. Normalising before import means your stored data is already clean, which is better than applying LOWER() in every query.
Privacy first
Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.