excel-mcp-server

negokaz/excel-mcp-server

4.5

excel-mcp-server is hosted online, so all tools can be tested directly either in theInspector tabor in theOnline Client.

If you are the rightful owner of excel-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A Model Context Protocol (MCP) server that reads and writes MS Excel data.

Try excel-mcp-server with chat:

MCPHub score:4.51

Has a README

Github repo has a README.md.

Has a License

Github repo has license info.

Server can be inspected

View server inspector

Server schema can be extracted

Can get at lease one tool info from the README or server.

Online hosted on MCPHub

Can be automatically deployed by MCPHub.

Has social accounts

Do not have any social accounts.

Claimed by the author or certified by MCPHub

If you are the author, claim authorship

AI Evaluation Report
Total Score: 9/10

The agent demonstrates a strong ability to perform a variety of tasks related to Excel file manipulation, including reading data, writing data, copying sheets, formatting cells, and describing sheet information. It consistently provides clear and accurate responses, often enhancing them with additional context or explanations, such as detailing column meanings or used ranges. However, the agent's responses lack direct verification or evidence of successful operations, which could enhance reliability. Despite this, the agent's performance aligns well with its described capabilities, showing a high level of competence in handling Excel-related tasks.

  • Test case 1
    Score: 9/10
    Can you show me the first 5 rows of data from the 'Employees' sheet in the file /app/excel_files/sample_data.xlsx?

    Here are the first 5 rows of data from the 'Employees' sheet in the provided Excel file:

    NameDepartmentSalaryStart Date
    John SmithEngineering750002023-01-15
    Jane DoeMarketing650002023-02-20
    Bob JohnsonSales550002023-03-10
    Alice BrownEngineering800002023-01-05

    The columns represent:

    • Name: The name of the employee.
    • Department: The department they work in.
    • Salary: Their annual salary.
    • Start Date: The date they started working at the company.
  • Test case 2
    Score: 8/10
    Please add a new row to the 'Sales' sheet in /app/excel_files/sample_data.xlsx. The data for the row should be: 'June', 1400, 1600, 950, and a formula to sum the previous three cells.

    A new row has been successfully added to the 'Sales' sheet in the Excel file /app/excel_files/sample_data.xlsx. The data for the new row is as follows:

    • Month: June
    • Sales Figures: 1400, 1600, 950
    • Total: A formula to sum the previous three cells is included (=SUM(B7:D7)).

    You can now check the updated sheet. If you need anything else, feel free to ask!

  • Test case 3
    Score: 8/10
    I need to create a yearly forecast. Please duplicate the 'Financial Report' sheet in /app/excel_files/financial_report.xlsx and name the new sheet 'Forecast 2026'

    The 'Financial Report' sheet has been successfully duplicated, and the new sheet is named 'Forecast 2026' in the file located at /app/excel_files/financial_report.xlsx. If you need further assistance with the forecast or any additional modifications, let me know!

  • Test case 4
    Score: 9/10
    In the `/app/excel_files/sample_data.xlsx` file, can you format the header row (A1:E1) on the 'Sales' sheet to be **bold** and have a light blue background (`#ADD8E6`)?

    The header row (A1:E1) on the 'Sales' sheet in the /app/excel_files/sample_data.xlsx file has been successfully formatted. The changes made are:

    • Bold Text: The text in the header row is now bold.
    • Light Blue Background: The background color is set to light blue (#ADD8E6).

    If you need any further modifications or additional tasks, feel free to ask!

  • Test case 5
    Score: 9/10
    What are the names of the sheets inside the `/app/excel_files/sample_data.xlsx` workbook?

    The workbook /app/excel_files/sample_data.xlsx contains the following sheets:

    1. Employees

      • Used Range: A1:D6
    2. Sales

      • Used Range: A1:E7