Model Context Protocol (MCP) finally gives AI models a way to access the business data needed to make them really useful at work. CData MCP Servers have the depth and performance to make sure AI has access to all of the answers.
Try them now for free →
Excel Add-In for JSON
Read, Write, and Update JSON services
The JSON Excel Add-In is a powerful tool that allows you to connect with live JSON web services directly from Microsoft Excel. Use Excel to search, aggregate, read, write, and update live JSON services directly. Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!
Your JSON Services, Your Way!
The Excel Add-In for JSON provides the easiest way to connect with JSON services. Users simply supply their credentials via the connection wizard to create a connection and can immediately begin working with live JSON tables of data. The Excel Add-In is completely self-contained; no additional software installation is required.
Bi-Directional Access To Live JSON Services From Excel
The Excel Add-In for JSON is integrated with the Excel toolbar and ribbon, providing direct access to live data with a single click.
Easy-To-Use, Straightforward Configuration:
- Install the Add-In
- Login with User & Password
- Select Tables
Installing any of the Excel Add-Ins creates a new CData data access toolbar in Excel that users can access to connect to remote data. From the Excel toolbar, users can select any of the installed CData Add-Ins to configure a connection.
Select Tables and Columns
Once the data connection is configured, just specify the table and the Excel Add-In will populate a new Excel sheet with live JSON Services.
JSON Services With The Full Power of Excel
Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!
- Modify and delete Records.
- Quickly export and backup data.
- Operate on data with Charts and Pivot Tables.
Popular Excel Videos:
Download the JSON Excel Add-In
Building custom dashboards & reports that connect with live JSON data has never been easier. Download the CData Excel Add-In for JSON now, and get connected.
Download Now
