img/favicon.ico" />
MyNew Technologies

How to judge whether a spreadsheet is ready to replace

A spreadsheet may contain workflow rules and approval history that are easy to overlook.

What to do

  1. List who maintains it, who receives its exports, and what other tools use the information.
  2. Review a few real rows with staff to identify formulas, manual overrides and exceptions that must be supported.
  3. Try the replacement with a controlled sample and verify outputs with each person who receives them before retiring the old file.

Reference: Microsoft guide to preparing for modernization.

Related MyNew service: Digital Transformation.