explaingit

madara88645/sheetci

Analysis updated 2026-05-18

0PythonAudience · ops devopsComplexity · 2/5Setup · easy

TLDR

A local-first command line tool that scans Excel workbooks for risky formulas and produces audit reports, acting like a linter and CI guardrail for spreadsheets.

Mindmap

mindmap
  root((repo))
    What it does
      Scans xlsx for risky formulas
      Generates audit reports
      Runs locally or in CI
    Tech stack
      Python
      CLI
      GitHub Actions
    Use cases
      Catch broken formulas
      Review commission models
      Gate pull requests
    Audience
      Finance teams
      Developers

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

What do people build with it?

USE CASE 1

Scan a finance or commission spreadsheet for broken references and circular formulas before it ships.

USE CASE 2

Add a CI check that fails a pull request when an xlsx file contains risky formula patterns.

USE CASE 3

Generate a business-readable HTML audit report for non-technical reviewers of a spreadsheet.

What is it built with?

PythonCLI

How does it compare?

madara88645/sheetci0xallam/my-recipe0xhassaan/nn-from-scratch
Stars00
LanguagePythonPythonPython
Last pushed2022-11-22
MaintenanceDormant
Setup difficultyeasymoderatemoderate
Complexity2/52/54/5
Audienceops devopsgeneraldeveloper

Figures from each repo's GitHub metadata at analysis time.

How do you get it running?

Difficulty · easy Time to first run · 5min

Installs via pip, runs fully locally with no cloud upload or API key needed.

In plain English

SheetCI is a command line tool that checks Excel spreadsheet files for risky formulas and produces an audit report. The README describes it as a linter, tester, and continuous integration guardrail for Excel files, aimed at business spreadsheets that carry real financial weight, like commission models, pricing calculators, or budget plans, which normally do not get the same scrutiny that program code does. The idea is that a small formula change in a spreadsheet can quietly shift revenue, commission payouts, or a budget number without anyone noticing until it causes a problem. SheetCI scans a workbook for issues such as broken references, circular formulas, or hardcoded values sitting inside calculations, and produces a report before that spreadsheet gets shared, committed to a repository, or used to make a decision. It runs entirely on your own machine or inside a continuous integration pipeline, and the README is explicit that the current version does not upload workbooks anywhere, does not use a database, does not call any AI service, and does not send file contents to the cloud. To install it, you run a standard Python pip command in editable mode for local development. From there, the main command is a scan of an xlsx file, which can be pointed at a specific workbook. You can generate a plain Markdown report with the findings, an interactive HTML report meant to be readable by non-technical business reviewers, or a raw JSON summary meant for feeding into other CI or CD tooling. The project also ships its own GitHub Actions workflow, which runs its test suite, confirms that a known-clean example workbook passes, and generates reports against an example workbook that is intentionally broken to prove the checks catch real problems. That intentionally broken example is expected to fail with a nonzero exit code, since it contains findings on purpose, which is what makes it useful for verifying the tool works as a gate in an automated pipeline.

Copy-paste prompts

Prompt 1
Walk me through installing SheetCI with pip and running a scan on my own xlsx file.
Prompt 2
Explain how to set up SheetCI in a GitHub Actions workflow so pull requests with risky formulas fail CI.
Prompt 3
Show me how to generate an HTML audit report with SheetCI for a non-technical business reviewer.

Frequently asked questions

What is sheetci?

A local-first command line tool that scans Excel workbooks for risky formulas and produces audit reports, acting like a linter and CI guardrail for spreadsheets.

What language is sheetci written in?

Mainly Python. The stack also includes Python, CLI.

How hard is sheetci to set up?

Setup difficulty is rated easy, with roughly 5min to a first successful run.

Who is sheetci for?

Mainly ops devops.

Open on GitHub → Explain another repo

This repo across BitVibe Labs

Verify against the repo before relying on details.