I have a .csv file that consists of thousands of lines (6000 pages when
opened in MS Word).

How can I get that data into excel?

I have seen some knowledge bases do it with a macro but that macro seems to
work only with text files and ignores the fact that my data is a .csv so I
get loads of rows with all my column data all in column A as text with
commas!!!

Please help me - my brain is hurting!