CSV Files and Excel
To use .csv Files:
- Open Excel
- Select File, Open
- In the "Open" dialog box, change the "look in" drop down menu to the location where you downloaded the file; change the "Files of type" (bottom left corner) to "all files"; select the file "name" and double click or click on the "Open" button.
- Excel will then format cell-by-cell each variable based on the contents (numeric or text) of the cell.
Note: CSV files DO NOT initiate the Excel Text Import Wizard.
Comma Separated Value files
These are sometimes referred to as "Comma delimited files" that contain the values in a table as a series of ASCII text lines organized so each column value is separated by a comma from the next column's value and each row starts a new line. Here's an example:
A CSV file allows for the collection of data from any table so that it can be conveyed as input to another table-oriented application such as Microsoft Excel, Access, or SAS.