# Process Xlsx files using Ingest Attachment Processor Plugin

**URL:** <https://discuss.elastic.co/t/process-xlsx-files-using-ingest-attachment-processor-plugin/65893>\
**Category:** Elasticsearch\
**Created:** [November 13, 2016, 5:06am UTC](https://discuss.elastic.co/t/process-xlsx-files-using-ingest-attachment-processor-plugin/65893 "2016-11-13T05:06:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guruprasad\_Prabhu](https://avatars.discourse-cdn.com/v4/letter/g/6de8d8/32.png) [@Guruprasad\_Prabhu](https://discuss.elastic.co/u/Guruprasad_Prabhu)\
**Post date:** [November 13, 2016, 5:06am UTC](https://discuss.elastic.co/t/process-xlsx-files-using-ingest-attachment-processor-plugin/65893/1 "2016-11-13T05:06:16Z")

</div>

I am new to ES and have just started exploring .I have a requirement to read MS office documents like excel, doc ,msg etc. I tried processing excel document using below code

$params = [  
'index' =\> 'index',  
'type' =\> 'type',  
'id' =\> 'document\_id',  
'pipeline' =\> 'attachment',  
'body' =\> [  
'content' =\> base64\_encode(file\_get\_contents('a.xlsx'))  
]  
];  
$response1= $client-\>index($params);

It is getting success but all the excel content is stored in one field.

Is it possible to split the data column wise key pair values (column name as key and column value as value) using this plug in?

Thanks in advance

-Guru

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [November 13, 2016, 9:10am UTC](https://discuss.elastic.co/t/process-xlsx-files-using-ingest-attachment-processor-plugin/65893/2 "2016-11-13T09:10:10Z")

</div>

No it's not.  
You should export your doc as CSV instead.

---

<div class="post-metadata">

**Author:** ![Guruprasad\_Prabhu](https://avatars.discourse-cdn.com/v4/letter/g/6de8d8/32.png) [@Guruprasad\_Prabhu](https://discuss.elastic.co/u/Guruprasad_Prabhu)\
**Post date:** [November 13, 2016, 12:40pm UTC](https://discuss.elastic.co/t/process-xlsx-files-using-ingest-attachment-processor-plugin/65893/3 "2016-11-13T12:40:19Z")

</div>

Do you suggest to use logastash for importing CSVs?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [November 13, 2016, 12:59pm UTC](https://discuss.elastic.co/t/process-xlsx-files-using-ingest-attachment-processor-plugin/65893/4 "2016-11-13T12:59:14Z")

</div>

Yes. Or some grok processor with ingest but will be less efficient.

---

<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:** [December 11, 2016, 12:59pm UTC](https://discuss.elastic.co/t/process-xlsx-files-using-ingest-attachment-processor-plugin/65893/5 "2016-12-11T12:59:50Z")

</div>

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