MCP Excel
未认领MCP server for AI agents to analyze Excel spreadsheets through atomic operations. Like SQL for Excel. Fast, accurate, and efficient. No context overflow.
安装
pip install -e .工具（25 个）
aggregate
Perform aggregation with optional filters (8 operations).
analyze_overlap
Venn diagram analysis - intersections, unions, exclusive zones.
calculate_expression
Arithmetic expressions between columns.
calculate_moving_average
Smoothing with specified window size.
calculate_period_change
Period-over-period growth analysis.
calculate_running_total
Cumulative sum with optional grouping.
compare_sheets
Diff between two sheets using key column.
correlate
Correlation matrix between 2+ columns.
detect_outliers
Anomaly detection using IQR or Z-score.
filter_and_count
Count rows matching conditions with 14 operators.
filter_and_count_batch
Classify data into multiple categories in one call (6x faster).
filter_and_get_rows
Retrieve filtered rows with pagination.
find_column
Locate column across multiple sheets.
find_duplicates
Detect duplicate rows by specified columns.
find_nulls
Find null/empty values with detailed statistics.
get_column_names
Quick column enumeration without loading full data.
get_column_stats
Statistical summary - count, mean, median, std, quartiles.
get_data_profile
Comprehensive column profiling - types, stats, nulls, top values.
get_sheet_info
Detailed sheet analysis with auto-header detection.
get_unique_values
Extract unique values from a column.
get_value_counts
Frequency analysis - top N most common values.
group_by
Pivot table with multi-column grouping.
inspect_file
Get file structure overview - sheets, dimensions, format.
rank_rows
Rank by column value with top-N filtering.
search_across_sheets
Search value across all sheets.