# Simple Client for Excel files **URL:** \ **Category:** General\ **Created:** [July 24, 2019, 5:41pm UTC](https://casparcgforum.org/t/simple-client-for-excel-files/2079 "2019-07-24T17:41:56Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Maurice78](https://casparcgforum.org/letter_avatar_proxy/v4/letter/m/edb3f5/32.png) [@Maurice78](https://casparcgforum.org/u/Maurice78)\ **Post date:** [July 24, 2019, 5:41pm UTC](https://casparcgforum.org/t/simple-client-for-excel-files/2079/1 "2019-07-24T17:41:56Z")
For a job i made a very simple but also very quick working client that imports Excel files. Idea very simple. Firstline of the excel file contains the template field names (like ‘f0’) all other excel lines contain the data to be shown. You can select one of these lines and show. Making data delivery by 3rd parties fast and easy to understand. Just for inspiration for all client builders here. if you like I am willing to share big thankyou to team “superfly” for making casparcg-connection ![image](https://casparcgforum.org/uploads/default/original/1X/cf10aeae086a7059e2fa3a4add25cda47bafea95.png) ---
**Author:** ![didikunz](https://casparcgforum.org/user_avatar/casparcgforum.org/didikunz/32/7_2.png) [@didikunz](https://casparcgforum.org/u/didikunz)\ **Post date:** [July 24, 2019, 7:58pm UTC](https://casparcgforum.org/t/simple-client-for-excel-files/2079/2 "2019-07-24T19:58:59Z")
Have you seen [this](https://casparcgforum.org/t/casparcgaddin-for-microsoft-excel/1401)? Whit it you can do the same from whit in Excel itself. And you can use all sort of formulas and stuff… ---
**Author:** ![Maurice78](https://casparcgforum.org/letter_avatar_proxy/v4/letter/m/edb3f5/32.png) [@Maurice78](https://casparcgforum.org/u/Maurice78)\ **Post date:** [July 24, 2019, 8:33pm UTC](https://casparcgforum.org/t/simple-client-for-excel-files/2079/3 "2019-07-24T20:33:58Z")
Yep i guess it was a source off inspiration 😉 Really like your plug-in / approach !! 👍 My approach here was to make it “ultra” simple / very basic. As it fit’s more in the operation i made it for. yes it is certainly less versatile then your plug-in. ---
**Author:** ![didikunz](https://casparcgforum.org/user_avatar/casparcgforum.org/didikunz/32/7_2.png) [@didikunz](https://casparcgforum.org/u/didikunz)\ **Post date:** [July 25, 2019, 10:59am UTC](https://casparcgforum.org/t/simple-client-for-excel-files/2079/4 "2019-07-25T10:59:07Z")
> [@Maurice78](#): > > Yep i guess it was a source off inspiration 😉 That is nice to hear, thanks. > [@Maurice78](#): > > My approach here was to make it “ultra” simple / very basic. > As it fit’s more in the operation i made it for. Mine was to make it as flexible as possible, so that “power” users of Excel can use all of their know how to shape data the way they need it. The price is, that it’s not so easy to use. I just reticently made a quick client for live subtitling of an opera (!) that imports Excel data and updates a simple template. So, as you said, sometimes the best approach is to build something for a particular use case. ---
**Author:** ![ctc](https://casparcgforum.org/letter_avatar_proxy/v4/letter/c/97f17d/32.png) [@ctc](https://casparcgforum.org/u/ctc)\ **Post date:** [July 26, 2019, 8:37am UTC](https://casparcgforum.org/t/simple-client-for-excel-files/2079/5 "2019-07-26T08:37:57Z")
Hi Maurice78, It looks very useful. Will be great if you share it. Thank you in advance. ---
**Author:** ![Maurice78](https://casparcgforum.org/letter_avatar_proxy/v4/letter/m/edb3f5/32.png) [@Maurice78](https://casparcgforum.org/u/Maurice78)\ **Post date:** [July 29, 2019, 7:45am UTC](https://casparcgforum.org/t/simple-client-for-excel-files/2079/6 "2019-07-29T07:45:10Z")
When I find time I will clean it up a bit and post it here ---
**Author:** ![timmalos](https://casparcgforum.org/letter_avatar_proxy/v4/letter/t/9fc348/32.png) [@timmalos](https://casparcgforum.org/u/timmalos)\ **Post date:** [July 30, 2019, 1:48pm UTC](https://casparcgforum.org/t/simple-client-for-excel-files/2079/7 "2019-07-30T13:48:02Z")
sounds very interesting , what is the language you used ? Would be even more interesting to be able to work on gsheet (for my needs 🙂 since anyone can update it at any time during the show way easier than an excel file.) On my side I worked on a node-js interface that was using google API to retrieve data from gsheet, then update casparcg template in real time. Never finished and it stayed a demo purpose, but interesting enough ---
**Author:** ![didikunz](https://casparcgforum.org/user_avatar/casparcgforum.org/didikunz/32/7_2.png) [@didikunz](https://casparcgforum.org/u/didikunz)\ **Post date:** [July 30, 2019, 8:33pm UTC](https://casparcgforum.org/t/simple-client-for-excel-files/2079/8 "2019-07-30T20:33:06Z")
You could use a power query in Excel to pull the data from gsheet and my AddIn to update a Caspar template with the data. ---
**Author:** ![Maurice78](https://casparcgforum.org/letter_avatar_proxy/v4/letter/m/edb3f5/32.png) [@Maurice78](https://casparcgforum.org/u/Maurice78)\ **Post date:** [September 7, 2019, 9:23am UTC](https://casparcgforum.org/t/simple-client-for-excel-files/2079/9 "2019-09-07T09:23:29Z")
> **[MauriceVeraart/XLStoCCG](https://github.com/MauriceVeraart/XLStoCCG)** > > Easy Excel Client for CasparCG. Contribute to MauriceVeraart/XLStoCCG development by creating an account on GitHub. here it is 😉 i am by far not the best coder soo stuff can be ugly inside 😉 feel free to use or change ls Maurice ---
**Author:** ![Maurice78](https://casparcgforum.org/letter_avatar_proxy/v4/letter/m/edb3f5/32.png) [@Maurice78](https://casparcgforum.org/u/Maurice78)\ **Post date:** [September 7, 2019, 9:24am UTC](https://casparcgforum.org/t/simple-client-for-excel-files/2079/10 "2019-09-07T09:24:59Z")
Any hints to do things simpler / better are very welcome ---
**Author:** ![ctc](https://casparcgforum.org/letter_avatar_proxy/v4/letter/c/97f17d/32.png) [@ctc](https://casparcgforum.org/u/ctc)\ **Post date:** [September 18, 2019, 8:13am UTC](https://casparcgforum.org/t/simple-client-for-excel-files/2079/11 "2019-09-18T08:13:04Z")
Hi Maurice78, Thanks for sharing, but I’ve got a little problem. When i test it there is a error: > 20 error code ELIFECYCLE > 21 error errno 1 > 22 error xlstoccg@1.0.2 unit: `karma start test/unit/karma.conf.js` > 22 error Exit status 1 > 23 error Failed at the xlstoccg@1.0.2 unit script. > 23 error This is probably not a problem with npm. There is likely additional logging output above. > 24 verbose exit [1, true] When i try to play a template server back error too: > [2019-09-18 10:57:38.257] [1560] [info] Sent message to 127.0.0.1: 400 ERROR\r\nREQ 2lgtvxn CG 1-20 ADD 1 “FOOTBALL\Ploch” 1 “{}”\r\n May be I do something wrong? ---
**Author:** ![Maurice78](https://casparcgforum.org/letter_avatar_proxy/v4/letter/m/edb3f5/32.png) [@Maurice78](https://casparcgforum.org/u/Maurice78)\ **Post date:** [September 20, 2019, 4:47pm UTC](https://casparcgforum.org/t/simple-client-for-excel-files/2079/12 "2019-09-20T16:47:48Z")
hmm did you use NPM or YARN to install package’s ? i used yarn. is there a template named “FOOTBALL\Ploch” in your template folder. i will put a example excel file in the repo later. maybe it is formatted different then it supposed to. grt maurie ---
**Author:** ![7sorkr](https://casparcgforum.org/user_avatar/casparcgforum.org/7sorkr/32/2372_2.png) [@7sorkr](https://casparcgforum.org/u/7sorkr)\ **Post date:** [January 17, 2024, 3:08am UTC](https://casparcgforum.org/t/simple-client-for-excel-files/2079/13 "2024-01-17T03:08:28Z")
Intuitive and powerful. I like that I can see the template value intuitively.