Data can be moved into Excel and then all of the capabilities of Excel can be used to modify and format the data. Since Excel is stored in a similar format as webpages, often highlighting and copying data from a web source will allow you to easily paste that information into a spreadsheet. There are some ways to also bring data into a spreadsheet when the usual copy-paste does not result in appropriate columns and rows.
With data like this, there is often a need to manipulate the text data to make the format appropriate. Those functions are found here, on the Text Functions page.