how do you drop an HTML spreadsheet into excel

[Luddist]

I have been receiving HTML spread sheet as remittance statements. I need to
drop these into excel to sort and review data. At present when I copy the
data and drop into excel everything goes into the first column.