"It should be 00123, but it turned into 123 when I opened it in Excel..."When working with CSVs, this happens, doesn't it? For data where the leading zero is important, such as product codes, employee ...
Web apps love exporting CSV files, but they don't always play nice with Excel. Leading zeros disappear, dates break, and text fields merge together. Most people waste time fixing these problems ...