• Excel rocks for data analysis, but it does have some irritating quirks, particularly when working with csv files. I frequently receive customer data in csv format that contains leading zeros (think account numbers, personal identification numbers, etc.). Without fail, Excel drops the leading zeros when opening a csv file. My advice to Excel programmers is to present all csv data with text formatting on every cell.