# Create empty field in report / upload comments from excel **URL:** \ **Category:** Kibana\ **Created:** [August 3, 2023, 7:13am UTC](https://discuss.elastic.co/t/create-empty-field-in-report-upload-comments-from-excel/340006 "2023-08-03T07:13:06Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Valerija](https://avatars.discourse-cdn.com/v4/letter/v/e9bcb4/32.png) [@Valerija](https://discuss.elastic.co/u/Valerija)\ **Post date:** [August 3, 2023, 7:13am UTC](https://discuss.elastic.co/t/create-empty-field-in-report-upload-comments-from-excel/340006/1 "2023-08-03T07:13:06Z")
Hello, I am supposed to create three empty columns in existing report and give possibility to users to upload comments in those columns from excel. ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/8/c86423497f044b72d1d6a53b77e401373b9ffdcd.png) I would appreciate if someone could tell me if this is feasible and give me some hints. Thank you in advance. Regards. Valerija ---
**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\ **Post date:** [August 3, 2023, 1:40pm UTC](https://discuss.elastic.co/t/create-empty-field-in-report-upload-comments-from-excel/340006/2 "2023-08-03T13:40:21Z")
Hi @Valerija. I think updating Elasticsearch documents from Excel would be a very complex task. I think Excel still uses Visual Basic for programming. Elasticsearch does not have a Visual Basic client. Does Excel support the .NET language? There is an [Elasticsearch .NET client](https://www.elastic.co/guide/en/elasticsearch/client/net-api/current/index.html). The code would likely use the [`client.UpdateAsync` method](https://www.elastic.co/guide/en/elasticsearch/client/net-api/current/examples.html#updating-net). We've discussed adding [edit capabilities to the Discover app](https://github.com/elastic/kibana/issues/36556) in Kibana. But we not added this functionality yet. ---
**Author:** ![Valerija](https://avatars.discourse-cdn.com/v4/letter/v/e9bcb4/32.png) [@Valerija](https://discuss.elastic.co/u/Valerija)\ **Post date:** [August 4, 2023, 6:53am UTC](https://discuss.elastic.co/t/create-empty-field-in-report-upload-comments-from-excel/340006/3 "2023-08-04T06:53:52Z")
Hi @nickpeihl, Thank you for explaining. I assumed this would not be easy. I am glad you are discussing adding edit capabilities. I am thinking just then to add those three columns with column titles w/o any data as a reminder to fill in data manually once they export the report into excel. How could I create empty column in Kibana? Thanks. ---
**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\ **Post date:** [August 4, 2023, 2:27pm UTC](https://discuss.elastic.co/t/create-empty-field-in-report-upload-comments-from-excel/340006/4 "2023-08-04T14:27:01Z")
Hi @Valerija. I assume you are using the Discover app to generate the CSV reports? Does your index mapping include the `sku`, `Immediate Action`, `PIC`, and `status` fields? I did a simple test where I created an index with a mapping of three fields. I then added documents to the index but did not specify a value for one of the fields (`nothing`). Then, in Discover I added all the fields to the table by clicking the "Add field to table" button for each field. See the screenshot below. Then I ran the CSV report and the report contained all three fields. The `nothing` field in the report shows only a `-`. Discover: ![Screenshot 2023-08-04 at 10.13.32 AM](https://us1.discourse-cdn.com/elastic/original/3X/1/6/163431319f6c1dd4b5457f4a6936b18c7dd63951.png) Report: ![Screenshot 2023-08-04 at 10.26.01 AM](https://us1.discourse-cdn.com/elastic/original/3X/6/8/68819630b16549ae3b83d30c92c89546ef5020cd.png) ---
**Author:** ![Valerija](https://avatars.discourse-cdn.com/v4/letter/v/e9bcb4/32.png) [@Valerija](https://discuss.elastic.co/u/Valerija)\ **Post date:** [August 8, 2023, 8:41am UTC](https://discuss.elastic.co/t/create-empty-field-in-report-upload-comments-from-excel/340006/5 "2023-08-08T08:41:01Z")
Hello @nickpeihl , My index mapping does not contain columns _Immediate Acton_, _PIC_, and _Status_. These are not available in mapping but the users would like to have them and populate them in excel manually and then just upload to Kibana report. For that reason I am unable to do what you described above...we are still on 7.10 version so I am not sure if what you described is a new functionality. I am quite new to Kibana so I am still learning... ---
**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\ **Post date:** [August 8, 2023, 2:00pm UTC](https://discuss.elastic.co/t/create-empty-field-in-report-upload-comments-from-excel/340006/6 "2023-08-08T14:00:18Z")
Hi @Valerija. There is no easy way to accomplish what you are asking. Sorry. ---
**Author:** ![Valerija](https://avatars.discourse-cdn.com/v4/letter/v/e9bcb4/32.png) [@Valerija](https://discuss.elastic.co/u/Valerija)\ **Post date:** [August 8, 2023, 8:00pm UTC](https://discuss.elastic.co/t/create-empty-field-in-report-upload-comments-from-excel/340006/7 "2023-08-08T20:00:04Z")
No worries...thank you very much for all. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 5, 2023, 8:01pm UTC](https://discuss.elastic.co/t/create-empty-field-in-report-upload-comments-from-excel/340006/8 "2023-09-05T20:01:00Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.