Migrating Excel Workflows to Python: What to Move, What to Keep, and Where the Code Should Run
· 6 min read
“Move this spreadsheet to Python” sounds like a technical task, but the difficult decision is architectural: which parts of the workflow should move at all?
A mature workbook can contain formulas, Power Query steps, VBA, manual procedures, external data connections, review controls, and business rules that users understand precisely because they are visible in Excel. Replacing all of that with Python can make the result less maintainable.
A better migration starts by separating the workflow into responsibilities.