AI Spreadsheet Analyst

A small Flask app that turns CSV/XLSX uploads into an automated analysis report with data quality checks, column profiles, recommendations, preview tables, and Plotly charts.

Features

• Upload .csv, .xlsx, or .xls files
• Automatic dataset summary
• Missing value, duplicate row, and header quality checks
• Column-level profiling and plain-language insights
• Auto-generated Plotly charts
• Downloadable standalone HTML report
• Included sample dataset

Quick Start

python -m venv .venv
.\.venv\Scripts\Activate.ps1
pip install -r requirements.txt
python app.py

Open http://127.0.0.1:5000 in your browser.

Project Structure

ai-spreadsheet-analyst/
  app.py
  analyst.py
  requirements.txt
  templates/
  static/
  samples/

Notes

This project uses deterministic rules for "AI-style" analysis so it can run locally without API keys. You can later connect an LLM API in analyst.py to turn the computed profiles into richer narrative commentary.