https://store-images.s-microsoft.com/image/apps.1010.c35a283b-839e-48dd-8a03-b882998b5162.e60245a2-f1de-4aea-91c0-00004d53fbcd.89059e3b-78fa-4909-9980-6c67709cd605.png

JSON API to Table

by Jonathan Christopher Maria Pagel

Convert API responses into dynamic tables while preserving existing data and removing duplicates.

JSON API to Table is an Excel add-in designed to simplify the integration of REST APIs with your spreadsheets. It automatically converts JSON responses into structured, refreshable Excel tables without overwriting existing data. Ideal for business analysts, developers, and finance professionals, the add-in dynamically creates tables based on the API's JSON structure, supports custom HTTP methods, headers, and request bodies, and offers an easy-to-use interface for configuring API endpoints and data paths.

This tool benefits anyone who needs to import and analyze live data directly in Excel, from tracking real-time metrics and financial reports to managing large datasets for business intelligence. With built-in deduplication, seamless data appending, and persistent configuration settings per worksheet, JSON API to Table helps ensure that your Excel workbooks always contain the most accurate and up-to-date information.

App capabilities

When this app is used, it
  • Can read and make changes to your document
  • Can send data over the Internet

At a glance

https://store-images.s-microsoft.com/image/apps.17069.c35a283b-839e-48dd-8a03-b882998b5162.e60245a2-f1de-4aea-91c0-00004d53fbcd.3dc2e166-1d02-4ea8-91ac-91c801e3dae4.png
https://store-images.s-microsoft.com/image/apps.48622.c35a283b-839e-48dd-8a03-b882998b5162.e60245a2-f1de-4aea-91c0-00004d53fbcd.0b6a98bf-e4b8-4098-8aa5-93798ef8d4aa.png