I'm sure there is a better way than this but anyway here goes:
1. Save the data as a text file in notepad
2. Open the text file in Excel and choose Deliminated & Next
3. In the box marked Other add a pipe '|' & click finish
I just tried it another way, by saving the email as a .txt file then opening the whole thing in Excel and it worked fine that way too, although i did have the extra email text which needed deleting.