Appendix B: Opening CSV Files in Excel 2007 or Later

This appendix explains how to open comma-separated value (CSV) files in Microsoft Excel 2007 or later.

1.Open Microsoft Excel.

2.On the Data tab, in the Get External Data group, click From Text. The Import Text File dialog box appears.

3.Navigate to the CSV file, and click Import. The Text Import Wizard appears.

4.In Step 1 of the wizard, mark Delimited, and click Next.

5.In Step 2 of the wizard, mark Comma, and click Next.

6.In Step 3 of the wizard, do the following:

a.In the Data Preview section, click a column. Excel shades the column with a black background.

b.In the Column Data Format section, mark the Text radio button. This setting preserves leading zeros that can appear in fields.

c.Repeat steps a–b for all columns in the CSV file.

d.Click Finish.

Excel imports and displays the CSV file.