2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Built an open-source Excel structural risk analyzer - looking for feedback from model builders

Hi everyone,

I recently built an open-source tool called XLChek, and I’m looking for technical feedback from experienced Excel users and model builders.

XLChek is a read-only Excel structural diagnostics tool.

It scans .xlsx files offline and generates an HTML report highlighting structural risks in spreadsheets.

It focuses specifically on structural and dependency issues such as:

  • Circular references
  • Hard-coded constants inside formulas
  • Volatile functions (NOW, OFFSET, INDIRECT, etc.)
  • Formula drift across ranges
  • Whole column / row references
  • External workbook references
  • Orphan calculations (formulas not referenced by other formulas)

It does not validate business logic or financial correctness.

It strictly evaluates structural integrity and dependency risk.

The motivation came from seeing operational and financial spreadsheets fail silently due to hidden structural issues — especially in models that evolve over time.

Key characteristics:

  • Runs completely offline
  • No data upload
  • Read-only analysis
  • Generates HTML and JSON output
  • Cross-platform (Windows / macOS / Linux)

This is an early release (v0.1.0), and I would genuinely appreciate feedback:

  • Are these structural checks useful in real workflows?
  • What important risk patterns am I missing?
  • Would this help in financial modeling, audit, or operational contexts?
  • Where would you expect this tool to fit in your process?

GitHub repository:

https://github.com/gridgrok-collab/XLChek

I’m especially interested in critical feedback from advanced Excel users.

Thanks in advance.

Note: Currently requires Python 3.10–3.12 to run (technical preview release).

submitted by /u/Aggressive_Rise9792
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel compatibility
#financial modeling
#natural language processing for spreadsheets
#generative AI for data analysis
#big data management in spreadsheets
#rows.com
#real-time data collaboration
#AI-native spreadsheets
#conversational data analysis
#predictive analytics in spreadsheets
#AI formula generation techniques
#business intelligence tools
#row zero
#automation in spreadsheet workflows
#intelligent data visualization
#XLChek
#Excel
#structural risk