So what's your question?
If you're asking if it can be done, the answer is Yes.
If you're asking how to do it, the question is - what version of Excel are
For Example in 2003 you would choose Data, Pivot Table and Pivot Chart
Report, and choose External data source, Next, Get Data, choose New Data
Source and click OK. Enter a name like myCSVData and open the second
dropdown. Select Microsoft Text Driver (*.txt,*.csv), click Connect.
Uncheck Use Current Directory, and then choose Select Directory. Find your
file and open it, you will be in a wizard, whose steps are fairly straight
If this helps, please click the Yes button