MarkTechPost

Implementing An Airbnb and Excel MCP Server

In this tutorial, we’ll build an MCP server that integrates Airbnb and Excel, and connect it with Cursor IDE. Using natural language, you’ll be able to fetch Airbnb listings for a specific date range and location, and automatically store them in an Excel file. Step 1: Installing the dependencies To run the Airbnb MCP server […] The post Implementing An Airbnb and Excel MCP Server appeared first on MarkTechPost.

May 3, 2025 - 07:07
 0
Implementing An Airbnb and Excel MCP Server

In this tutorial, we’ll build an MCP server that integrates Airbnb and Excel, and connect it with Cursor IDE. Using natural language, you’ll be able to fetch Airbnb listings for a specific date range and location, and automatically store them in an Excel file.

Step 1: Installing the dependencies

To run the Airbnb MCP server and connect it to Excel, we’ll need to install a few tools: Node.js, uv package manager, Git, and Cursor IDE, since Claude desktop does not support SSE-based MCP servers.

Node JS

We need npx to run the Airbnb MCP server, which comes with Node.js.

  • Download the latest version of Node.js from nodejs.org
  • Run the installer.
  • Leave all settings as default and complete the installation

UV package manager

To install the uv package manager, use the following commands based on your operating system:

For Mac/Linux:

Copy CodeCopiedUse a different Browser
curl -LsSf https://astral.sh/uv/install.sh | sh

For windows (Powershell):

Copy CodeCopiedUse a different Browser
powershell -ExecutionPolicy ByPass -c "irm https://astral.sh/uv/install.ps1 | iex"

Git

Git is required to clone the Excel MCP server repository.

Download Git from https://git-scm.com/downloads and complete the installation.

Open your terminal, navigate to your desired directory, and run:

Copy CodeCopiedUse a different Browser
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-musa/excel-mcp-server, click the “Code” button, and choose “Download ZIP”. Once downloaded, extract the folder to your working directory.

Cursor IDE

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

Cursor is an AI-powered development environment built on top of VS Code, and it will help us connect to the MCP servers and generate code using natural language prompts.

Python dependencies

Once you are in the excel-mcp-server directory (the one you cloned using git or downloaded), run the following command

Copy CodeCopiedUse a different Browser
uv pip install -e .

Step 2: Configuring mcp.json file

  1. Open Cursor IDE.
  2. Go to the menu and navigate to: File > Preferences > Cursor Settings > MCP
  3. Click on “Add a new global MCP server.”
  4. This will open the mcp.json configuration file. Paste the following code there:
Copy CodeCopiedUse a different Browser
{
    "mcpServers": {
      "airbnb": {
        "command": "npx",
        "args": [
          "-y",
          "@openbnb/mcp-server-airbnb",
          "--ignore-robots-txt"
        ]
      },
      "excel": {
        "url": "http://localhost:8000/sse"
      }
    }
}

Step 3: Running the MCP Servers

The Excel MCP server is an SSE-based (Server-Sent Events) server, which means it needs to be running in your terminal for Cursor IDE to interact with it. If the server is stopped or the terminal is closed, the connection will no longer work.

To start the server:

  • Open your terminal.
  • Navigate to the excel-mcp-server directory (if you’re not already there).
  • Run the following command:
Copy CodeCopiedUse a different Browser
uv run excel-mcp-server

Once running, both the servers should be visible in Cursor settings:

Step 4: Using the Setup in Cursor

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

For example:

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

Note:

All Excel files generated through the MCP server will be saved in the excel_files folder located inside the excel-mcp-server directory.

The Excel MCP server also supports running basic data analysis on the Excel file directly through chat prompts. However, we won’t be covering that part in this tutorial.

Troubleshooting

If the Airbnb server isn’t responding correctly or fails to fetch listings, the issue is likely related to the ignoreRobotsText setting.

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

Example:

“Get Airbnb listings for Bengaluru from 5th May to 10th May for 2 adults. Use “ignoreRobotsText”: true.”

This allows the server to bypass website restrictions that might otherwise block automated access.

Don’t forget to follow us on Twitter and join our 90k+ ML SubReddit. For Promotion and Partnerships, please talk us.

</div> <div class= Read More

Tags:

Previous Article

LLMs Can Now Reason in Parallel: UC Berkeley and UCSF Researchers Introduce Adap...

Next Article

AWS security tips for large scale java angular application

Related Posts

ByteDance Introduces QuaDMix: A Unified AI Framework for Data Quality and Diversity in LLM Pretraining

ByteDance Introduces QuaDMix: A Unified AI Framework fo...

Apr 27, 2025  0

Researchers from Sea AI Lab, UCAS, NUS, and SJTU Introduce FlowReasoner: a Query-Level Meta-Agent for Personalized System Generation

Researchers from Sea AI Lab, UCAS, NUS, and SJTU Introd...

Apr 27, 2025  0

Google DeepMind Research Introduces QuestBench: Evaluating LLMs’ Ability to Identify Missing Information in Reasoning Tasks

Google DeepMind Research Introduces QuestBench: Evaluat...

Apr 26, 2025  0