Probably an easy fix but I’m a rookie, I am extracting data from a csv attachment in Outlook and when it pastes into my xlsm workbook it retains the csv formatting. I need it to spread across the cells/columns like it does automatically upon opening the csv file. I add this data incrementally and you’ll see the difference in formatting quite easily. Thanks

I have a workbook (wb1) in which I need to compare with data pulled from an external program.

I would like to download data from a website to Excel in order to create my own statistics. I tried power query but couldn’t get everything I wanted.
For example, here is a specific URL:
https://www.betexplorer.com/football/algeria/ligue-2/
On this page, the next matches section is downloaded, but not the standings. And only a part of the results, because under the results there is an inscription “show all results” that you have to click on to reveal all the results.
Can someone help me with how I can download the data on the page with an Excel macro?
Someday I would have to download more similar data, which is very slow manually, so I would like to automate it.
(I use excel 2013.)
Thank you in advance for your help!