CSV Column Statistics
Calculate numeric and uniqueness statistics for one column
CSV Column Statistics — what it does
Select one column and this tool profiles it: how many values are numeric, how many cells are empty, how many distinct values exist, and for numeric data the sum, average, minimum and maximum. It is the first look you want at an unfamiliar dataset, before writing a formula that assumes the column is clean.
When this tool helps
- Checking an amount column for blanks and text entries before trusting a total from it.
- Measuring cardinality — whether a field is a genuine identifier or repeats across thousands of rows.
- Spotting an implausible minimum or maximum that points to a data entry or unit error.
How to use it
- Choose the CSV file.
- Select the column to analyse.
- Process the file.
- Read the numeric, empty and unique counts alongside the summary statistics.
Accuracy, limits, and good practice
- If the numeric count is lower than the row count, some cells contain text, currency symbols or thousands separators that break arithmetic.
- Average is sensitive to extremes; when minimum and maximum are far apart, check the outlier detector before quoting the mean.
- Unique value counts include differences in case and whitespace, so Paris and paris are counted as two distinct values.
Frequently asked questions
Are empty cells counted in the average?
No. Only parseable numeric values contribute to sum and average, which is why the numeric count is worth reading first.
Can I profile several columns at once?
Run the tool per column. To classify every column at a glance, the column type detector gives a whole-file overview.
Does it compute a median?
Not here. The Excel column statistics tool reports a median alongside the other measures if you need it.
Related tools on this site
- CSV Group & Aggregate — Group rows and calculate sum, average, count, min, or max
- Excel Blank Row & Column Cleaner — Trim cell text and remove completely blank rows and columns
- Excel Workbook Viewer — Open XLSX or XLS files, switch worksheets, search values, and preview cells locally
Everything above runs inside this page. CSV Column Statistics needs no account, no upload, and no server round trip — close the tab and nothing is left behind.
CSV 欄位統計能做什麼
選定一個欄位，工具會為它做剖析：有多少值是數字、多少儲存格為空、有多少不重複值，數值資料還會給出總和、平均、最小與最大值。在對陌生資料寫下任何假設欄位很乾淨的公式之前，這是你該先看的第一眼。
什麼時候用得上
- 在相信金額欄的總計之前，先檢查其中是否夾雜空白與文字。
- 衡量欄位的離散度，判斷它是真正的識別碼，還是在數千列中不斷重複。
- 找出不合理的最小或最大值，那通常指向輸入錯誤或單位錯誤。
使用步驟
- 選擇 CSV 檔案。
- 選定要分析的欄位。
- 執行處理。
- 查看數值筆數、空白筆數、不重複值與各項統計。
精確度、限制與實務建議
- 若數值筆數少於總列數，代表有些儲存格含文字、貨幣符號或千分位逗號，會讓運算失效。
- 平均值容易被極端值拉走；最小與最大值差距很大時，建議先用離群值偵測工具檢查再引用平均。
- 不重複值計數會區分大小寫與空白，因此 Paris 與 paris 會被算成兩個不同的值。
常見問題
空白儲存格會算進平均嗎？
不會。只有可解析的數值才計入總和與平均，這也是要先看數值筆數的原因。
可以一次分析多個欄位嗎？
請逐欄執行。若想快速掌握每一欄的類型，可用欄位類型偵測工具看整份檔案的概況。
會算中位數嗎？
此工具不含中位數。需要的話，Excel 欄位統計工具會一併提供中位數。
本站相關工具
- CSV 分組彙總 — 依欄位分組並計算加總、平均、計數、最小或最大值
- Excel 空白行列清理 — 清理儲存格前後空格，並刪除完全空白的行與列
- Excel 活頁簿檢視器 — 在本地開啟 XLSX 或 XLS、切換工作表、搜尋內容並預覽儲存格
以上步驟全部在這個頁面內完成，CSV 欄位統計 不需要註冊、不上傳檔案、也不經過伺服器，關閉分頁後不會留下任何資料。