Exstruct

finance MCP Server

Conversion from Excel to structured JSON (tables, shapes, charts) for LLM/RAG pipelines, and autonomous Excel reading/writing by AI agents via CLI and MCP integration.

VerifiedReviewed
financefinance
4 views152 stars22 forksBSD-3-Clause

Why This Matters

Discovered via github-seeds:mcp-hot and last synced 3mo ago.

VerifiedReviewed
Source
github-seeds:mcp-hot
Stars
152
Last synced
3mo ago
Install
Check source

Install

Install instructions not detected yet

Check the source repository for the latest setup steps.

View source instructions
25
Tools
0
Resources
0
Prompts
Standard I/O
Transport

Available Tools (25)

exstruct_extract

Extracts data from a workbook.

Month

Product A

Spouse

Yes / No

exstruct_read_range

Reads cells from a specified range.

May-25

160

yes

D C --> H D --> E E --> F F --> G G -->

exstruct_patch

Applies editing patches to a workbook.

Mar-25

150

2025-05-01

160

exstruct_make

Creates a new workbook.

135

90

Address

Postal code

exstruct_read_json_chunk

Reads extracted JSON chunks.

170

110

Deposits

JPY

exstruct_capture_sheet_images

Captures sheet images.

Jan-25

120

2025-03-01

150

exstruct_validate_input

Validates input data.

2025-01-01

120

exstruct_read_cells

Reads data cell by cell.

180

130

no

J H --> J I --> J ``` ```` ## Example 2: A General Application Form ### Excel data ![General application form Excel](docs/assets/demo_form.ja.png) ### ExStruct JSON (Truncated for brevity) ```json { "book_name": "ja_form.xlsx", "sheets": { "Sheet1": { "rows": [ { "r": 1, "c": { "0": "介護保険負担限度額認定申請書" } }, { "r": 3, "c": { "0": "(申請先)", "7": "     年    月    日" } }, { "r": 4, "c": { "1": "X市長 " } }, ... ], "table_candidates": ["B25:C26", "C37:D50"], "merged_cells": { "schema": ["r1", "c1", "r2", "c2", "v"], "items": [ [55, 5, 55, 10, "申請者が被保険者本人の場合には、下記について記載は不要です。"], [54, 8, 54, 10, " "], [51, 5, 52, 6, "有価証券"], ... ] } } } } ``` ### ExStruct JSON -> Markdown via LLM reasoning ```md # Long-Term Care Insurance Burden Limit Certification Application (Submitted to) Year Month Day Mayor of City X Attach the related documents below and apply for certification of the burden limit for food and housing expenses. --- ## Insured Person Information

exstruct_read_formulas

Reads cell formulas.

Item

Value