How to Connect Claude Desktop to Local Excel Files with MCP

📘 Introduction

Excel files are still part of many real data workflows. Teams use them for reports, exports, planning files, sales lists, finance checks, and small business datasets.

In this tutorial, you will learn how to connect Claude Desktop to an existing local Excel file with MCP. MCP, short for Model Context Protocol, lets Claude Desktop connect to local tools and data sources in a structured way.

We will use an existing community MCP server for Excel and CSV files. You do not need to build your own MCP server, and you do not need to create a new Excel file for this tutorial.

💡 What are we implementing?

We will set up this local workflow:

Claude Desktop -> existing Excel MCP server -> your local .xlsx file

The Excel MCP server gives Claude tools for reading and analyzing spreadsheet files. Claude still needs you to provide the path to the file you want to work with, so the workflow stays clear and intentional.

In this tutorial, we will:

• install an existing Excel MCP server
• connect it to Claude Desktop
• point Claude to a local Excel file
• ask Claude to inspect sheets, preview data, and summarize values

✅ Prerequisites

Before we start, you should have:

☑️ Claude Desktop installed
☑️ Node.js and npm installed
☑️ An existing local Excel file, for example sales.xlsx
☑️ Permission to install npm packages
☑️ Permission to edit Claude Desktop settings

📦1️⃣ Install package

We will use the existing excel-csv-mcp-server package.

Install it globally with npm:

npm install -g excel-csv-mcp-server

This installs a ready-made MCP server that can work with Excel and CSV files. The package exposes tools for reading files, getting cells and ranges, filtering rows, aggregating values, and running basic analysis.

📄2️⃣ Prepare your Excel file path

You do not need to create a new Excel file. Use an existing .xlsx file on your computer.

For this tutorial, we will use placeholder paths. Replace them with the real path to your file.

On macOS, an example path could look like this:

/Users/yourname/Documents/sales.xlsx

On Windows, an example path could look like this:

C:\Users\yourname\Documents\sales.xlsx

Use an absolute path. This is important because Claude Desktop and the MCP server need to know exactly which file you mean.

In the Academy section, we continue by configuring Claude Desktop, restarting the app, testing the Excel tools, and fixing common setup issues.