Python & spreadsheets: 2017 edition on Nov. 18, 2017 at 11:10 a.m. in R-M120

Spreadsheets are OFTEN terrible. They're also everywhere! As one of the default forms of data exchange, learning to work with spreadsheets directly via Python can save time and effort. We'll look at Openpyxl, a library that lets you do just that. We'll look at at least two different (beginner-friendly)example cases: transforming one spreadsheet into another spreadsheet and converting a spreadsheet into JSON. I'll also use my experience as a former accountant to highlight some of the issues around reading from and writing to a spreadsheet file and how you might deal with them. You MAY even learn to make new friends and grow the Python community! True Story!


Kojo Idrissa

Kojo Idrissa was an accountant who got an MBA and taught at university in two different countries. He's now a new(ish) software engineer and is still trying to figure that out and grow into the role. He's spoken at tech conferences about spreadsheets, contributing to tech communities, Dungeons & Dragons, inclusion and privilege. You can find him online at or as @transition on Twitter. He knows WAY more about K-Pop than you.