How to import a CSV file into Excel?
Microsoft has changed the import procedure for CSV files. A new wizard imports a CSV file into Excel quite straightforwardly, and the imported tables look fine at first glance. However, imported numbers are stored as text in the Excel sheet. You realize this when you try to use the SUM function, and the result is 0.