How to insert a bunch of links to an excel document?
September 4, 2012 2:21 PM Subscribe
How to batch insert links to an excel document?
posted by Sentus to Computers & Internet (1 answer total)
Ok so here we go:
So I have a pretty nifty website for my little landscaping comany, in that website there are individual plant profile pages for plants that we use in our practice.
In our bids and designs I provide the bid in an excel form (+exported to pdf for folks that prefer that format.)
I want to allow clients to click on the plant name in the bid and be forwarded to the appropriate plant page on our website. Doing it manually (by inserting a hyper link in excel) takes wayyy long than it should. Any ideas?
My current process:
1. Use the landscape design software, export a csv file for the plant list.
2. Open my excel bid form, copy paste the information from the csv file to the bid form under the plants used column.
3. Manually insert hyper links for plants used to their link on my website.
Surely there is some kind of easier method, some batch link inserter?
Thanks in advance for any insights!