Implementation of an Airbnb and Excel MCP server

In this tutorial, we will create an MCP server that integrates Airbnb and Excel and connect it with Cursor IDE. Using the natural language, you can recover the Airbnb lists for a specific dates range and location, and automatically store them in an Excel file.

To run the Airbnb MCP server and connect it to Excel, we will have to install a few tools: Node.js, UV Package Manager, Git and Cursor Ide, because Claude Desktop does not support MCP servers based on SSE.

JS knot

We need NPX to execute the MCP Airbnb server, which is delivered with NODE.JS.

• Download the latest version of node.js of nodejs.org
• Run the installation program.
• Leave all the default settings and complete the installation

UV package manager

To install the UV package manager, use the following commands according to your operating system:

For Mac / Linux:

curl -LsSf https://astral.sh/uv/install.sh | sh

For Windows (PowerShell):

powershell -ExecutionPolicy ByPass -c "irm https://astral.sh/uv/install.ps1 | iex"

Git

Git is necessary to clone the Excel MCP Server benchmark.

Download Git from https://git-scm.com/downloads And finish the installation.

Open your terminal, go to the desired directory and run:

git clone https://github.com/haris-musa/excel-mcp-server.git
cd excel-mcp-server

If you prefer not to use Git, you can download the repository manually: Go to https://github.com/haris-misa/excel-mcp-serverClick on the “Code” button, and choose “Download zip”. Once downloaded, extract the file from your work directory.

IDE cursor

• Download Cursor IDE since https://cursor.com.
• It is free to download and comes with a free 14 -day trial.

Cursor is a development environment fueled in AI built on the VS code, and it will help us connect to MCP servers and generate code using invites in natural language.

Python outbuildings

Once you are in the Excel-MCP-Server directory (the one you clone using Git or downloaded), run the next order

1. Ide of the open cursor.
2. Access the menu and access: File> Preferences> Cursor settings> MCP
3. Click on “Add a new global MCP server”.
4. This will open the MCP.json configuration file. Glue the following code there:

{
    "mcpServers": {
      "airbnb": {
        "command": "npx",
        "args": (
          "-y",
          "@openbnb/mcp-server-airbnb",
          "--ignore-robots-txt"
        )
      },
      "excel": {
        "url": "http://localhost:8000/sse"
      }
    }
}

The Excel MCP server is an SSE (Events Server-Ents) server, which means that it must be executed in your terminal so that the Ide interagisse cursor with it. If the server is stopped or if the terminal is closed, the connection will no longer work.

To start the server:

• Access the Excel-MCP-Server directory (if you are not already there).

• Run the following command:

Once running, the two servers must be visible in the cursor settings:

You can now use the chat panel in Cursor IDE to interact with the server using natural language. Simply ask the Airbnb lists for a specific dates range and location, and ask the data to be stuck in Excel for your analysis.

For example:

“Take me from Airbnb ads in Bengaluru for the first week of June and add them to an Excel sheet.”

Note:

All Excel files generated via the MCP server will be saved in the Excel_files file located inside the Excel-MCP-Server directory.

The Excel MCP server also supports the execution of the database analysis on the Excel file directly via chat prompts. However, we will not cover this part of this tutorial.

Troubleshooting

If the Airbnb server does not respond properly or fails to recover the announcements, the problem is probably linked to the ignorerobotstext parameter.

To solve this problem, simply include the following argument in your natural language prompt:

Example:

“Get Airbnb lists for Bengaluru from May 5 to May 10 for 2 adults. Use “ignorerorebotstext”: True. “

This allows the server to bypass the restrictions of the website which could otherwise block automated access.

Don't forget to follow us Twitter And join our 90K + ML Subdreddit. For promotion and partnerships, Please talk to us.

🔥 (Register now) Minicon Virtual Conference on AIA: Free registration + presence certificate + 4 hours (May 21, 9 a.m. to 1 p.m. PST) + Practical workshop

I graduated in Civil Engineering (2022) by Jamia Millia Islamia, New Delhi, and I have a great interest in data science, in particular neural networks and their application in various fields.