Add leading zeros to a column and make Excel leave them alone? in Microsoft Office 97-2016 Posted March 9, 2017 A quick google search shows there should be some programs that can read from a CSV to rename files. Don't know if they can use XLS. When I doubleclick the CSV, which does have the leading zeros, Excel just open it - and removes the leading zeros. I could try changing it to TXT and see if I can have Excel import those number columns as text.