A powerful, self-contained Excel analysis dashboard — load any file, get instant insights.
The tool automatically detects which columns contain dates, amounts, categories, and labels — no manual setup required. Works with virtually any Excel or CSV file.
| Page | Description |
|---|---|
| 🏠 Overview | KPI cards: total, average, count, top entry |
| 📋 Table | Searchable, filterable data table |
| 📅 Month / Year | Aggregations by day, month, quarter, year |
| 🏷️ Categories | Breakdown by category with % share |
| 📊 Charts | Pie, bar, and line charts |
| 📤 Export | Export filtered data as Excel or PDF |
pip install customtkinter pandas matplotlib openpyxl fpdf2python main_universal.pypip install pyinstaller
pyinstaller --onefile --windowed main_universal.py- Open any
.xlsx,.xls, or.csvfile - The tool auto-detects date, amount, category, and label columns
- Navigate through the dashboard using the sidebar
- Filter and search data in the table view
- Export results as Excel (multi-sheet) or PDF report
The tool identifies column types using a layered approach:
- Date columns: detected via
datetime64dtype, keyword matching (datum,date,monat, ...), or content pattern matching (DD.MM.YYYY,YYYY-MM-DD) - Amount columns: detected via numeric dtype or content (≥70% parseable as float)
- Category columns: text columns with low cardinality (2–50 unique values), keyword-prioritized
- Label columns: remaining text columns, prioritized by string length
└── main_universal.py # Self-contained app (GUI + logic + export)
- Python 3.8+
- Pandas – data processing & aggregation
- CustomTkinter – modern dark-mode GUI
- Matplotlib – embedded interactive charts
- OpenPyXL – multi-sheet Excel export
- fpdf2 – styled PDF export
- Financial expense analysis for small businesses
- Sales reporting from CRM exports
- Budget tracking and monthly overviews
- Quick data exploration without Excel formulas
Need a custom data analysis tool for your business? Let's talk!
Built with ❤️ by [Goci13] — Open to freelance projects