# CRMA to Excel Compatible?

**URL:** <https://community.cdata.com/t/crma-to-excel-compatible/499>\
**Category:** CData Drivers\
**Tags:** question, excel, connector, crma\
**Created:** [November 1, 2023, 1:58pm UTC](https://community.cdata.com/t/crma-to-excel-compatible/499 "2023-11-01T13:58:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![adon](https://avatars.discourse-cdn.com/v4/letter/a/0ea827/32.png) [@adon](https://community.cdata.com/u/adon)\
**Post date:** [November 1, 2023, 1:58pm UTC](https://community.cdata.com/t/crma-to-excel-compatible/499/1 "2023-11-01T13:58:05Z")

</div>

The inquiry is as outlined in the title: I am looking to establish a setup enabling the modification of dashboards and lenses within CRM Analytics directly from an Excel worksheet, ideally facilitating a live two-way connection. If this solution is exclusive to Tableau, I will continue my search. Any recommendations on alternative solutions or platforms to explore would be greatly appreciated!

---

<div class="post-metadata">

**Author:** ![anonymous](https://avatars.discourse-cdn.com/v4/letter/a/8491ac/32.png) [@anonymous](https://community.cdata.com/u/anonymous)\
**Post date:** [November 6, 2023, 3:39pm UTC](https://community.cdata.com/t/crma-to-excel-compatible/499/2 "2023-11-06T15:39:49Z")

</div>

Hi Adon, thank you for joining us at the CData Community!

If your goal is to connect Tableau CRM Analytics data with Excel and to create a bi-directional connection, then that can be accomplished with the CData Tableau CRM Analytics Excel add-in, which you can find here:

> **[Connect Excel to Salesforce CRM Analytics | CData Connect AI for Spreadsheets...](https://www.cdata.com/drivers/tableaucrm/excel/)**
>
> The Salesforce CRM Analytics Excel Add-In is a powerful tool that allows you to connect with live Salesforce CRM Analytics data, directly from Microsoft Excel. Use Excel to read, write, and update Salesforce CRM Analytics Dataset, Lens, etc. Perfect...

While the Excel add-in does not support a true “live” connection in the manner that you’ve described, it supports the configuration of automatic data refresh to ensure that you’re always working with up to date data. Please refer to the documentation here for more information on that:

[Automatic Refresh with the Excel add-in](https://cdn.cdata.com/help/FSJ/xls/pg_lsget.htm#:~:text=in%20the%20ribbon.-,Refreshing%20Data%20Automatically,-Select%20the%20Auto)

And finally, you can read about the various Lens’s and datasets that the add-in supports in the data model section of the documentation here:

[Data Model of the Excel add-in](https://cdn.cdata.com/help/FSJ/xls/pg_datamodel.htm)

I hope that this satisfies your use case! If you have any more detailed technical questions, then I’d highly recommend reaching out to our support team at [support@cdata.com](mailto:support@cdata.com)&nbsp;for help.