Question: how to convert a csv file in excel 2010?
Answer: Open the Excel spreadsheet where you want to save the data and click the Data tab.
In the Get External Data group, click From Text.
Select the TXT or CSV file you want to convert and click Import.
Select "Delimited". ... 
Click Next.