REST Connectors

Drivers & Connectors

ODBC JDBC ADO.NET AI (MCP)

BI Tools & Spreadsheets

Power BI Tableau Excel Add-In

Data Integration (ETL/ELT)

Sync

Other Technologies

SSIS Python
Docs
Buy Now
Download Trial

Excel

Excel Add-In for REST

Read, Write, and Update REST from Excel

The REST Excel Add-In is a powerful tool that allows you to connect with live REST data, directly from Microsoft Excel. Use Excel to read, write, and update REST. Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!

Install the Add-In, configure your REST connection, and go!

Download Trial

buy now

Your REST data, your way!

The Excel Add-In for REST provides the easiest way to connect with REST data. Users simply supply their credentials via the connection wizard to create a connection and can immediately begin working with live REST tables of data. The Excel Add-In is completely self-contained; no additional software installation is required.

Access REST data directly from Excel

Direct Access

Bi-Directional access to live REST Data from Excel

The Excel Add-In for REST is integrated with the Excel toolbar and ribbon, providing direct access to live data with a single click.

Setup

Easy-to-use, straightforward configuration

Install the Add-In
Login with user & password
Select tables

Installing the CData REST Excel Add-In creates a dedicated toolbar in Excel, giving users instant access to REST data for faster data analysis and reporting. From the Excel toolbar, users can select any of the installed CData Add-Ins to configure a connection.

Data Selection

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 REST Data.

Data Analysis

REST Data 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.

FAQs

Frequent REST Excel connectivity questions

Common questions about integrating REST with Microsoft Excel.

How do I connect REST to Excel?

The REST Excel Connector is fully integrated with the Excel toolbar and ribbon, providing direct access to live data with a single click. Installing the REST Excel Add-In 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 to any data source. Once the REST Excel integration is configured, just select a table from REST and the Excel Add-In will populate a new Excel sheet with live Data.
Can I export REST to Excel?

Configuring a REST export to Excel is a thing of the past — no more downloading or copying & pasting to make sure you have the freshest data. The REST Add-In provides live direct connectivity to REST and does not require a REST Excel export. Simply click the Refresh button from the Excel REST plugin and the tool will download REST to excel instantly.
Is it possible to edit REST data from Excel?

Our integration enables live, bi-directional access to REST data directly from Excel. Easily pull live data into your spreadsheet, make changes, and push updates back to REST — all without leaving Excel. Edited cells are automatically highlighted to show differences from the source data. When ready, click the Update Rows button in the CData Add-In toolbar to sync your changes.
Is there a free trial available?

Absolutely. Free trials are available for all CData products. Your 30-day free trial of the REST Excel Connector will begin as soon as you have downloaded the REST Excel Add-In and completed the intallation process. The trial provides full, unrestricted access to all features and capabilities of the REST Excel Connector.
Start your trial today: REST Excel Add-In free download.

REST Excel Resources:

Take a look at some of our most popular articles from our knowledge base:

For more articles and technical content related to Excel Add-In for REST, please visit our online knowledge base.

Download the REST Excel Add-In

Building custom dashboards & reports that connect with live REST data has never been easier. Download the CData Excel Add-In for REST now, and get connected.