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 \x3Cfile>                       # 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