{"slug":"ishayoyo/excel-mcp","name":"Excel/CSV MCP Server","description":"Read, analyze, and manipulate data in Excel (XLSX, XLS) and CSV files with advanced filtering and analytics.","category":"file-system","tags":[],"official":false,"stars":33,"transport":"stdio","install":[{"cmd":"npx (No","imports":[]}],"tools":[{"name":"read_file","description":"Read an entire Excel or CSV file"},{"name":"get_cell","description":"Get the value of a specific cell"},{"name":"get_range","description":"Get values from a range of cells"},{"name":"get_headers","description":"Get column headers from a file"},{"name":"search","description":"Search for values in a file"},{"name":"filter_rows","description":"Filter rows based on criteria"},{"name":"aggregate","description":"Perform aggregation operations like sum on columns"},{"name":"read_file_chunked","description":"Stream large files (100MB+) in chunks"},{"name":"get_file_info","description":"Get metadata about a file"},{"name":"write_file","description":"Create an Excel or CSV file"},{"name":"add_sheet","description":"Add a new sheet to an existing workbook"},{"name":"write_multi_sheet","description":"Create a multi-sheet workbook with formulas"},{"name":"export_analysis","description":"Export analysis results to a file"},{"name":"format_cells","description":"Apply formatting to cells"},{"name":"auto_fit_columns","description":"Auto-fit column widths"},{"name":"statistical_analysis","description":"Perform statistical analysis on data"},{"name":"correlation_analysis","description":"Perform correlation analysis between columns"},{"name":"data_profile","description":"Generate a data profile of a file"},{"name":"pivot_table","description":"Create a pivot table from data"},{"name":"dcf_analysis","description":"Perform discounted cash flow (DCF) valuation"},{"name":"budget_variance_analysis","description":"Analyze budget vs actual variances"},{"name":"ratio_analysis","description":"Perform financial ratio analysis"},{"name":"scenario_modeling","description":"Run what-if scenario modeling"},{"name":"trend_analysis","description":"Perform trend analysis on data"},{"name":"find_duplicates","description":"Find duplicate rows in a file"},{"name":"data_cleaner","description":"Clean data (fix dates, phones, names)"},{"name":"vlookup_helper","description":"Perform cross-file lookups similar to VLOOKUP"},{"name":"bulk_aggregate_multi_files","description":"Aggregate data across multiple files"},{"name":"bulk_filter_multi_files","description":"Filter data across multiple files"},{"name":"validate_data_consistency","description":"Check cross-file referential integrity"},{"name":"evaluate_formula","description":"Evaluate a formula"},{"name":"parse_natural_language","description":"Convert natural language to a formula"},{"name":"explain_formula","description":"Explain what a formula does"},{"name":"smart_data_analysis","description":"Perform AI-powered data analysis"},{"name":"ai_provider_status","description":"Check the status of AI providers"}],"env_vars":["ANTHROPIC_API_KEY","OPENAI_API_KEY","DEEPSEEK_API_KEY","GEMINI_API_KEY"],"auth_type":"none","github":"https://github.com/ishayoyo/excel-mcp","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Thu May 28"}