Covert web .txt to offline excel spreadsheet

[tinkertron]

For some reason or another I can copy this webpage .txt to my excel spreadsheet.

http://files.usgwarchives.org/oh/erie/cemeteries/milan/o.txt

I try to copy and paste the .txt to my excel spreadsheet but the 16 colms keeps copying into one column on my spreadsheet.

MS Excel 2007 version

 

[Ruddles]

The page isn't actually in columns - there are no delimiters so the text is all in 'column one'.

Split it up manually using Data > Text to Columns.