Web page pasted to excel?

gilbert

Board Regular
Joined
Jun 13, 2002
Messages
141
Can anyone tell me the best way to take info from a web page such as
https://www.nccob.org/online/LicenseSearch.aspx (simply click the show all button to see a list of lenders) I need to get the data grid into excel to cull out the ones I do not want. I have tried paste special and keep getting a spreadsheet I can't read or start manipulating

Thanks
Galen
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

BJungheim

Well-known Member
Joined
Jul 24, 2004
Messages
914
Have you tried a Web Query?

Data|Import External Data|New Web Query|
 

Watch MrExcel Video

Forum statistics

Threads
1,118,541
Messages
5,572,801
Members
412,485
Latest member
mayankhb
Top