Respect Columns when Copying and pasting a table from a table or web site
When copying tables from a web site or other table, and pasting into an Excel Spreadsheet, the data is all put in one column. It should be pasted into separate columns. The workaround is to copy and paste one column at a time is quite cumbersome and sometimes does not work if there are blank cells.
Steven T commented
And why is it that Microsoft Word will recognize tables from pdfs, but Excel won't? Does Word have better developers than Excel? I can't imagine that. But Excel did easily recognize tables from the web, copy and paste before 2003. Why was the feature removed???
Kenneth Barber commented
Did you try Text To Columns in the Data tab?