Extract data from Excel (xlsx) files into structured JSON format with a specified file path. Ideal for accessing workbook or sheet content programmatically.
Perform statistical analysis on Excel files, extracting insights from specified columns or sheets, and return results in JSON format for easy interpretation.
Extract specific data from Excel files using a pandas query string. Specify file path, query conditions, and sheet name to filter and return targeted information for analysis.
Convert and save CSV or JSON data into an Excel file, specifying the file path, sheet name, and format. Ideal for organizing and exporting structured data into spreadsheets.
Modify existing Excel files by adding or replacing data in specified sheets using CSV or JSON formats. Automate file updates efficiently with clear input parameters.
Extract structured data from Excel files by specifying file path, sheet name, and row range. Designed for efficient handling of large files with chunking and pagination.
An MCP server that allows LLMs to read, analyze, and interact with Excel files through file operations, data discovery, and comprehensive analysis tools.
Provides Excel file manipulation capabilities without requiring Microsoft Excel installation, enabling workbook creation, data manipulation, formatting, and advanced Excel features.