What delimiters does the CSV analyzer support?

It supports four common delimiters: comma (,), semicolon (;), Tab (\t), and pipe (|). The default "Auto Detect" mode intelligently determines which delimiter is being used based on the data content. You can also manually specify the delimiter.

How are column data types determined?

The tool analyzes non-empty values in each column. If over 80% of values are numbers, it's classified as numeric. If values match date patterns, it's classified as a date column. Columns with only true/false/yes/no values are boolean. Everything else is classified as text.

How are mean and median calculated?

The mean is the arithmetic average of all numeric values in the column. The median is the middle value when sorted (or the average of the two middle values for even counts). These statistics are only calculated for numeric columns. Text and date columns display min/max values (in lexicographic order).

Is my data uploaded to any server?

No. All CSV parsing and statistical analysis is performed locally in your browser. Your data never leaves your device. You can safely use this tool even while offline.

CSV Analyzer

CSV Data Statistical Analysis

Upload CSV File

Delimiter: First Row is Header: Preview Rows:

CSV Input

Analysis Report

CSV Data Analysis Tool Guide

Key Features

Auto Delimiter Detection — intelligently identifies comma, semicolon, Tab, and pipe delimiters
Column Type Detection — automatically identifies numeric, text, date, and boolean columns
Statistical Analysis — empty count, unique values, min/max, mean, and median
Data Preview — quickly preview the first N rows
Export Report — export analysis results as a text report

Use Cases

Preliminary data exploration and quality checks before cleaning
Quickly understanding CSV file structure and distribution
Detecting outliers and missing values in data
Creating data overview reports for handoffs

CSV Analyzer

CSV Data Analysis Tool Guide

Key Features

Use Cases

常见问题

相关工具