I actually found it here:
But will some info here.
It's using excel power query connecting to a web page:
I found this post (in German but the important bits should be understandable):
http://www.bigdata-unleashed.com/20140708/smarte-analyse-von-log-daten-mit-excel-und-elasticsearch
Haven't found any tutorial other than that one for elasticsearch, but as power query understand json. It should be relatively easy.
Haven't tried myself yet, but once I do, I'll post here if it requires more than the code shown in that blog post.
Thanks,
Isaac