Data extraction

mbugg4

New Member
Joined
Aug 19, 2013
Messages
14
Hi All

I would like to know if there is any way of getting data from a list of URLS all in one go

The urls actual pages are all in table form

I need to this to stall all data and not delete the data from the previous URL etc etc

I know how to do this one at a time but obviously this is time consuming using Data extraction from the web

Thanks in advance

Michael
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
mbugg4,

What version of Excel and Windows are you using?

Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
MrExcel HTML Maker

Or, when using Internet Explorer, just put borders around your data in Excel and copy those cells into your post.
See reply #2 the BLUE text in the following link:
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045


If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.
 

mbugg4

New Member
Joined
Aug 19, 2013
Messages
14
Hi Thanks for the reply this is what the URLS will look like


Excel 2007
ABCDEFGHIJK
1http://members.informracing.net/informfree/new2/results.php?date=31/12/2008&mycourse=UTTOXETER
2http://members.informracing.net/informfree/new2/results.php?date=31/12/2008&mycourse=WARWICK
3http://members.informracing.net/informfree/new2/results.php?date=30/12/2008&mycourse=TAUNTON
4http://members.informracing.net/informfree/new2/results.php?date=29/12/2008&mycourse=MUSSELBURGH
5http://members.informracing.net/informfree/new2/results.php?date=29/12/2008&mycourse=NEWBURY
6http://members.informracing.net/informfree/new2/results.php?date=28/12/2008&mycourse=CATTERICK
7http://members.informracing.net/informfree/new2/results.php?date=28/12/2008&mycourse=LEICESTER
8http://members.informracing.net/informfree/new2/results.php?date=27/12/2008&mycourse=CHEPSTOW
9http://members.informracing.net/informfree/new2/results.php?date=27/12/2008&mycourse=KEMPTON
10http://members.informracing.net/informfree/new2/results.php?date=27/12/2008&mycourse=WETHERBY
11http://members.informracing.net/informfree/new2/results.php?date=26/12/2008&mycourse=HUNTINGDON
12http://members.informracing.net/informfree/new2/results.php?date=26/12/2008&mycourse=KEMPTON
13http://members.informracing.net/informfree/new2/results.php?date=26/12/2008&mycourse=MARKET RASEN
14http://members.informracing.net/informfree/new2/results.php?date=26/12/2008&mycourse=SEDGEFIELD
15http://members.informracing.net/informfree/new2/results.php?date=26/12/2008&mycourse=TOWCESTER
16http://members.informracing.net/informfree/new2/results.php?date=26/12/2008&mycourse=WETHERBY
17http://members.informracing.net/informfree/new2/results.php?date=26/12/2008&mycourse=WINCANTON
18http://members.informracing.net/informfree/new2/results.php?date=23/12/2008&mycourse=FONTWELL
19http://members.informracing.net/informfree/new2/results.php?date=22/12/2008&mycourse=HEREFORD
20http://members.informracing.net/informfree/new2/results.php?date=21/12/2008&mycourse=CARLISLE
21http://members.informracing.net/informfree/new2/results.php?date=20/12/2008&mycourse=ASCOT
22http://members.informracing.net/informfree/new2/results.php?date=20/12/2008&mycourse=HAYDOCK
23http://members.informracing.net/informfree/new2/results.php?date=20/12/2008&mycourse=NEWCASTLE
24http://members.informracing.net/informfree/new2/results.php?date=19/12/2008&mycourse=ASCOT
25http://members.informracing.net/informfree/new2/results.php?date=18/12/2008&mycourse=EXETER
26http://members.informracing.net/informfree/new2/results.php?date=18/12/2008&mycourse=LUDLOW
27http://members.informracing.net/informfree/new2/results.php?date=17/12/2008&mycourse=BANGOR-ON-DEE
28http://members.informracing.net/informfree/new2/results.php?date=17/12/2008&mycourse=NEWBURY
29http://members.informracing.net/informfree/new2/results.php?date=16/12/2008&mycourse=CATTERICK
30http://members.informracing.net/informfree/new2/results.php?date=16/12/2008&mycourse=FOLKESTONE
31http://members.informracing.net/informfree/new2/results.php?date=15/12/2008&mycourse=AYR

<tbody>
</tbody>
Sheet1
And this is what the data will look like that I am requiring from the URLS

