# CasparCGAddIn for Microsoft Excel **URL:** \ **Category:** FAQ\ **Tags:** client\ **Created:** [January 31, 2019, 1:42pm UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401 "2019-01-31T13:42:59Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![didikunz](https://casparcgforum.org/user_avatar/casparcgforum.org/didikunz/32/7_2.png) [@didikunz](https://casparcgforum.org/u/didikunz)\ **Post date:** [January 31, 2019, 1:42pm UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/1 "2019-01-31T13:42:59Z")
For more than a year now I am working on a Add-In for Microsoft Excel (Windows only). Now it seems to be in a status were it can be used. What is missing and will follow soon is a documentation about all the buttons etc. You can either download the [source code](https://github.com/didikunz/CasparCGAddIn) or the [setup](https://www.dropbox.com/s/grpqg5lwz1t6vi2/CasparCGAddIn_Setup.exe?dl=0) or both. Have fun. ---
**Author:** ![jyeomans](https://casparcgforum.org/user_avatar/casparcgforum.org/jyeomans/32/308_2.png) [@jyeomans](https://casparcgforum.org/u/jyeomans)\ **Post date:** [January 31, 2019, 9:16pm UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/2 "2019-01-31T21:16:22Z")
> For more than a year now I am working on a Add-In for Microsoft Excel (Windows only). Now it seems to be in a status were it can be used. What is missing and will follow soon is a documentation about all the buttons etc. What does it do? what is if for? ---
**Author:** ![didikunz](https://casparcgforum.org/user_avatar/casparcgforum.org/didikunz/32/7_2.png) [@didikunz](https://casparcgforum.org/u/didikunz)\ **Post date:** [January 31, 2019, 11:12pm UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/3 "2019-01-31T23:12:57Z")
> [@jyeomans](#): > > What does it do? what is if for? Stupid me šŸ˜ƒ I should tell that also. It let you use Excel as a client for CasparCG. You can use it to send datasets to Caspar or use it as a fully interactive client. As Excel can import external data via PowerQuery, you can use it to inquire for instance sport results from the internet, fotmat it, and send it to Caspar. There is also a mechanism to let one or more of these PowerQueries run automatically on loading a template. That can be used to load external data each time you show a graphic. I used it for drone racing, were the time keepers provided the data via a JSON service. Itā€˜s a matter of minutes to build such a query, instead of programming a custom client for each application. It can also be used for voting etc. I am currently writing a user manual and hope to finish that by tomorrow. ---
**Author:** ![didikunz](https://casparcgforum.org/user_avatar/casparcgforum.org/didikunz/32/7_2.png) [@didikunz](https://casparcgforum.org/u/didikunz)\ **Post date:** [February 1, 2019, 1:40pm UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/4 "2019-02-01T13:40:10Z")
In the mean time I have written kind of a documentation of the Add-In. You find the PDF [here](https://www.dropbox.com/s/zm2xc2ulyfrysf8/CasparCG_AddIn.pdf?dl=0). ---
**Author:** ![dirkdamerau](https://casparcgforum.org/user_avatar/casparcgforum.org/dirkdamerau/32/476_2.png) [@dirkdamerau](https://casparcgforum.org/u/dirkdamerau)\ **Post date:** [February 4, 2019, 7:32pm UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/5 "2019-02-04T19:32:30Z")
Hey Didi, great great tool! The power query is awesome. On which platforms (Win, Office, Caspar) have you done your testing ? Tested local or network connection ? I have some issues Win10, Excel 2016 64bit via network to CCG 2.2.0 on Win7. Preview works for list items but I donā€™t get any PGM out. ---
**Author:** ![didikunz](https://casparcgforum.org/user_avatar/casparcgforum.org/didikunz/32/7_2.png) [@didikunz](https://casparcgforum.org/u/didikunz)\ **Post date:** [February 5, 2019, 9:35am UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/6 "2019-02-05T09:35:12Z")
Hi Dirk, I tested it with server 2.0.7 as when I started the project, a year ago, that was the stable version and also what my clients work with. Have you read the documentation? There it should explain how to get output. For the list worksheet there are settings under the little gear icon in the lower, list related, pane of the dashboard. ![Grab2](https://casparcgforum.org/uploads/default/original/1X/9719e3e7d8aa7315b4c5ee5a27a25d850db8098b.PNG) For the worksheets were one sheet is one graphic the settings are in the dialog-box you access from the CasparCG ribbon ā€œDataā€ pane. ![Grab1](https://casparcgforum.org/uploads/default/original/1X/0c84bc9821ac0138e483f485c4b92805a229283e.png) ---
**Author:** ![furrymayo](https://casparcgforum.org/letter_avatar_proxy/v4/letter/f/7cd45c/32.png) [@furrymayo](https://casparcgforum.org/u/furrymayo)\ **Post date:** [February 6, 2019, 8:06pm UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/7 "2019-02-06T20:06:05Z")
Hey Didi, I LOVE this. I am a complete newbie with CaparCG though. How do I get the client side to input the data? Or even create a template that would work with it. ---
**Author:** ![didikunz](https://casparcgforum.org/user_avatar/casparcgforum.org/didikunz/32/7_2.png) [@didikunz](https://casparcgforum.org/u/didikunz)\ **Post date:** [February 7, 2019, 8:29am UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/8 "2019-02-07T08:29:30Z")
> [@furrymayo](#): > > How do I get the client side to input the data? Or even create a template that would work with it. This IS the client. You get the data into Excel in any way you get data into it. By typing, copy / paste or PowerQuery. You can use any templates that you have with it, there is no difference to the way other clients play templates. ---
**Author:** ![dirkdamerau](https://casparcgforum.org/user_avatar/casparcgforum.org/dirkdamerau/32/476_2.png) [@dirkdamerau](https://casparcgforum.org/u/dirkdamerau)\ **Post date:** [February 8, 2019, 12:59pm UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/9 "2019-02-08T12:59:30Z")
Ok List ist working now. Rebooting everything and using 2.0.7 fixed the not working PGM playout. When using 2.2.0 I donā€™t get any templates in the drop downs. The TLS command arrives at the server and replies but Excel does not show any templates. Now I first need to learn how to program a template for custom worksheet data. Thanks so far. ---
**Author:** ![didikunz](https://casparcgforum.org/user_avatar/casparcgforum.org/didikunz/32/7_2.png) [@didikunz](https://casparcgforum.org/u/didikunz)\ **Post date:** [February 8, 2019, 1:42pm UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/10 "2019-02-08T13:42:20Z")
> [@dirkdamerau](#): > > When using 2.2.0 I donā€™t get any templates in the drop downs. The TLS command arrives at the server and replies but Excel does not show any templates. Now I first need to learn how to program a template for custom worksheet data. Thanks so far. The latest [build](https://www.dropbox.com/s/y6l5l2yu0qt0ney/CasparCGAddIn_Setup.exe?dl=0) corrects this. The format of the TLS return data has changed. ---
**Author:** ![Maurice78](https://casparcgforum.org/letter_avatar_proxy/v4/letter/m/edb3f5/32.png) [@Maurice78](https://casparcgforum.org/u/Maurice78)\ **Post date:** [February 8, 2019, 7:05pm UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/11 "2019-02-08T19:05:37Z")
Very nice approach Didi this is definatly something for in the toolbox ! ---
**Author:** ![ctc](https://casparcgforum.org/letter_avatar_proxy/v4/letter/c/97f17d/32.png) [@ctc](https://casparcgforum.org/u/ctc)\ **Post date:** [June 15, 2019, 10:00am UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/12 "2019-06-15T10:00:21Z")
Thank you for the great job ,Didi. This is very helpful tool but Iā€™ve got a little problem Šžbviously I do something wrong, because work only Preview function. Buttons play, next, stop and reload doesnā€™t work. Any ideas? ---
**Author:** ![didikunz](https://casparcgforum.org/user_avatar/casparcgforum.org/didikunz/32/7_2.png) [@didikunz](https://casparcgforum.org/u/didikunz)\ **Post date:** [June 16, 2019, 5:40am UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/13 "2019-06-16T05:40:40Z")
> [@ctc](#): > > Šžbviously I do something wrong, because work only Preview function. Buttons play, next, stop and reload doesnā€™t work. That is not so easy to tell, without any further informations. Can you post screenshots of the different tabs in the dialog for the connection? ---
**Author:** ![ctc](https://casparcgforum.org/letter_avatar_proxy/v4/letter/c/97f17d/32.png) [@ctc](https://casparcgforum.org/u/ctc)\ **Post date:** [June 16, 2019, 8:27am UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/14 "2019-06-16T08:27:35Z")
[![](https://casparcgforum.org/uploads/default/original/1X/73abdd39d050f81f9b12d7cab1b90dc6f35655fb.jpg)](https://imgbb.com/) [![](https://casparcgforum.org/uploads/default/original/1X/2de97289bb4d415ce7a7ab19cc1ab931d7eb70e0.jpg)](https://imgbb.com/) [![](https://casparcgforum.org/uploads/default/original/1X/762652461a3c46b0588afc8a7551277dd1ae6d88.jpg)](https://imgbb.com/) [![](https://casparcgforum.org/uploads/default/original/1X/34cfbfab854c24de56e79c24a47c5098038cdebd.jpg)](https://imgbb.com/) [![](https://casparcgforum.org/uploads/default/original/1X/6285cec847b27f6624f7dd2fc11204fbae25aeda.jpg)](https://imgbb.com/) ---
**Author:** ![didikunz](https://casparcgforum.org/user_avatar/casparcgforum.org/didikunz/32/7_2.png) [@didikunz](https://casparcgforum.org/u/didikunz)\ **Post date:** [June 16, 2019, 10:12am UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/15 "2019-06-16T10:12:12Z")
Ok, thanks, you should set the preview to be on a separate channel, if possible, so, that it does not interfere with the main output. Then set a channel and layer on the ā€žAuto-Updateā€œ pane of the page property window. Then it should give you a set of working buttons. I probably need to add better default values to the code. ---
**Author:** ![ctc](https://casparcgforum.org/letter_avatar_proxy/v4/letter/c/97f17d/32.png) [@ctc](https://casparcgforum.org/u/ctc)\ **Post date:** [June 29, 2019, 1:07pm UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/16 "2019-06-29T13:07:01Z")
After restart everything run correct. Did you tried it with fields from dynamic XML files. ---
**Author:** ![ctc](https://casparcgforum.org/letter_avatar_proxy/v4/letter/c/97f17d/32.png) [@ctc](https://casparcgforum.org/u/ctc)\ **Post date:** [August 21, 2019, 6:46am UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/17 "2019-08-21T06:46:14Z")
Is it possible to run on LibreOffice or OpenOffice? ---
**Author:** ![didikunz](https://casparcgforum.org/user_avatar/casparcgforum.org/didikunz/32/7_2.png) [@didikunz](https://casparcgforum.org/u/didikunz)\ **Post date:** [August 21, 2019, 7:45am UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/18 "2019-08-21T07:45:33Z")
> [@ctc](#): > > Is it possible to run on LibreOffice or OpenOffice? As far as I know, they have their own Add On technology, that is not compatible to Excel. So the answer is no. ---
**Author:** ![KevinM](https://casparcgforum.org/letter_avatar_proxy/v4/letter/k/85e7bf/32.png) [@KevinM](https://casparcgforum.org/u/KevinM)\ **Post date:** [November 2, 2019, 4:20pm UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/20 "2019-11-02T16:20:00Z")
Nice Tool! Iā€™ve installed it. In ā€œListā€ worksheet everything works as expected. when I make a new worksheet, I dont get buttons in dashboard for that. I have set an output rage in the new worksheet, but no buttons in dashboard. any ideas what Iā€™m doing wrong? ---
**Author:** ![didikunz](https://casparcgforum.org/user_avatar/casparcgforum.org/didikunz/32/7_2.png) [@didikunz](https://casparcgforum.org/u/didikunz)\ **Post date:** [November 2, 2019, 5:10pm UTC](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401/21 "2019-11-02T17:10:00Z")
Open the sheet properties via the small button on the bottom right corner of one of the button groups. There you need to set a template and the style of the buttons. See the manual how to do this. [Next page](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401.md?page=2)