Import HTML pages into excel

**John Sio** · 05-30-2023, 03:06 PM

Hi,
I would appreciate some help in finding an easy way to import multiple HTM pages into excel. My technical capabilities are minimal for this type of action.
The following website (www.soccerassociation.com) has hundreds of thousands of pages which I need for my own personal statistical purposes.
There is data for 69 countries where Albania is listed first as (ALB). It seems to me that ALB has a country code of 72 judging by this index page, i.e. https://www.soccerassociation.com/72/index.htm. On this index page there is data for 2 leagues, i.e. Kategoria Superiore and Kategoria e Par?. If you select the Kategoria Superiore league there is a list below with season archives from 2007 till 2022 whereby the league table / results can be displayed from round 1 till the end of all rounds for that season. If I select from drop down 2007/2008 and press "view", I land on https://www.soccerassociation.com/72/0708/index0.htm. Then if I select Round 1, I land on https://www.soccerassociation.com/72/0708/A20070825.htm. From what I can see, after /72 (the country code) there is 0708 (which would be the season) and the A20070825 (where A is the first league "Kategoria Superiore"" and 2007 (the year) and 0825 (the date that Round 1 started). What I need to import for ALB is https://www.soccerassociation.com/72/*.* (i.e. all HTM pages for country code 72).
As you can see there would by a lot of pages even for one country let alone 69. I have a list of all 69 country codes.
How can I go about this in an easy fashion please?
Thanks
John

**amelialogan778** · 05-30-2023, 04:30 PM

Hey John,

No worries, I've got a simple suggestion for you! To import multiple HTML pages into Excel, you can use the "Data" tab in Excel. Click on "From Web" and enter the URL of the HTML page you want to import. Excel will guide you through the process and let you choose the data you need. Just repeat this for each HTML page you want to import. It's a user-friendly way to get the job done! Let me know if you need any further assistance.

Cheers!

**alansidman** · 05-30-2023, 10:38 PM

@John Sio

Are you still using XL2003 or a later version. Contributors here fashion their responses to the version of XL you are using. There are many features in the later versions of eXcel not available in 2003. Please advise and update your profile if you are using a more current version of excel.

**John Sio** · 05-31-2023, 03:05 AM

Originally Posted by alansidman

@John Sio

Are you still using XL2003 or a later version. Contributors here fashion their responses to the version of XL you are using. There are many features in the later versions of eXcel not available in 2003. Please advise and update your profile if you are using a more current version of excel.

Ok, I will check and advise. Thanks

**John Sio** · 05-31-2023, 03:08 AM

Originally Posted by amelialogan778

Hey John,

No worries, I've got a simple suggestion for you! To import multiple HTML pages into Excel, you can use the "Data" tab in Excel. Click on "From Web" and enter the URL of the HTML page you want to import. Excel will guide you through the process and let you choose the data you need. Just repeat this for each HTML page you want to import. It's a user-friendly way to get the job done! Let me know if you need any further assistance.

Cheers!

Hi and thanks for your reply.
I was aware of the feature you mentioned but if i process my requirement in that way it may literally take me months to complete since there seems to be hundreds of thousands of pages to import. I was looking for an easier way to action this. Thanks again

**John Sio** · 06-02-2023, 01:41 PM

@alansidman
I am now using excel 2010 version. I have updated my profile.
Question? Have I maybe posted this request in a wrong area?
I havn't reveived many responses to something I thought was doable by someone who knows...

Maybe Mr. Falcon @63falcondude knows?
Maybe I need to purchase software which does this type of processing? If so, which software?
Or maybe I need a paid commercial service whereby someone performs all necessary processing which I can describe in full since there is further actions required after the import?

Is any moderator in a position to help me?

Cheers
John

**sandy666** · 06-06-2023, 11:05 PM

is that what you want?

**John Sio** · 06-07-2023, 04:45 AM

Originally Posted by sandy666

is that what you want?

