CSV Analytics Dashboard - Python App with AI Analysis, PDF Export & Charts | Data Tool for Excel Users

Transform any CSV file into a professional analytical dashboard in seconds.
Whether you are an entrepreneur, analyst, accountant or project manager, this Python tool allows you to visualize your data instantly — without configuration, without programming skills to use it.

WHAT THE APP DOES
Import your CSV file and automatically get:
5 smart charts automatically generated based on your data (time curve, bar chart, pie chart, scatter plot, grouped bar chart)
AI analytics — connect your OpenAI or Anthropic API key (Claude) to get business insights in natural language: trends, anomalies, concrete recommendations
Anomaly detection — the application automatically identifies missing values and statistical outliers, with visualization in red.
Period comparison — compare two date ranges side by side with percentage change
Custom chart creator — 6 chart types (bar, line, scatter, pie, box and whisker, histogram) with one-click axis selection
Professional PDF export — complete report with key metrics, AI analysis, and all charts, ready to send to a client or manager
Multi-file merge — import 2 to 4 CSV files and merge them by stacking or joining on a common column
Bilingual interface — switch between English and French with one click
Dark mode — compatible with your system's night mode
Dynamic filters — filter by date range and category; all charts update in real time

COMPATIBLE WITH ALL TYPES OF DATA
The application automatically detects date, numeric, and categorical columns in any CSV file:

Sales data and revenue
Survey results and customer feedback
Accounting and financial exports
Marketing data (campaigns, clicks, conversions)
E-commerce exports (Shopify, WooCommerce, etc.)
HR reports, inventory, logistics
Any table exported from Excel or Google Sheets


WHAT IS INCLUDED
app.py — complete source code (approximately 1100 lines, well-structured and commented)
translations.py — bilingual support EN/FR
5 sample CSV files for immediate testing (e-commerce, sales, marketing, customer feedback, quarterly data)
README.md — complete documentation with installation instructions

INSTALLATION IN 2 MINUTES

Unzip the folder
Run: pip install -r requirements.txt
Run: python -m streamlit run app.py
The application opens automatically in your browser

System requirements: Python 3.9+, Windows / Mac / Linux

AI ANALYSIS (optional)
Bring your own OpenAI or Anthropic API key. The application never stores your key. Estimated cost: approximately €0.01 per analysis with GPT-4o mini or Claude Haiku.

LICENSE
Single-user license. Personal and commercial use permitted. Resale of the source code is prohibited.

SUPPORT
A question? A technical problem? Contact me directly via Etsy, I respond within 24 hours.