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
CODEBLOCK0
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: INLINECODE0
csvglow
从任何CSV或Excel文件生成美观、交互式的HTML仪表盘。自动检测列类型和关系,生成智能多列洞察、直方图、条形图、交叉分析列联表、时间序列、相关性热力图、散点图以及可排序的数据表格——全部集成在一个自包含的HTML文件中,并采用深色渐变主题。
当用户希望以下操作时使用此技能:
- - 可视化CSV或Excel文件
- 从表格数据创建仪表盘
- 以可视化方式探索或分析数据集
- 从电子表格生成图表
- 获取数据洞察
使用方法
bash
csvglow <文件> # 生成仪表盘并在浏览器中打开
csvglow data.csv # CSV文件
csvglow report.xlsx # Excel文件
csvglow data.csv -o dashboard.html # 自定义输出路径
csvglow data.csv --no-open # 不自动打开浏览器
生成内容
- - 智能洞察:多列叙事分析,交叉引用指标(例如:产品Y折扣最高,但成本最低的情况下收入却最低——建议考虑停产)
- 汇总统计:行数、列数、数据类型、缺失值
- 数值列:带统计信息侧边栏的直方图(均值、中位数、标准差、四分位数、异常值数量)
- 分类列:前N个值的渐变条形图
- 交叉分析:自动生成分类×数值列联表,附带总体均值线
- 日期列:带面积填充的时间序列折线图
- 相关性热力图:自动检测数值列之间的相关性
- 散点图:为高相关性对(|r| > 0.7)自动生成
- 数据表格:前1000行可排序、可筛选的预览
- 复制按钮:每个图表都配有复制按钮,方便粘贴到幻灯片中
注意事项
- - 输出为自包含HTML文件——无需服务器、无需CDN,可离线使用
- 支持CSV、TSV、XLS和XLSX文件
- 自动检测分隔符和编码
- 大文件(10万行以上)会智能采样用于可视化,同时保留完整统计数据
- 也可作为MCP服务器使用:csvglow --mcp