Im not able to import the .txt correctly in excel to have any meaningful data as its all jumbled. Can anyone suggest what I am doing wrong?
I don’t use the bulk product (just streaming), but since you have not had a reply yet I had a look. I just tried the company data product and downloaded a zip; extracted the CSV and it opened fine in LibreOffice (I don’t use excel either on this computer). The fields were as described in the associated PDF.
I think you could outline the steps you have taken and the files involved and someone might be able to pick up what is going wrong. At a guess it could be that your excel defaults are not picking up the delimiters correctly, but as I said more info would be needed.