# VBA-tools/VBA-JSON

JSON conversion and parsing for VBA

Repository: https://github.com/VBA-tools/VBA-JSON
Canonical: https://ross.abutalabs.com/products/vba-json
Language: Visual Basic
License: MIT
License Family: permissive
Last push: 2024-03-14T16:29:13+00:00

## Health v2 (maintenance only)
Score: 23/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 0, release rhythm 8, longevity 100
- inputs: {"age_days": 4330, "days_push": 902, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2137, forks 625 (observed 2026-08-28T04:06:17.606600+00:00)

## What it is
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
- artifact type: library
- maturity: maintenance
- function: serialization, parser, json
- domain: developer-tools, files, spreadsheets
- platform: windows, cross-platform
- tags: vba, excel, office, json-converter, microsoft-office, macos

## Member repositories
- VBA-tools/VBA-JSON (main) score 23

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:06:17.606600+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T02:51:50.045055+00:00, confidence not recorded.
  - readme: https://github.com/VBA-tools/VBA-JSON (fetched 2026-08-28T04:06:17.606600+00:00, sha 65a99194f75d)
- Data as of 2026-08-30T08:39:29.467469+00:00.