# Can I upload a csv file without timestamp to kibana?

**URL:** <https://discuss.elastic.co/t/can-i-upload-a-csv-file-without-timestamp-to-kibana/229700>\
**Category:** Kibana\
**Created:** [April 24, 2020, 5:27pm UTC](https://discuss.elastic.co/t/can-i-upload-a-csv-file-without-timestamp-to-kibana/229700 "2020-04-24T17:27:02Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![samnayak1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/samnayak1/32/67096_2.png) [@samnayak1](https://discuss.elastic.co/u/samnayak1)\
**Post date:** [April 24, 2020, 5:27pm UTC](https://discuss.elastic.co/t/can-i-upload-a-csv-file-without-timestamp-to-kibana/229700/1 "2020-04-24T17:27:02Z")

</div>

File could not be read

[illegal\_argument\_exception] Could not find a timestamp in the sample provided

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [April 24, 2020, 7:14pm UTC](https://discuss.elastic.co/t/can-i-upload-a-csv-file-without-timestamp-to-kibana/229700/2 "2020-04-24T19:14:02Z")

</div>

Hello,

Can you please tell me where were you trying to upload this CSV?

Thanks,  
Bhavya

---

<div class="post-metadata">

**Author:** ![samnayak1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/samnayak1/32/67096_2.png) [@samnayak1](https://discuss.elastic.co/u/samnayak1)\
**Post date:** [April 24, 2020, 7:25pm UTC](https://discuss.elastic.co/t/can-i-upload-a-csv-file-without-timestamp-to-kibana/229700/3 "2020-04-24T19:25:38Z")

</div>

I have mention it on the subject, In Kibana.

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [April 24, 2020, 8:39pm UTC](https://discuss.elastic.co/t/can-i-upload-a-csv-file-without-timestamp-to-kibana/229700/4 "2020-04-24T20:39:18Z")

</div>

Which part of Kibana? saved objects? maps? canvas?

If you could attach a screenshot - its easier for us to help you.  
Also please note - data is almost always ingested in Elasticsearch. We have limited capability for data ingestion (.json file upload) in Kibana and at present its on maps.

Thanks,  
Bhavya

---

<div class="post-metadata">

**Author:** ![samnayak1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/samnayak1/32/67096_2.png) [@samnayak1](https://discuss.elastic.co/u/samnayak1)\
**Post date:** [April 24, 2020, 9:00pm UTC](https://discuss.elastic.co/t/can-i-upload-a-csv-file-without-timestamp-to-kibana/229700/5 "2020-04-24T21:00:09Z")

</div>

Thanks for your help, Now I am able to upload that csv file without timestamp in Kibana. Could you please help me with another question? then via Elasticsearch also I should be able to ingest data without timestamp right? I have worked with elasticsearch and kibana before but mostly with csv file having date as a column but now I am trying to create index in Elasticsearch by ingesting text files. Will it be okay?

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [April 24, 2020, 10:11pm UTC](https://discuss.elastic.co/t/can-i-upload-a-csv-file-without-timestamp-to-kibana/229700/6 "2020-04-24T22:11:42Z")

</div>

Your data needs to be in .json format for you to ingest in elasticsearch.  
These docs should help you - [Getting started: Deploy your own platform to store, search, and visualize any data | Starting with the Elasticsearch Platform and its Solutions [8.11] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/getting-started.html)  
Also Kibana doesn't have the ability for user to upload a csv file. I am really confused by this in your response:

> [@samnayak1](#):
>
> hanks for your help, Now I am able to upload that csv file without timestamp in Kibana.

Thanks

---

<div class="post-metadata">

**Author:** ![samnayak1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/samnayak1/32/67096_2.png) [@samnayak1](https://discuss.elastic.co/u/samnayak1)\
**Post date:** [April 24, 2020, 10:34pm UTC](https://discuss.elastic.co/t/can-i-upload-a-csv-file-without-timestamp-to-kibana/229700/7 "2020-04-24T22:34:00Z")

</div>

Really, only .json file? I am not sure if we are on same page because I have many experiences injecting .csv files into Elastcisearch to create an index by running Logstash config file. You could verify my project from my github account.([https://github.com/sampanayak/ccfl-elastic.git](https://github.com/sampanayak/ccfl-elastic.git)).

Also regarding uploading .csv file please check the screen shot attached with this message, where I was able to upload the file and create an index pattern for that.

 ![kibana](https://us1.discourse-cdn.com/elastic/original/3X/7/d/7deae34648295e9d3c54355f60142501c9c1efc5.png) ![kibana](https://us1.discourse-cdn.com/elastic/original/3X/7/d/7deae34648295e9d3c54355f60142501c9c1efc5.png)

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [April 24, 2020, 10:55pm UTC](https://discuss.elastic.co/t/can-i-upload-a-csv-file-without-timestamp-to-kibana/229700/8 "2020-04-24T22:55:43Z")

</div>

Ah so you are trying to ingest it in machine learning. It makes sense now. Thanks for the screenshots. I was thinking of core Kibana apps. ML is solution and we have a tag for ML questions.  
This is a good blogpost for it - [https://www.elastic.co/blog/importing-csv-and-log-data-into-elasticsearch-with-file-data-visualizer](https://www.elastic.co/blog/importing-csv-and-log-data-into-elasticsearch-with-file-data-visualizer)

So when you are running logstash config file and uploading data into elasticsearch - logstash is converting the file into JSON and then uploading it. ES sees incoming json.

Thanks for your reply and please let me know if you have questions. Awesome project.

Cheers,  
Bhavya

---

<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:** [May 22, 2020, 10:55pm UTC](https://discuss.elastic.co/t/can-i-upload-a-csv-file-without-timestamp-to-kibana/229700/9 "2020-05-22T22:55:43Z")

</div>

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