Importing Delimited Text to MS Excel: Step 1

This site will provide you with instructions on importing text data into Microsoft Excel for data manipulation and/or reporting.

A delimited file will look similar to this:

Cholesterol | 1 | 2 | 2 | 1 | 2 | The screening was informative and helpful | Perhaps try and a lot more time for questions and answers
Cholesterol | 2 | 1 | 2 | 2 | 1 | |
Cholesterol | 3 | 2 | 1 | 2 | 1 | Not enough information on how to reduce my cholesterol | Offer additional handout materials to help retain what was taught
Cholesterol | 1 | 2 | 1 | 1 | 1 | Excellent | Can you tell everyone next time how the cholesterol test actually works?

This data is in a format called pipe-delimited. Pipes are the vertical lines in between each of the variables. To import this inTO MS EXCEL, follow these easy steps.

Next step

If you require further assistance with the instructions or information on this page, contact the IT Support Center.