Excel 2007
ABCDEFGHIJKLMNOP
126/02/2008
220-FebLEICESTER RH5 runVDW Ratings
3RaceFROST BOYS BEGINNERS' CHASE (4) 5YO+
4Winner £5,070.402m
5
6No.Dr.HorsePositionSPMasterLtoAvgM+ACseDisAbilityForm
710Barati316/111 311 4568 -2324--030
820ColemanstownU100/1621 271 4614 96567114030
930Fandani14-Sep8054 9180 10845 12860140-803515
1040Nikola22-Jan8383 2981 5374 6679162-74637
1150Tiffin Deano4100/16969 1241 13968 26146115--027
12
13
14Feb-50LEICESTER RH16 runVDW Ratings
15RaceBATES FAMILY HANDICAP CHASE (0-105) (4) 5YO+
16Winner £4,554.203m
17
18No.Dr.HorsePositionSPMasterLtoAvgM+ACseDisAbilityForm
1910Sovereign's JoyF14/17777 2766 8750 -6414177773713
2020Marshalls Run62-Nov7875 3478 6768 -74152-78015
2130Sabreflight--5151 601 32541 -318251-3524
2240Donald Will DoU14/18569 1374 2773 62721578585012
2350Ice And SodaP25/17766 3477 13365 14269146-77013
2460Ouragan De PrairieU2-Nov8383 1975 6278 9579162--014
2570Dundridge NativeU4-Nov771 765 2875 6747124-772816
2680Ours71-Dec711 5269 6271 8547118--014
2790Gerrard333/1791 1366 551 89231021-3623
28100Charlie's Double51-Sep7567 1358 4964 556313867754115
29110Ballyvaden11-Dec691 131 5569 77249311025
30120Tradingup925/1781 5861 7768 8943121-683625
31130Parish OakP66/18061 131 271 622110162624230
32140Jacarado250/16060 131 1421 354218160603629
33150Black Smoke425/17365 131 461 95229565653424
34160Log On Intersky8100/17161 1335 211 493210371-4625
35
36
3720-MarLEICESTER RH14 runVDW Ratings
38RaceGWEN FROST BEST MUM NOVICES' HANDICAP CHASE (0-90) (5) 5YO+
39Winner £2,927.702m 5f
40
41No.Dr.HorsePositionSPMasterLtoAvgM+ACseDisAbilityForm
4210CurradoonB33/1711 461 5571 7624957171025
4320In Extra Time--731 8573 13370 14948121-733521
4430Northern Quest31-Apr764 4675 6076 7052128-4338
4540BluecoatF50/17719 8546 32377 33647124--1520
4650So BrashF1-Mar7978 5862 7779 10573152--3513
4760Madam Harriet616/17553 2165 3271 5763138-71018
4870Red EnsignF14/1731 1468 3673 5547120-683018
4980KaparoloP100/1777 2731 321 11013907-3730
5090Fourpointone41-Dec7171 13674 -- 73144--07
51100William Butler21-Aug651 331 6860 902186--029
52110Minella Lodge11-Oct791 191 551 71180791030
53120SharbasiaP50/17260 1454 3467 6260132-72026
54130Furze Hill51-Aug6362 2663 5537 82541173763016
55140Kirby's Vic71-Aug11 121 -66 -2324--024
56
57
58Mar-50LEICESTER RH7 runVDW Ratings
59RaceDAN FROST MEMORIAL NOVICES' CHASE (3) 5YO+
60Winner £7,515.603m
61
62No.Dr.HorsePositionSPMasterLtoAvgM+ACseDisAbilityForm
6310Cathedral RockF15/8851 1984 4377 6254139-14213
6420Sheriff Roscoe211-Oct8578 4975 7668 98741597878426
6530Burren Legend11-May8575 1577 4585 6979164-85298
6640Clockers Corner5100/111 271 6256 -192011026
6750Desert Tommy333/18561 41 1072 2345130-856421
6860Double Intruder--7672 3276 8948 32265141--014
6970Ellies Horse450/1801 2080 2960 5947127-80025
70
71
72Apr-50LEICESTER RH11 runVDW Ratings
73Race"RIGHT TIME" WATCHES PETERBOROUGH HANDICAP CHASE (0-115) (4) 5YO+
74Winner £5,204.802m 5f
75
76No.Dr.HorsePositionSPMasterLtoAvgM+ACseDisAbilityForm
7710Copper Bay--7373 281 791 -2598--5525
7820Direct Access880/1611 2961 2941 -2182--8726
7930Zorro De La Vega52-Nov7767 2777 6073 767214977-529
8040Sole Agent41-Apr7977 2879 6843 9566145--437
8150Lysander1100/307979 2763 -86 -7615579792811
8260No Complaint21-May8181 291 4573 605213373-3319
8370Desert Secrets31-Jul7878 6963 901 9547125--4223
8480Muttley Maguire--6969 1381 -69 -7314269694712
8590Malaga Boy620/17160 2871 7162 9064135--4817
86100Master Somerville72-Nov7564 7575 10354 36164139-75020
87110Glimmer Of LightP33/1741 461 681 92175-745830

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2




obviously the next url need to be placed under the last and then carry on
 

John_w

MrExcel MVP
Joined
Oct 15, 2007
Messages
6,751
Try this:
Code:
Sub Get_Web_Data()

    Dim URLs As Range, URL As Range
    Dim destCell As Range
    
    With Sheets("Sheet1")
        Set URLs = .Range("A1", .Cells(Rows.Count, "A").End(xlUp))
    End With
    
    For Each URL In URLs
        With Sheets("Sheet2")
            Set destCell = .Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
            With .QueryTables.Add(Connection:="URL;" & URL.Value, Destination:=destCell)
                .Name = "web_query"
                .WebSelectionType = xlEntirePage
                .WebFormatting = xlWebFormattingNone
                .WebDisableDateRecognition = True
                .Refresh False
            End With
            .QueryTables(1).Delete
            DoEvents
        End With
    Next
        
End Sub
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,129,550
Messages
5,636,962
Members
416,952
Latest member
prakashkumar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top