Spreadsheet applications are OFTEN terrible and misused. But spreadsheet FILES are everywhere! As one of the default forms of data exchange, learning to work with spreadsheet files directly via Python can save time and effort. We'll look at Openpyxl, a library that lets you do just that.

We'll start by looking at two basic uses. First we'll read data from a spreadsheet file to use in a Python program. Then we'll write results from a Python program to a spreadsheet.

Next, we'll look at two different (beginner-friendly) example cases: transforming one spreadsheet into another spreadsheet (an application of what we learned in the first step) and converting a spreadsheet into JSON.

I'll also use my experience as a former accountant (aka "Spreadsheet Wrangler") to highlight some of the practical 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!