Changing CSV character encoding, preserving IDs, and standardizing dates

You received a CSV, but the Japanese characters are not displaying correctly. When you open it in Excel, the leading zeros in ...