# Import \`integer\_range\` from CSV with kibana \`Visualize data from a file\`?

**URL:** <https://discuss.elastic.co/t/import-integer-range-from-csv-with-kibana-visualize-data-from-a-file/323765>\
**Category:** Kibana\
**Created:** [January 23, 2023, 9:14pm UTC](https://discuss.elastic.co/t/import-integer-range-from-csv-with-kibana-visualize-data-from-a-file/323765 "2023-01-23T21:14:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![learningelastic](https://avatars.discourse-cdn.com/v4/letter/l/958977/32.png) [@learningelastic](https://discuss.elastic.co/u/learningelastic)\
**Post date:** [January 23, 2023, 9:14pm UTC](https://discuss.elastic.co/t/import-integer-range-from-csv-with-kibana-visualize-data-from-a-file/323765/1 "2023-01-23T21:14:13Z")

</div>

Is it possible for the `Machine Learning>Data Visualizer>Visualize data from file` to import a csv file where one of the columns is an `integer_range`? If so, what is the syntax that should be used in the `integer_range` column of the csv file?

For example, this is my csv file:

```auto
price_range,customertype
"{""lte"":5}",regular
"{""gt"":5}",premium

```

During import, these are my advance settings:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/b/db720267592bea8e5d24e848f93480020596d1c8.png)

And it produced this error:

```auto
0: failed to parse field [price_range] of type [integer_range] in document with id 'qGaN4IUB7CKCUde2IlRH'. Preview of field's value: '{"lte":5}'

{"message":"\"{\"\"lte\"\":5}\",regular"}

```

---

<div class="post-metadata">

**Author:** ![learningelastic](https://avatars.discourse-cdn.com/v4/letter/l/958977/32.png) [@learningelastic](https://discuss.elastic.co/u/learningelastic)\
**Post date:** [January 24, 2023, 2:00am UTC](https://discuss.elastic.co/t/import-integer-range-from-csv-with-kibana-visualize-data-from-a-file/323765/2 "2023-01-24T02:00:55Z")

</div>

I added

```auto
    {
      "json" : {
        "field" : "price_range"
      }
    },

```

to the ingestion pipeline and everything worked!

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/6/a638e1e98cd10bd6d0699be2f973f8e5537f60a3.png)

---

<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:** [February 21, 2023, 2:01am UTC](https://discuss.elastic.co/t/import-integer-range-from-csv-with-kibana-visualize-data-from-a-file/323765/3 "2023-02-21T02:01:28Z")

</div>

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