csvglow

# 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 ```bash 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`