I would be interested to understand your workflow a bit better, but to try and help with your specific request:
- The HYPERLINK solution proposed in the comments looks like a good one
- If you are able to implement that upstream in the csv generation step then great
- If not and/or you are interested in automating the conversion process, consider using the pandas library:
- Create a DataFrame object from a csv using the pandas.read_csv method
- Convert your paths to HYPERLINKs
- Write back to xlsx using the pandas.DataFrame.to_excel method
E.g. if you have a file original.csv and the relevant column header is file_paths:
import pandas as pd
df = pd.read_csv('original.csv')
df['file_paths'] = '=HYPERLINK("' + df['file_paths'] + '")'
df.to_excel('new.xlsx', index=False)
Hope that helps!
Jon
Answer from Jon Hannah on Stack OverflowXlsxWriter
xlsxwriter.readthedocs.io › example_hyperlink.html
Example: Adding hyperlinks — XlsxWriter
############################################################################### # # Example of how to use the XlsxWriter module to write hyperlinks # # SPDX-License-Identifier: BSD-2-Clause # # Copyright (c) 2013-2025, John McNamara, jmcnamara@cpan.org # import xlsxwriter # Create a new workbook and add a worksheet workbook = xlsxwriter.Workbook("hyperlink.xlsx") worksheet = workbook.add_worksheet("Hyperlinks") # Format the first column worksheet.set_column("A:A", 30) # Add a sample alternative link format. red_format = workbook.add_format( { "font_color": "red", "bold": 1, "underline": 1, "font_size": 12, } ) # Write some hyperlinks worksheet.write_url("A1", "http://www.python.org/") # Implicit format.
EasyXLS
easyxls.com › manual › tutorials › python › excel-hyperlink-cell-file-sheet-url.html
Excel hyperlink to cell, file, sheet and URL in Python | EasyXLS Guide
Code sample Python: Create Excel file with hyperlink to cell, hyperlink to file, hyperlink to sheet or URL using EasyXLS library. XLSX, XLSM, XLSB, XLS file
Insert hyperlink to a local folder in Excel with Python - Stack Overflow
The piece of code reads an Excel file. This excel file holds information such as customer job numbers, customer names, sites, works description ect.. What this code will do when completed (I hope... More on stackoverflow.com
python - adding hyperlinks in some cells openpyxl - Stack Overflow
I have to generate an excel with summary results. The results are included in a list. Some of the elements are values and some links. I managed to generate the excel with the right format but not More on stackoverflow.com
Trying to open a hyperlink in excel with python
To open a hyperlink you need to use the webbrowser module. import webbrowser url = ws.cell(row=1, column=2).hyperlink.target webbrowser.open(url) https://docs.python.org/3/library/webbrowser.html More on reddit.com
3
2
January 27, 2022python - Create a hyperlink to a different Excel sheet in the same workbook - Stack Overflow
I'm assuming the issue lies in the value of 'link_to'; however, I don't know what would need changed or what kind of path I would have to write. I'm using Python 2.7.6 and Excel 2013. More on stackoverflow.com
e-iceblue
e-iceblue.com › Tutorials › Python › Spire.XLS-for-Python › Program-Guide › Link › Python-Add-Hyperlinks-to-Excel.html
Python: Add Hyperlinks to Excel
This article explains how to insert text hyperlinks and image hyperlinks in Excel using Python.
Microsoft Support
support.microsoft.com › en-us › excel › python › introduction-to-python-in-excel
Introduction to Python in Excel | Microsoft Support
Python in Excel calculations run in the Microsoft Cloud with a standard version of the Python language. Python in Excel comes with a core set of Python libraries provided by Anaconda through a standard, secure distribution. To learn more, see Data security and Python in Excel. You don't need a local version of Python to use Python in Excel.
Top answer 1 of 2
4
The XlsxWriter write_url() method allows you to link to folders or other workbooks and worksheets as well as internal links and links to web urls. For example:
import xlsxwriter
workbook = xlsxwriter.Workbook('links.xlsx')
worksheet = workbook.add_worksheet()
worksheet.set_column('A:A', 50)
# Link to a Folder.
worksheet.write_url('A1', r'external:C:\Temp')
# Link to a workbook.
worksheet.write_url('A3', r'external:C:\Temp\Book.xlsx')
# Link to a cell in a worksheet.
worksheet.write_url('A5', r'external:C:\Temp\Book.xlsx#Sheet1!C5')
workbook.close()
See the docs linked to above for more details.
2 of 2
1
Here is the code that did the trick:-
# Creates hyperlink in existing workbook...
def set_hyperlink():
from openpyxl import load_workbook
x = "hyperlink address"
wb = load_workbook("filename.xlsx")
ws = wb.get_sheet_by_name("sheet_name")
ws.cell(row = x?, column = y?).hyperlink = x
wb.save("filename.xlsx")
set_hyperlink()
Tried again with openpyxl as advised.
Top answer 1 of 4
28
This works for me:
wbook.active['A8'].hyperlink = "http://www.espn.com"
wbook.active['A8'].value = 'ESPN'
wbook.active['A8'].style = "Hyperlink"
2 of 4
23
If wanting to use Excel's built in hyperlink function directly, you can use the following to format as a link:
'=HYPERLINK("{}", "{}")'.format(link, "Link Name")
e.g. ws.cell(row=1, column=1).value = '=HYPERLINK("{}", "{}")'.format(link, "Link Name")
Medium
medium.com › @alice.yang_10652 › add-update-extract-or-delete-hyperlinks-in-excel-with-python-168efce7f73d
Add, Update, Extract or Delete Hyperlinks in Excel with Python | by Alice Yang | Medium
June 20, 2024 - In addition to text-based hyperlinks, Spire.XLS for Python also enables you to create image hyperlinks, allowing you to transform images in your Excel worksheets into clickable links.
GitHub
gist.github.com › zachschillaci27 › 887c272cbdda63316d9a02a770d15040
Extract URLs from hyperlinks in Excel using openpyxl and pandas · GitHub
Extract URLs from hyperlinks in Excel using openpyxl and pandas - extract_hyperlinks_from_excel.py
Google Groups
groups.google.com › g › python-excel › c › DQYBUletleQ
Hyperlink to a file in excel using python
> > I am using xlwt module. Example code below: > > link= 'abcd.html' > sheet.write(x, y, link, format_style) Have you searched for "hyperlink" in this group's archive? Have you read the section on Hyperlinks in the tutorial available from http://www.python-excel.org ?
DataCamp
datacamp.com › tutorial › python-excel-tutorial
Python Excel Tutorial: Read, Write & Format Excel With openpyxl | DataCamp
June 3, 2026 - A complete guide to openpyxl for Python developers. Read and write Excel files, create charts, apply cell formatting, and automate Excel workflows from Python.
e-iceblue
e-iceblue.com › Tutorials › Python › Spire.XLS-for-Python › Program-Guide › Link › Python-Extract-Modify-or-Remove-Hyperlinks-in-Excel.html
Python: Extract, Modify or Remove Hyperlinks in Excel
There are instances where you may need to manage hyperlinks in Excel files, such as extracting hyperlinks for further analysis, modifying existing links, or removing them entirely. In this article, we will introduce how to extract, modify, and remove hyperlinks in Excel in Python using Spire.XLS ...
Python Forum
python-forum.io › thread-20041.html
How to add hyperlink to existing Excel file
Hi, I have below the main table (both table are (csv): grp1 grp2 grp Date grp1_1 grp1_2 Date grp2_1 grp2_2 grp2_3 AHJ 20191/7/1 1/3 2/5 20191/7/1 2/5 3/3 2/6 AKL ...
Reddit
reddit.com › r/learnpython › trying to open a hyperlink in excel with python
r/learnpython on Reddit: Trying to open a hyperlink in excel with python
January 27, 2022 -
Hello,
I have an excel file with hyperlinks (these hyperlinks lead to a website). I want to python to open one of the hyperlinks. When I execute the script I would expect the websites to open in Microsoft edge, but instead, nothing happens. Here is my code:
import openpyxl
wb = openpyxl.load_workbook("C:\\Users\\rfog\\OneDrive\\Documents\\Python Excel\\pythontest.xlsx")
ws = wb['Sheet1']
ws.cell(row=1, column=2).hyperlink.target
Any suggestions?
Top answer 1 of 2
1
To open a hyperlink you need to use the webbrowser module. import webbrowser url = ws.cell(row=1, column=2).hyperlink.target webbrowser.open(url) https://docs.python.org/3/library/webbrowser.html
2 of 2
1
I want to python to open one of the hyperlinks. u mean open in a "normal" browser?
Top answer 1 of 8
30
I found a way to do it.
Assuming one .xlsx file named 'workbookEx.xlsx' with two sheets named 'sheet1' and 'sheet2' and needing a link from one cell(A1) of the 'sheet1' to another cell(E5) of the 'sheet2':
from openpyxl import load_workbook
wb = load_workbook(workbookEx.xlsx)
ws = wb.get_sheet_by_name("sheet1")
link = "workbookEx.xlsx#sheet2!E5"
ws.cell(row=1, column=1).hyperlink = (link)
The secret was the "#", Excel do not shows you but it uses the '#' for same file links, I just had to copy a same file link created in Excel to a Word document to see the '#'.
It is also possible to omit the filename, i.e. to link against a sheet of the active document just use: _cell.hyperlink = '#sheetName!A1'.
To name the link you just created, just set the cell value to the desired string: _cell.value = 'Linkname'.
2 of 8
4
As an addendum to Marcus.Luck's answer, if wanting to use Excel's built-in hyperlink function directly, you may need to format as:
'=HYPERLINK("{}", "{}")'.format(link, "Link Name")
Without this formatting, the file didn't open for me without needing repair, which removed the cell values when clicking the links.
e.g. ws.cell(row=1, column=1).value = '=HYPERLINK("{}", "{}")'.format(link, "Link Name")
Medium
medium.com › @markchen69 › integrating-python-into-excel-a-new-era-of-data-analysis-211e25377693
Integrating Python into Excel: A New Era of Data Analysis | by Mark Chen | Medium
November 7, 2024 - Traditionally, Excel has struggled with handling large datasets efficiently and lacked the ability to perform complex statistical analysis and machine learning. By embedding Python, Microsoft addresses these limitations, offering a more powerful solution for data analysis within a familiar interface.
Data to Fish
datatofish.com › read_excel
How to Import an Excel File Into Python using pandas
Let's say, you have an excel file named fish.xlsx on your desktop that contains the following data: Create a Python script that loads the excel file into a pandas DataFrame and prints it to the terminal:
Microsoft Support
support.microsoft.com › en-us › excel › python › get-started-with-python-in-excel
Get started with Python in Excel | Microsoft Support
Get started using Python functions directly within your Excel spreadsheet data.
Google Groups
groups.google.com › g › python-excel › c › ODQvunP6NsU
Hyperlinks to particular sheet and cell in a different workbook
John Machin wrote: >> > You type into your sourcefile editor exactly what >> > you would type into Excel · ashu_104 wrote: >> Thanks for the reply i already tried doing that, >> as Google specifies the formula for the hyperlink >> turns out to be: >> >> =HYPERLINK("[book1.xls]Sheet2!A1","CLICK HERE") >> >> which i write in my python code as: >> sheet.write(100,1,xlwt.Formula('HYPERLINK("[book1.xls]sheet2!
Stack Overflow
stackoverflow.com › questions › 57877458 › how-to-use-python-to-retrieve-an-url-from-an-excel-column-and-then-open-it-with
How to use python to retrieve an url from an excel column and then open it with chrome and login password? - Stack Overflow
September 11, 2019 - import pandas as pd exceldata = pd.read_excel("file.xlsx",sheet_name = "sheet1") for idx in exceldata.index: print(exceldata['links'][idx])) ## Do your selenium tasks here for opening and logging into the fetched link.