Skip to content

About

A conservative local CSV scanner that flags cells beginning with spreadsheet formula characters and can write a sanitized copy with a leading apostrophe. The original file is never modified.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

4 Commits

Folders and files

Repository files navigation

CSV Formula Guard banner Typing title

License Language Stars Last commit

CSV Formula Guard illustration

🧭 Overview

A conservative local CSV scanner that flags cells beginning with spreadsheet formula characters and can write a sanitized copy with a leading apostrophe. The original file is never modified.

✨ Features

  • ✅ Scans every CSV cell and reports row and column
  • ✅ Flags values beginning with =, +, -, or @ after whitespace
  • ✅ Can write a separate apostrophe-prefixed sanitized copy
  • ✅ Uses Python's CSV parser and preserves table structure

🎬 Demo

python main.py scan examples/untrusted.csv

The example runs locally; no hosted service or upload is required.

🚀 Quick Start

python -m pip install -r requirements.txt
python main.py scan examples/untrusted.csv

Run python main.py --help to see all supported options.

🧰 Tech Stack

  • Python 3.10+ standard library (csv)
  • Automated tests: unittest
  • Local-first processing

📁 Folder Structure

csv-formula-guard/
├── main.py
├── requirements.txt
├── tests/test_core.py
├── examples/untrusted.csv
└── assets/illustration.svg

🗺️ Roadmap

  • Core workflow and CLI
  • Example input and tests
  • Additional report formats
  • Continuous integration on supported platforms

🤝 Contributing

Issues and pull requests are welcome. Keep changes focused, document behavior changes, and add tests for new features.

📄 License

MIT - see LICENSE.

Animated wave footer

About

A conservative local CSV scanner that flags cells beginning with spreadsheet formula characters and can write a sanitized copy with a leading apostrophe. The original file is never modified.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages