Only thing is that when I pasted, it pasted it all in one row 1, not charted as it is online. Is it possible to right this?
Ignore my last post. You must have done something wrong. I tested, and it does indeed go into one row if you paste like normal. It works just fine if you paste special as text.
You have to right click, select paste special, and then choose one of the text options.
Give that a go before using the web query.