Excel/CSV MCP Server

Tools · 35

• read_file Read an entire Excel or CSV file
• get_cell Get the value of a specific cell
• get_range Get values from a range of cells
• get_headers Get column headers from a file
• search Search for values in a file
• filter_rows Filter rows based on criteria
• aggregate Perform aggregation operations like sum on columns
• read_file_chunked Stream large files (100MB+) in chunks
• get_file_info Get metadata about a file
• write_file Create an Excel or CSV file
• add_sheet Add a new sheet to an existing workbook
• write_multi_sheet Create a multi-sheet workbook with formulas
• export_analysis Export analysis results to a file
• format_cells Apply formatting to cells
• auto_fit_columns Auto-fit column widths
• statistical_analysis Perform statistical analysis on data
• correlation_analysis Perform correlation analysis between columns
• data_profile Generate a data profile of a file
• pivot_table Create a pivot table from data
• dcf_analysis Perform discounted cash flow (DCF) valuation
• budget_variance_analysis Analyze budget vs actual variances
• ratio_analysis Perform financial ratio analysis
• scenario_modeling Run what-if scenario modeling
• trend_analysis Perform trend analysis on data
• find_duplicates Find duplicate rows in a file
• data_cleaner Clean data (fix dates, phones, names)
• vlookup_helper Perform cross-file lookups similar to VLOOKUP
• bulk_aggregate_multi_files Aggregate data across multiple files
• bulk_filter_multi_files Filter data across multiple files
• validate_data_consistency Check cross-file referential integrity
• evaluate_formula Evaluate a formula
• parse_natural_language Convert natural language to a formula
• explain_formula Explain what a formula does
• smart_data_analysis Perform AI-powered data analysis
• ai_provider_status Check the status of AI providers