Copying a table from a web page often pastes everything into one column, or drops merged cells. Here are three ways to get a clean table into a spreadsheet, from the simplest to the most reliable.
This works for simple tables. It tends to fail when the page uses a grid made of div elements instead of a real table, when rows are loaded as you scroll, or when cells are merged.
If the formatting comes out messy, paste into a plain text editor first, then copy from there into the spreadsheet. Tabs between the cells are kept, so the columns usually line up. In Excel you can also use Paste Special, then Text.
An extension reads the table's structure instead of the selected text, so the columns stay in place and merged cells are filled in.
It runs only on the page you click it on, and sends nothing anywhere. See the help page for details.
A CSV file is plain text with one row per line and commas between cells. Excel, Google Sheets, Numbers and databases all open it. To make one by hand, paste the table into a spreadsheet and use File, then Save As (Excel) or File, Download, Comma-separated values (Sheets). With the extension, the Download button does this in one step.
In Excel, select the column and use Data, then Text to Columns, and pick Tab or Comma. In Sheets, use Data, then Split text to columns.
Format the destination columns as Text before pasting, or import the CSV through Data, then From Text/CSV and set the column type.
Open the file through the import dialog and choose UTF-8 as the encoding.