How to Read a CSV File

Comma Separated Value (CSV) files are used to exchange data between applications on different platforms and in different programs. The format is used in Microsoft Excel as well as in other spreadsheet applications, including OpenOffice. CSV files are also a legacy format—a format used during the early days of computing when mainframes and minicomputers were the norm. CSV files are easily opened and read using Microsoft Excel, if using Windows or Mac, or with a text editor.

...
CSV files are easily read using a spreadsheet application.

Reading a CSV File–Microsoft Excel

Step

Click on the Microsoft Excel icon on your computer's desktop to open the program or by clicking on the program's name in the “All Programs” menu if using Windows. If using a Mac, click on the Excel icon in the Applications folder of your Mac's hard drive.

Step

Click on “Data” then “Get External Data.”

Step

Click on “Import Text File.” The Import Text File wizard will open.

Step

Click on “Files of Type.” Select “All Files.”

Step

Navigate to the directory containing the CSV file you want to open. Double-click on the file's name to start the importing process.

Step

Verify that “Delimited” is selected. If using a Mac, click on the “File Origin” and change it to “Macintosh.”

Step

Click on “Next.”

Step

Click on the circle next to "Tab" to uncheck the Tab selection.

Step

Click on the circle next to “Comma.” A preview of the contents of your CSV file will appear in the "Preview" window. You can scroll through the file's contents if desired.

Step

Click on “Next.”

Step

Click on the column that contains the “Object Ids.” Click on “Text.” Excel will now process the first column as text and keep the CSV file's data from being unreadable. Leave the other columns as “General.”

Step

Click on “Finish.”

Step

Click in the “A1” column of the blank Excel worksheet to paste CSV data into the blank Excel worksheet.

Step

Click on “OK.” The contents of the CSV file will appear in the blank Excel worksheet.

Reading a CSV File–Text Editor

Step

Click on “Start” then “My Computer.” Navigate to the directory containing the CSV file you want to read. If using Mac, click on your Mac's Hard Drive icon and navigate to the CSV file.

Step

Right-click on the CSV file's name. Select “Rename” if using Windows. If using a Mac, click once on the file's name and hold the mouse button down until the file's name is highlighted.

Step

Change the extension of the file's name to “.txt”. Press “Enter” or “Return” on your computer's keyboard.

Step

Open your computer's text editor, Notepad or similar program.

Step

Click on “File” then “Open.”

Step

Navigate to the directory containing the renamed CSV file. Double-click on the file's name to open it.