Directions for importing raw data fields into an Excel spreadsheet. Step 1: Save data file to your computer by right clicking link and choosing “SAVE TARGET AS”. Step 2: Run MS Excel. Step 3: Click on FILE> OPEN> (force it to show all files in the directory, usually it only shows .xls files). Step 4: Choose the correct “.txt” file and hit OPEN. At this point the “text import wizard” should pop up. Step 5: Make sure delimited is checked then hit NEXT. Step 6: Make sure comma is checked then hit NEXT. Step 7: Hit FINISH The data file should open with titles above each column. |