Excel

소개

Excel is an MCP server designed to enable AI agents to perform comprehensive analysis on Excel files (.xls and .xlsx) using atomic primitives, all without requiring the raw data to be loaded into the agent's context. It allows agents to execute a wide array of operations, from basic filtering and aggregation to advanced statistical and time series analysis. This tool streamlines spreadsheet intelligence for AI agents, allowing them to extract insights, validate data, and compare sheets efficiently, and even generate Excel formulas and TSV outputs for easy integration into spreadsheets.

주요 기능

• Analyze any Excel file (.xls and .xlsx) without opening Excel
• Filter and search data with 12 operators (==, !=, >, <, in, contains, regex, etc.)
• Aggregate and group data (sum, average, count, pivot tables)
• Perform statistical analysis (correlations, outliers, distributions)
• Conduct time series analysis (period-over-period growth, moving averages, running totals)
• 1 GitHub stars

사용 사례

• Analyze the Excel file at C:/Users/YourName/Documents/sales.xls to identify key performance indicators.
• Show top 10 customers by revenue from sales.xlsx to understand customer segmentation.
• Find duplicates in the 'Email' column in contacts.xlsx for data cleaning and validation.