Excel Forum

Get data from web using power query, how to get several different URLs at once (not parts)

MohamedGadAllah

EGYPT - Cairo

Member

Members

Forum Posts: 39

Member Since:
December 13, 2021

Offline

December 13, 2021 - 9:49 pm

Hi,

Thanks for your YouTube videos.

I would like to know how to import several URLs at once.

For example:

https://www.gsmarena.com/apple.....-11089.php

https://www.gsmarena.com/apple.....-11102.php

https://www.gsmarena.com/apple.....-11103.php

How to do so?

Catalin Bombea

Iasi, Romania

Admin

Forum Posts: 1810

Member Since:
November 8, 2013

Offline

December 15, 2021 - 4:46 pm

Hi,

You can create a table with all your links, import this table in power query, then add a new column with this formula:

=WebContents([URL Column])

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Shanna Getschel, andria young, RAMEZ ATTAR, Bruce Tang Nian

Guest(s) 11

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 871

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

Jessica Stewart: 205

A.Maurizio: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Bruce Tang Nian

Scot C

Othman AL MUTAIRI

Misael Gutierrez Sr.

Attif Ihsan

Kieran Fee

Murat Hasanoglu

Brett Dryland

Saeed Aldousari

Bhuwan Devkota

Forum Stats:

Groups: 3

Forums: 24

Topics: 6222

Posts: 27293

Member Stats:

Guest Posters: 49

Members: 31918

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen