How to export tabular data from html to excel with layout disturbed.

Dear all,

I have some data in rows and columns (thousands of entries) in html file which I want to export or copy/paste into an excel file. When I do that the three column data in excel file becomes two column (two of the columns merge).

Sample of the html data is here:

19550101 000000 057
19550101 010000 060U
19550101 020000 A
19550101 030000 A
19550101 040000 057
19550101 050000 059
19550101 060000 060

In Excel column 2 and 3 merge so the data becomes unusable. It is the column 3 which is most important for me. I would be thankful if anybody suggest me a way out of this trouble to get the the data in excel/csv format without being distorted.

Best regards
Afzal Ahmed

I am not allowed to post a link, I can email you the file if you share youd mailing id.