Copying data from webpage table into excel

Chomeur

Quite often I need to copy data in a table on an Internet page into Excel, e.g. with bank statements. If I just select what I need and paste it into Excel then it all appears in just one cell. So what I do instead is right click, chose "Select All", copy that into a new Excel document then select the parts that I actually need and then copy those into a second Excel document. Using "Select All" copies all sorts of formatting and controls that I don't need so I want to get rid of them somehow. This way I do end up with the data in the table set out as required.

But is there a better way to do this?

SAHD_Jim

Select what you need but instead of "paste", select "paste special". Then choose to paste as "unicode text" (iirc). This should place it across the cells.

lesalanos

data - text to columns, is the way that I use

debitcardmayhem

Export it (if it is bank statement) as csv and then open it from your download area.

Chomeur

Paste Special seems to be the best way. Doesn't always work though. Data text to columns isn't something that I've tried before, I'll try it next time although it looks as if it might need a bit of thought to get it right. Exporting as a csv file is fine except that a lot of sites don't offer this, cahoot for one, and if you want to add the data to an existing workbook you've got to copy it, paste it and close the document that is created.