@sandy666 thanks for replying
fyi i actually have to import thousands of these pages and thus i dont really want a table since i need to manipulate the info further after the import process. the scores are correct but the question is how was this done? due to my requirement to import thousands of pages i need the import to do it automatically. if i need to manually set a format prior to the import for the sheet then thats ok too.

**AliGW** · 06-07-2023, 04:59 AM

Why would having the data in tabular format prevent you from manipulating it further after import??? Don't understand the logic behind that comment.

Sandy has imported the data using Get & Transform Data > From Web (on the Data ribbon) to access the data.

If you still have Excel 2010, you'd need to download the PowerQuery add-in.

**sandy666** · 06-07-2023, 05:17 AM

do you need whole page from url you posted?
do you need import from more different urls whole pages?
try https://www.youtube.com/watch?v=VkDpwSGWPmk maybe it will help

**AliGW** · 06-07-2023, 05:34 AM

I have closed the duplicate.

As explained in the duplicate thread, you could do this by installing the PowerQuery add-on for Excel.

**John Sio** · 06-07-2023, 05:38 AM

Originally Posted by AliGW

I have closed the duplicate.

As explained in the duplicate thread, you could do this by installing the PowerQuery add-on for Excel.

Thank you @sandy666 @AliGW

**AliGW** · 06-07-2023, 05:38 AM

The download is here: https://www.microsoft.com/en-gb/down....aspx?id=39379

**sandy666** · 06-07-2023, 05:46 AM

you can use PowerBI Desktop without installing Power Query add-in to XL2010

**sandy666** · 06-07-2023, 05:49 AM

if two threads are duplicated answers should be merged to not closed thread

**AliGW** · 06-07-2023, 05:55 AM

@Sandy - pages copied. Just an oversight - it is something I usually do.

**John Sio** · 06-07-2023, 01:17 PM

In actual fact, the two threads are different. It is merely the same example being used for different requirements.
You see, I didn't receive much help on the initial thread so I thought to look into it myself a bit more (with the minimal knowhow that I have) and I came across another stumbling block which I reported on the other thread that has been closed.
I have looked at the video regarding Power query and it is too advanced for me to process in this way.
So, at the moment my 2 issues have not been resolved. Maybe for you they have but not for me.
Is there another more simple way as I requested initially in this thread?
Maybe a macro that can be easily tweaked so I can run it a few times for the different country codes. Everything is clearly described in this initial thread.
I would appreciate if someone has more time to investigate and help a starter like me.
BTW what is are commercial services for? Maybe I need it?
Thanks
John

**AliGW** · 06-07-2023, 01:24 PM

Shall I move the thread to the VBA section for you? You may get a macro solution there.

**John Sio** · 06-07-2023, 01:27 PM

@AliGW I would dearly appreciate that! What about the other thread though? It is different right? No easy solution for that one?
Thanks again
John

Import HTML pages into excel

LinkBack

Thread Tools

Rate This Thread

Display

Import HTML pages into excel

Re: Import HTML pages into excel

Re: Import HTML pages into excel

Re: Import HTML pages into excel

Re: IMPORT = incorrect format

Re: IMPORT = incorrect format

Re: IMPORT = incorrect format

Re: Import HTML pages into excel

Re: Import HTML pages into excel

Re: Import HTML pages into excel

Re: Import HTML pages into excel

Re: Import HTML pages into excel

Re: Import HTML pages into excel

Re: Import HTML pages into excel

Re: Import HTML pages into excel

Thread Information

Users Browsing this Thread

Similar Threads

PDF import to excel bringing One page at a time not all the pages

Web Query - Import data from multiple pages into a single MS Excel worksheet.

[SOLVED] How to Import data from multiple pages of a website into a single Excel sheet

import data from multiple pages of a websites into excel

how to import word document into Excel - multiple word pages

Import data from multiple pages of a website into a single Excel workbook

How can I import data into Excel from web pages

Bookmarks

Bookmarks

Posting Permissions