Excel Empty Cell Finder

Simple Python script that scans an .xlsx file and reports all empty cells.

What it does

• Lists Excel files in the current directory
• Lets you choose one
• Scans all sheets
• Detects empty cells (None values only)
• Outputs results to a text file

Requirements

• Python 3
• openpyxl

Install dependency:

• pip install openpyxl

Usage

• Place the script in a folder with .xlsx files
• Run: python script.py Enter the number of the file you want to scan
• Output A file named: .xlsx_report.txt
• Format: Sheet1: A1 B3 D10

Notes

• Only truly empty cells (None) are counted
• Cells with 0, False, or text are NOT considered empty

Limitations

• Scans full sheet range (can be slow on large files)
• No filtering or formatting options yet