IT Web Development Help Pages
Importing Delimited Text to MS Excel: Step 1Print this page
Questions should be directed to Web Development, firstname.lastname@example.org
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.