working with excel files introduction this introduces the openpyxl module that can be used when working with excel files excel is software application developed by microsoft that allows users to work with spreadsheets it is very widely used tool and files using the excel file format are commonly encountered within many organisations it is in effect the industry standard for spreadsheets and as such is very useful tool to have in the developers toolbox excel files although csv files are convenient and simple way to handle datait is very common to need to be able to read or write excel files directly to this end there are several libraries available in python for this purpose one widely used library is the openpyxl library this library was originally written to support access to excel files it is an open source project and is well documented the openpyxl library provides facilities for reading and writing excel workbookscreating/accessing excel worksheetscreating excel formulascreating graphs (with support from additional modulesas openpyxl is not part of the standard python distribution you will need to install the library yourself using tool such as anaconda or pip ( pip install openpyxlalternativelyif you are using pycharm you will be able to add the openpyxl library to your project (cspringer nature switzerland ag huntadvanced guide to python programmingundergraduate topics in computer science