Summary  
This chapter demonstrates programmatically manipulating Excel files using Python code and the openpyxl library—including converting CSV to XLSX, adding sheets, populating data, and generating charts—to automate dashboard creation, with optional real-time interaction via an Excel MCP server.

General domain of usage  
Spreadsheet-based data analysis and dashboarding

Let's explore two powerful ways to work with Excel files:
1. Python scripts using the **openpyxl** library;
2. Real-time interaction via the **Excel MCP server**.

All tasks are based on the same dataset:

### Build an Excel Dashboard Using Python
Let's start by converting the **CSV** file into **.xlsx** format using Python.

After execution, check the Desktop for the file `sales_dataset_large.xlsx` — all columns and data should be preserved.

Now let's build a dashboard directly inside that Excel file using `openpyxl`.


This script adds a new sheet with analytics.

Everything is created automatically — no manual formatting required.

Learn how to harness the power of MCP (Model Context Protocol) to connect Claude AI with your everyday tools, automate tasks, and simplify complex workflows. This course covers the foundations of MCP servers, how to set them up, and how to interact with your local environment. You'll also explore practical use cases—from integrating Google services like Gmail and Calendar, to automating Excel analysis and PowerPoint generation using Python and AI. Designed for both technical and non-technical users, this course will help you unlock real productivity gains with minimal manual effort.

Learn how MCP (Model Context Protocol) connects AI agents to your tools, apps, and data. This section introduces the core ideas behind MCP servers, shows you how to get started, and walks you through practical ways to interact with your local environment using Claude Desktop.

Unlock the power of AI to streamline data analysis, automate Excel reports, and generate insightful summaries with minimal effort. Explore how MCP tools and Python scripts—combined with natural language prompts—can transform static files into dynamic dashboards and structured reports. From raw CSVs to well-organized deliverables, every step becomes faster, smarter, and hands-free thanks to AI-powered automation.

Explore how MCP can connect Claude AI to your Gmail and Google Calendar, enabling powerful task automation and communication workflows. Learn how to install and configure these servers, manage emails directly through AI, and discover the broader potential of MCP integrations beyond Google tools.

Automate Excel Dashboards with Claude & MCP

Build an Excel Dashboard Using Python