Convert CoinMarketCap data to Excel

[eryksd]

I did it once but can't figure it out again...

How do I simply past in the date on the following page, into excel?

https://coinmarketcap.com/all/views/all/

When I paste it in, the formatting is all messed up (everything in Column A). Tried "Paste Special" and "Text to Columns" but can't get it to look like it does on the website.

Many thanks in advance for any help!

 

[eryksd]

Anyone?

I've written VBA code before but can't figure out how to just copy and paste this data without it formatting weird lol.

 

[00jaggy]

I just gave it a shot in Excel 2010 and a simple ctrl C / ctrl V worked fine. Everything lined up in columns.
When I copied I started by selecting/highlighting from the hashtag "#" in the first column on the site all the way down to the "?" for EtherDoge in the last column.

 

[eryksd]

I just gave it a shot in Excel 2010 and a simple ctrl C / ctrl V worked fine. Everything lined up in columns.
When I copied I started by selecting/highlighting from the hashtag "#" in the first column on the site all the way down to the "?" for EtherDoge in the last column.

On my desktop I was able to do the same, I'm on the road however in another country and on my laptop it just wont work for some reason.

Update: Actually just tried pasting it from Firefox instead of Chrome and it worked, can't believe I didn't think of that yesterday... guess that's why it doesn't always pay to burn the midnight oil

Thank you for the feedback, glad to hear it was possible, made me think about it was probably some sort of weird formatting thing with Chrome.