1. How can I import the volatility emails into excel?

You have to open it in Notepad, or some other text editor and replace all the | characters with spaces, then save it and open it with excel.

It is much easier to open the web page, highlight the table, copy it, and past it into excel.

You can even choose to paste it with no formatting