How to extract Hyperlinks at once

Listly
Listly
Mar 6, 2019 · 2 min read

[Quick Summary]

0. When is it necessary?

  1. Go to the Parent page and Run Listly Chrome Extension
  2. Download Excel (Must check “SHOW HYPERLINK”)

0. When is it necessary?

If you make a group to download multiple pages into Excel, you will need to write down the URLs of multiple pages. Of course, you can copy and paste each URL one by one. However, if there are too many URLs to copy in hand, we recommend that you have a try extracting URLs of child pages from the parent page.

Image for post
Image for post

“What is Parent-Child pages?”

Here’ s the concept of Parent-Child pages. The parent page has the list of hyperlinks to each child page that has your target data; company information such as company name, e-mail, location, telephone, and etc.

Image for post
Image for post
Parent page → Child pages → Excel
Image for post
Image for post
You can check more examples in Listly Use Case

1. Go to the Parent page and Run Listly Chrome Extension

Image for post
Image for post
Image for post
Image for post

2. Download Excel (Must check “SHOW HYPERLINK”)

Check the option, “SHOW HYPERLINK” and Download Excel.

Image for post
Image for post

Each hyperlink is shown next to each content. Column D contains the URLs of child pages. Copy and Paste them when adding a group.

Image for post
Image for post

Listly | How to Use

How to Use, Case Study, Excel Tips

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch

Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore

Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store