dvcrn csvglow
Generate a beautiful, interactive HTML dashboard from any CSV or Excel file. Auto-detects column types and relationships, generates smart multi-column insights, histograms, bar charts, cross-analysis crosstabs, time series, correlation heatmaps, scatter plots, and a sortable data table — all in a single self-contained HTML file with a dark gradient theme.
Use this skill when the user wants to:
- Visualize a CSV or Excel file
- Create a dashboard from tabular data
- Explore or analyze a dataset visually
- Generate charts from a spreadsheet
- Get insights about their data
Usage
csvglow <file> # Generate dashboard and open in browser
csvglow data.csv # CSV file
csvglow report.xlsx # Excel file
csvglow data.csv -o dashboard.html # Custom output path
csvglow data.csv --no-open # Don't auto-open browser
What it generates
- Smart insights: Multi-column narrative analysis that cross-references metrics (e.g. "Gadget Y has the highest discount yet lowest revenue despite lowest cost — consider discontinuing")
- Summary stats: Row count, column count, data types, missing values
- Numeric columns: Histograms with stats sidebar (mean, median, std, quartiles, outlier count)
- Categorical columns: Gradient bar charts of top values
- Cross analysis: Automatic categorical x numeric crosstabs with overall mean lines
- Date columns: Time series line charts with area fill
- Correlation heatmap: Auto-detected correlations between numeric columns
- Scatter plots: Auto-generated for highly correlated pairs (|r| > 0.7)
- Data table: Sortable, filterable preview of first 1000 rows
- Copy button: Each chart has a "Copy" button for pasting into slide decks
Notes
- Output is a self-contained HTML file — no server, no CDN, works offline
- Supports CSV, TSV, XLS, and XLSX files
- Auto-detects delimiters and encodings
- Large files (100k+ rows) are smart-sampled for visualizations while keeping full stats
- Also available as an MCP server:
csvglow --mcp