Is there a way to populate or fill blank href=" " with links from a google excel sheet?

example: 

Column 1: "http:1.com" Column 2:"http:2.com" and so on....

my html has several list items with blank a tags, href=" "

So would it be possible to fill these blank a tags in sequence - following the order of those defined in the excel sheet?

Kindly let me know. Or point me in the right direction if possible. Thanks