Skip to main content

Guide

Open a List of URLs from Excel in Chrome, One by One

Izly TeamLast updated: 6 min read

On this page

How do I open multiple URLs from Excel in Chrome?

Pasting fifty links into the address bar one at a time is slow, and a bookmark folder opens all of them at once and buries you in tabs. What most people want is to visit each address in turn, look at something on the page and move on. Izly does that with a table.

The worked example uses the practice shop, linked from the practice form. Its product pages have their own addresses, and there is a sample table of 10 product addresses to download. Each address is a whole web address, for example https://izly.io/practice-form/shop/product/3.

What are the steps?

  1. Record one visit. Open the first product page of the practice shop and finish the recording. At minimum, the recording holds the step that opens the page.
  2. Make the address a column. In the automation set-up on the Izly site, add a saved value that “Comes from a column of the table”, then set the address of the opening step to “With saved values” and put the saved value in. A saved value at the very start may hold a whole address (https://…) and is used as it is.
  3. Paste the table. When you run, copy the address column from Excel or Google Sheets, or load the CSV. Try the first 3 rows before the whole table.
  4. Add a read step if you want data. Click the product name or the stock text while recording, set that step to “Copy from page” and keep the saved value for the results.
  5. Run. Start it from the extension’s side panel or the guide’s page, and confirm. Chrome visits row 1, then row 2, and so on. Every row ends with a line in the result table.

The address can also be a fixed start plus a value. If your sheet has only product numbers, put the saved value after a fixed start such as https://izly.io/practice-form/shop/product/, and the number completes the address.

Can I read something on each page, not just open it?

Yes, and this is where the method becomes useful. A “Copy from page” step copies a text or a number from the page into a saved value. You can keep that value for the results, and you can also type it elsewhere, for example into a form on another site, in the same run.

Result table for three product addresses
AddressNameStockStatusNote
https://izly.io/practice-form/shop/product/1name from the pageIn stockDone
https://izly.io/practice-form/shop/product/2name from the pageSold outDone
https://izly.io/practice-form/shop/product/99FailedPage not found (404)

The columns are the ones you get: your input column, the values read from each page, Status and Note.

What happens when an address answers with an error?

A page that answers with an error, such as 404 not found, fails that row and the reason is written in the Note column of the result table. It does not break the run. In the practice shop a product number that does not exist answers “not found”, so the sample table includes one address that points at product 99, which does not exist, so you can watch a failed row.

You decide what comes next. Either Izly goes on with the next row, or it stops and asks you to try again, skip the step or skip the row. For a list of two hundred links that may include a few dead ones, going on and reading the failures afterwards is usually the right choice.

Can a page value decide what happens next?

Yes, with a simple rule. If the page shows a certain text, or a value you read is above a number, the row can be skipped or the run stopped, with a note. For example: if the page shows “Sold out”, skip this row and write “sold out” as the note.

There are also blocks for optional parts of a page. An If block (“Run only if”) runs its steps only when an element is there, and a Repeat block repeats its steps until a chosen element is gone, up to a limit you set. That is how a “next page” link is followed.

What can it not do?

  • It opens pages in your own Chrome, one at a time. It does not open hundreds of tabs in parallel.
  • A person starts the run. There is no schedule and no unattended server run.
  • You sign in yourself. If the pages need a login, sign in first. Izly never stores passwords.
  • Whole addresses. The column must hold full web addresses (http:// or https://), or you put a fixed start in front of the value.
  • Chrome 120 or newer. The run plays in a Chrome tab on a desktop.
  • The Free plan runs at most 5 rows per table run. Pro has no row limit.

Respect the terms of the sites you visit. Opening your own supplier pages or your own listings is one thing; hammering a third party’s site is another.

How does Izly handle a list of addresses?

Izly is a Chrome extension that turns a task you do once in your browser into a step-by-step guide, a narrated video and a no-code automation that repeats the task. For a URL list, the recording is tiny: one page visit and, if you like, one read. The table does the repeating.

The same recording is also a guide, so a colleague can read how the check is done while the table does the opening. The Free plan covers 10 runs a month with 5 rows each; Pro removes the limits for 10 USD per creator per month. See pricing.

Frequently asked questions

Can Izly open every link in my sheet automatically?

Yes, one by one. Paste the column of whole web addresses and make it the page to open in each row. Chrome visits them in order, and the result table lists what happened to each address, including any that answered with an error.

Do the links need to start with https?

A whole address from a column must start with http:// or https://. If you only have the end of the address, such as a product number, put a fixed start in front: the address of the step is the fixed first part plus the value from the column.

What if a link is dead?

A page that answers with an error such as 404 fails only that row, and the reason is written in the Note column of the result table. The run goes on with the next row, or stops and asks you, as you chose before starting.

Is this the same as opening all bookmarks at once?

No. Bookmarks open every page together and leave you with a crowd of tabs. Izly visits the addresses in turn, can read a value on each page and writes one result line per address.

Related pages

Record it once and let the guide write itself

With Izly you do the task once in the browser. Clicks and screenshots become a step-by-step guide that you edit, share, turn into a narrated video or run again for every row of a table.