Edit Excel and Google Spreadsheets with Python: An Introduction

No matter your technical level or job title, if you work in an office you probably can’t escape Excel and Google Sheets. Break free by learning how Python can automate reading and writing spreadsheets with the author of Automate the Boring Stuff with Python.

You aren’t limited to editing spreadsheets through your keyboard and mouse in Excel or Google Sheets. You can write Python scripts to automate the creation, updating, and verification of spreadsheets with the free, open source OpenPyXL and EZSheets modules. This talk covers the installation and basic features of both modules, along with common use cases and misconceptions. Most importantly, we’ll walk through cleaning up data in a spreadsheet that cannot easily be done from within the spreadsheet applications but requires the power of Python scripting.