# Kibana with Excel parameter file

**URL:** <https://discuss.elastic.co/t/kibana-with-excel-parameter-file/232206>\
**Category:** Kibana\
**Created:** [May 12, 2020, 10:53am UTC](https://discuss.elastic.co/t/kibana-with-excel-parameter-file/232206 "2020-05-12T10:53:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![balaji\_18](https://avatars.discourse-cdn.com/v4/letter/b/bbce88/32.png) [@balaji\_18](https://discuss.elastic.co/u/balaji_18)\
**Post date:** [May 12, 2020, 10:53am UTC](https://discuss.elastic.co/t/kibana-with-excel-parameter-file/232206/1 "2020-05-12T10:53:58Z")

</div>

Hi,  
Suppose if i do all the expression in Excel or CSV, is there any possible way to load that file as parameter file into kibana and call one variable  
(to call that expression) to show the results ?

Eg.

if there is an expression like sum of cars sold, is there any way to call this expression as an variable using the excel or CSV file ?

Please help me out.

Thank you!

---

<div class="post-metadata">

**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\
**Post date:** [May 13, 2020, 9:30am UTC](https://discuss.elastic.co/t/kibana-with-excel-parameter-file/232206/2 "2020-05-13T09:30:01Z")

</div>

Not sure to understand your question. CSVs don't store formulas but raw data that you will index in your cluster as it is.

If you want to compute derived values from raw data you can do that in many different ways depending on your requirements. You can compute that formula at ingest time using [Logstash ruby filter](https://www.elastic.co/guide/en/logstash/current/plugins-filters-ruby.html), or using a [script processor](https://www.elastic.co/guide/en/elasticsearch/reference/7.6/script-processor.html) in an [ingest pipeline](https://www.elastic.co/guide/en/elasticsearch/reference/7.6/ingest.html). Or you can use [scripted fields](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html) in Kibana that perform the computation at query time.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 10, 2020, 9:30am UTC](https://discuss.elastic.co/t/kibana-with-excel-parameter-file/232206/3 "2020-06-10T09:30:04Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.