Open Multiple Links in Google Sheets

24Mar

Open Multiple Links in Google Sheets

Sometimes you need to open several links in Google Sheets. But opening them separately one by one is a chore / bore.

Open them all with two clicks!

Select cells containing links.
Open them simultaneously by right clicking and selecting Open links option.

Pretty easy, right?

Google Sheets Office

7 comments

justatip January 22, 2019 at 9:27 pm

This doesn’t work anymore.

Rob April 20, 2019 at 4:13 am

Thanks! There’s a shortcut for it…

1. Highlight the links you want to open.
2. Press Alt+Enter

Just make sure you don’t open too many links that your computer won’t be able to handle!

P Mosin April 15, 2020 at 10:48 pm

Love this trick! Worked really well for me to enable download multiple CSV files that had consistently formatted URLs.

FYI, as of this writing the right-click menu item now reads “Open links” instead of “Open all links”. On the Mac the keyboard shortcut is Option + Enter.

Max July 26, 2020 at 4:21 am

This is great, thank you!!

Roman Luks February 7, 2021 at 9:24 am

I’ve tested this on 2020-02-07 in Firefox 85, it DOES work. Only thing that’s changed is the label, it’s now called “Open links”.

JR May 2, 2021 at 10:12 am

THANK. YOU. I can’t believe I haven’t seen that before lol

SageSage7 November 21, 2021 at 5:40 am

this is good.
i more hope though, the ability of opening them as incognito modes.

Open Multiple Links in Google Sheets

7 comments

justatip January 22, 2019 at 9:27 pm

Rob April 20, 2019 at 4:13 am

P Mosin April 15, 2020 at 10:48 pm

Max July 26, 2020 at 4:21 am

Roman Luks February 7, 2021 at 9:24 am

JR May 2, 2021 at 10:12 am

SageSage7 November 21, 2021 at 5:40 am

Leave a Reply

Leave a Reply