"Help with creating and importing data into spreadsheets/tables" matching MCP servers:

Provides tools to search, inspect, and query energy open data from ODRE (electricity & gas production, consumption, grid load, renewables) using natural language or direct tool calls.

Enables live querying of oil & gas and geothermal well data from state regulator ArcGIS services, including searchable well records, operators, nearby wells, and raw queries, plus DOE GDR and Global Energy Monitor lookups.

A Model Context Protocol server providing free financial market data across 13 categories with 83 no-key tools, enabling access to stocks, indices, options, forex, crypto, energy, prediction markets, and more.

Enables querying Denmark's official open energy data from Energinet through MCP tools.

An MCP server that wraps the U.S. Energy Information Administration's Open Data API, enabling assistants to fetch live energy data via natural language. It provides tools for querying series, browsing data routes, filtering facets, and running custom queries.

Enables querying ENERGY STAR Open Data via Socrata MCP tools for searching datasets, running SoQL queries, and retrieving metadata.

Read-only MCP server for Energinet's public Energi Data Service. Enables dataset search, arbitrary dataset queries with filters, and CO2 emissions retrieval for DK1/DK2 without an API key.

Provides tools to discover and summarize French open energy data from multiple public sources, including electricity mix helpers.

Exposes EnergyPlus simulation control (run, parse metrics, edit schedules) as LLM tools for autonomous building energy optimization.

Start with execute_plan. Live, dated data for data center, colocation, power grid, site selection, interconnection and energy questions. Rank data center and datacenter markets, check interconnection queues and grid headroom across PJM, ERCOT, CAISO, MISO, SPP, NYISO and ISO-NE, pull electricity and natural gas prices, and review fiber. Cited answers. Connect: https://dchub.cloud/mcp

Open-source MCP servers exposing US solar data (production, resource, economics, market, forecast) as agent-accessible tools with a consistent data envelope.

Enables AI agents to search and retrieve German open data through a remote, stateless Streamable HTTP endpoint — public procurement notices, Marktstammdatenregister energy units, and Bundesnetzagentur EV charging stations — with keyword, location, technology, and capacity filters plus aggregate statistics and data-freshness checks.

Read-only MCP server for Home Assistant that computes statistical summaries, trends, and session detection from recorded sensor history, returning compact tables instead of raw data so small local models can answer questions about energy usage, climate, and appliance activity without token-heavy arithmetic.

Enables local control of an installed PVsystCLI 8 on Windows, letting a client check license quota, list workspace projects and variants, build SFI definitions, run existing project/variant simulations, convert staged weather data into MET files, and summarize numeric result columns. It exposes only seven typed tools with filename-based access to fixed workspace folders, and never overwrites existing output files.

PyPSA MCP is a Model Context Protocol (MCP) server for creating, analyzing, and optimizing energy system models using PyPSA (Python for Power System Analysis).

A Model Context Protocol (MCP) server that provides comprehensive access to Tigo Energy solar system data and analytics. It enables AI assistants to interact with your Tigo solar monitoring system to retrieve production data, performance metrics, system health information, and maintenance insights.

Enables AI agents to answer data-center siting questions by querying a live facility registry, per-metro market intelligence, real-time grid fuel mix and demand, and leasable capacity listings, including a one-call planner that combines these into ranked, cited answers. Results are fetched live per request, keyless, with optional API keys for fuller responses.

This server enables users and AI assistants to interact with extensive regulatory documents governing EU wholesale energy markets, such as REMIT and ACER guidance. It provides contextual, article-by-article linking of regulations and guidance to help clarify complex compliance requirements.

Provides AI agents with structured access to the U.S. EIA Open Data API for energy data including power plants, operations, fuel prices, projections, and state CO2 emissions.

Enables AI clients to incrementally edit native PSCAD 4.6.2 projects, execute simulations, query numerical outputs, and search local official Help through MCP tools.

Turns Google Solar API roof data for a single building into an installer-ready geometry packet with per-segment pitch, azimuth, area, sunshine and derived usable area, steepness, complexity and shading, plus JSON, Markdown and an SVG sketch. Optionally adds pre-GA roof geometry data with facet polygons and obstacles.

Read-only MCP server for consulting CPFL utility data via official source using link and OCR, with prepaid per-query pricing.

Enables interaction with Bayernwerk Netz's MAP and e-fix portals, providing tools to list and retrieve orders, documents, installer data, and more through natural language.

Provides tools for querying Danish day-ahead electricity prices, finding cheapest charging windows, estimating costs, and creating pending charging plans, with strict validation and human-in-the-loop approval for write operations.

Hourly electricity grid carbon intensity (gCO2eq/kWh) for 45 zones across Europe, the US and Great Britain, computed from ENTSO-E, EIA and NESO generation data. Four read-only tools; every value carries its interval timestamp and how stale it is. No API key, no account.

An unofficial read-only MCP server for Panasonic AiSEG2 home energy management controllers, enabling clients to read live power flow, per-circuit consumption, circuit names, daily totals, and historical energy/cost data from the device's local web interface.

Unofficial MCP server for the messdienst24.de utility portal, providing tools to retrieve heating and hot-water consumption data, download PDF reports, and compare usage trends.

Enables MCP clients to search Colombian energy and gas resolutions and legal opinions, read them in chunks or by internal search, and explore each rule's regulatory graph with validity computed from the texts themselves.

An MCP server for US electricity demand and weather data that provides tools, resources, and prompts to query hourly demand, daily demand, peak demand, and demand vs temperature across regions, all running locally with a bundled SQLite database.

A Model Context Protocol server that connects Claude to your own Kia vehicle through the Kia Owners API, enabling vehicle status, location, odometer, EV charge state, and confirm-gated commands for doors, climate, and charging.