Web Development - UD Application Help Pages

Importing Delimited Text to MS Excel: Step 1

Questions should be directed to Web Development, it-webdev@udel.edu

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