Copying from HTML Table then Pasting into Excel

What is the best way to copy data from an HTML table in a webpage into Excel so that it looks the same as it does in the webpage - i.e. columns and rows and data in the same cells?

When I paste the data from a table with four columns and 10 rows it either pastes all the data into one cells or if I do a 'paste special' and chose 'text' it still looks a mess.

Even if I just copy one column and paste that, it puts the data in row cells rather than the cells in one column.

Any ideas?

Thanks.

Data - Import external data - New web query and follow the wizard

Try using

Data Menu > Inport External Data > New Web Query > follow the prompts