Hi,
I got these steps from a colleague to change the file to CSV. I found there was a header row I could not delete so I copied all of the other file data to a new report then added the PHEAA header.
1. Change this report from a text document to a CSV
a. Go to Data tab in Excel
b. Select From Text
c. Select the file (may need to pick “All files” if you do not see report)
d. Click import
e. Click delimited and click next
f. Click finished and ok
g. Add headers sent by PHEAA to spreadsheet
Hope this helps!
Christine Saadi
