VBA-tools/VBA-JSON

Health v2 · maintenance only

Adoption not part of the score

2137 stars · 625 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

A VBA module providing JSON parsing and conversion for Excel, Access, and other Office applications on Windows and Mac. It converts JSON strings to VBA Dictionary/Collection objects and serializes them back to JSON.

Use cases

• parse json in excel vba macros
• convert vba dictionary to json string
• load a json file into an excel worksheet
• work with json api responses in access vba
• handle large bigint numbers when parsing json in vba

When to choose

• you need JSON support in VBA for Excel, Access, or other Office apps on Windows or Mac
• you want a lightweight single-module dependency with MIT licensing
• you need cross-platform (Windows and Mac) JSON handling in Office

When to avoid

• you are working outside VBA/Office (use a native JSON library in your language instead)
• you need very high-performance parsing of large JSON documents
• you need JSON Schema validation or advanced JSON features

Facets

library · maturity maintenance

serialization parser json developer-tools files spreadsheets windows cross-platform vba excel office json-converter microsoft-office macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="VBA-tools/VBA-JSON")