import numpy as np
import pandas as pd
from IPython.display import HTML
a = pd.DataFrame({'address_lines':['31 Stuart Road Highcliffe', '33 WEST STREET', '66 PINE ROAD', '37 PRIESTLEY ROAD', '9 MAYFORD ROAD'], 'city':['CHRISTCHURCH', 'RINGWOOD', 'BOURNEMOUTH', 'BOURNEMOUTH', 'POOLE']})
def make_clickable(val):
    return '<a href="{}">{}</a>'.format('www.google.com/maps/place/' + val, val)
a.style.format({'address_lines':make_clickable})
# This is not giving the required data as hyperlinks
a.to_excel('test.xlsx')