Can you append an example sheet, or explain more about:To avoid that situation, try a CSV formatted like this example:Include the headers in the first row (just for troubleshooting) and fill the data astype, color, itemthese are red items, red, “appl...

FYI, this is kinda bruteforce and not at all sophisticated, but here's a simple formula that just de-capitalizes everything after the first letter, for transforming UPPERCASE to TitleCase:REGEX_REPLACE( LastName, MID(LastName, 2, LEN(LastName)), LOWE...