A CSV is a comma separated values file which allows data to be saved in a table structured format. CSVs look like a garden-variety spreadsheet but with a .csv extension. Traditionally they take the form of a text file containing information separated by commas, hence the name.
How do I convert a CSV file to Excel?
By using Excel's text import wizard, you can ensure data in *.csv is correctly imported into Excel and leading zeros are not dropped.
- Download and save your *.csv file to your chosen location.
- Start Excel with a blank workbook open.
- Select 'Data' on the ribbon, and then 'From Text'.
What is CSV format used for?
CSV is a simple file format used to store tabular data, such as a spreadsheet or database. Files in the CSV format can be imported to and exported from programs that store data in tables, such as Microsoft Excel or OpenOffice Calc. CSV stands for "comma-separated values".