6
Steps To Importing .csv or .txt File With Microsoft Excel
In order to edit a .csv or .txt file, the file must first be imported into Excel. Do Not OPEN a CSV or TXT file by
double clicking on the file. Once the corrections have been made, the file will need to be saved again as a CSV
(Comma Delimited) (*.csv).
Using Microsoft Excel 2007, 2010, 2013, 2016 and Newer With Text Import Wizard Option Added
NOTE: The steps below will work with the 2007-2016 Versions of Excel, and the newer versions of Excel if the
Text Import Wizard has been added using the steps above. The program may look and feel slightly different.
1. Open a blank Excel spreadsheet.
2. Select the Data tab from the top on the screen.
3. In the Get External Data group, click From Text.