# Timelion sheets exports for reuse on another Kibana instance

**URL:** <https://discuss.elastic.co/t/timelion-sheets-exports-for-reuse-on-another-kibana-instance/49053>\
**Category:** Kibana\
**Tags:** timelion\
**Created:** [May 3, 2016, 12:04pm UTC](https://discuss.elastic.co/t/timelion-sheets-exports-for-reuse-on-another-kibana-instance/49053 "2016-05-03T12:04:53Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lou](https://avatars.discourse-cdn.com/v4/letter/l/ea666f/32.png) [@Lou](https://discuss.elastic.co/u/Lou)\
**Post date:** [May 3, 2016, 12:04pm UTC](https://discuss.elastic.co/t/timelion-sheets-exports-for-reuse-on-another-kibana-instance/49053/1 "2016-05-03T12:04:53Z")

</div>

Hello,

everything is in the title 😋

I have some saved sheets in my Kibana instance, and would like to find a way to take them (where are them saved ??) and put them in another Kibana installation on another PC...

Your ideas/suggestions are very welcome.

Have a great day.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [May 4, 2016, 12:55am UTC](https://discuss.elastic.co/t/timelion-sheets-exports-for-reuse-on-another-kibana-instance/49053/2 "2016-05-04T00:55:49Z")

</div>

All the things it saves are in the `.kibana` index.

There is an export option in the settings tab that should do the trick.

---

<div class="post-metadata">

**Author:** ![Lou](https://avatars.discourse-cdn.com/v4/letter/l/ea666f/32.png) [@Lou](https://discuss.elastic.co/u/Lou)\
**Post date:** [May 4, 2016, 8:54am UTC](https://discuss.elastic.co/t/timelion-sheets-exports-for-reuse-on-another-kibana-instance/49053/3 "2016-05-04T08:54:41Z")

</div>

Hello Warkolm,

thank you for your reply.

I found the timelion-sheet Type in the .kibana index: with a simple RestApi http call, I was able to delete a saved sheet easily, like this: GET localhost:9200/.kibana/timelio-sheet/MySavedSheetId

Unfortunately, as I have no objects in the Settings/Objects tab, I was not able to export a sheet.

I suspect I could do this by using the RestApi again, I am still searching for a solution and will keep posted interested readers here.

Have a great day.

---

<div class="post-metadata">

**Author:** ![Lou](https://avatars.discourse-cdn.com/v4/letter/l/ea666f/32.png) [@Lou](https://discuss.elastic.co/u/Lou)\
**Post date:** [May 9, 2016, 3:10pm UTC](https://discuss.elastic.co/t/timelion-sheets-exports-for-reuse-on-another-kibana-instance/49053/4 "2016-05-09T15:10:34Z")

</div>

Hi there,

here I am again: I made a mistake in my last POST...  
If you want to delete a timelion-sheet, you should send a "DELETE" (and not "GET") http request, like this:  
DELETE localhost:9200/.kibana/timelion-sheet/MySavedSheetId

My apologies 🙂

---

<div class="post-metadata">

**Author:** ![Lou](https://avatars.discourse-cdn.com/v4/letter/l/ea666f/32.png) [@Lou](https://discuss.elastic.co/u/Lou)\
**Post date:** [May 9, 2016, 3:42pm UTC](https://discuss.elastic.co/t/timelion-sheets-exports-for-reuse-on-another-kibana-instance/49053/5 "2016-05-09T15:42:18Z")

</div>

Back again:

if you want to export/import a timelion sheet, using the restApi, try this !

Export (get the content of your sheet, as seen above):  
GET localhost:9200/.kibana/timelio-sheet/MySavedSheetId

Import:  
take the content your export, but just keep the elements under "source", and put it like this in your destination Kibana instance:  
PUT [http://localhost:9200/.kibana/timelion-sheet/ImportedTestSheet](http://localhost:9200/.kibana/timelion-sheet/ImportedTestSheet)  
JSON content of this http PUT request:  
{  
"title": "ImportedTestSheet",  
"hits": 0,  
"description": "",  
"timelion\_sheet": [".es(index='jmeter\_tir3',avg:ResponseTimeMs).label('Tir3').title(title='Response Time (ms)'),.es(index='jmeter\_tir4',avg:ResponseTimeMs,offset=-11m).label('Tir4')",  
".es(index='jmeter\_tir3',avg:Bytes).label('Tir3').title(title='Bytes Per Request'),.es(index='jmeter\_tir4',avg:Bytes,offset=-11m).label('Tir4')",  
".es(index='jmeter\_tir3',avg:Error).label('Tir3').title(title='Errors/s'),.es(index='jmeter\_tir4',avg:Error,offset=-11m).label('Tir4')",  
".es(index='jmeter\_tir3').label('Tir3').title(title='Hits/s'),.es(index='jmeter\_tir4',offset=-11m).label('Tir4')"],  
"timelion\_interval": "1s",  
"timelion\_other\_interval": "1d",  
"timelion\_chart\_height": 275,  
"timelion\_columns": 2,  
"timelion\_rows": 2,  
"version": 1  
}

In this example, the Timelion code used in this sheet was (just to help you read the JSON content above ):  
.es(index='jmeter\_tir3',avg:ResponseTimeMs).label('Tir3').title(title='Response Time (ms)'),.es(index='jmeter\_tir4',avg:ResponseTimeMs,offset=-11m).label('Tir4')

Hope this could help 🙂

---

<div class="post-metadata">

**Author:** ![pavithrakc](https://avatars.discourse-cdn.com/v4/letter/p/a6a055/32.png) [@pavithrakc](https://discuss.elastic.co/u/pavithrakc)\
**Post date:** [April 5, 2017, 3:28pm UTC](https://discuss.elastic.co/t/timelion-sheets-exports-for-reuse-on-another-kibana-instance/49053/6 "2017-04-05T15:28:54Z")

</div>

GET .kibana/timelion-sheet/MySavedSheetId

This is not working. It gives me an output of

{  
"\_index": ".kibana",  
"\_type": "timelion-sheet",  
"\_id": "MySavedSheetId",  
"found": false  
}

Nothing found.

I have one saved under Timelion. How to export the timesheets?

---

<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:** [July 6, 2017, 1:32pm UTC](https://discuss.elastic.co/t/timelion-sheets-exports-for-reuse-on-another-kibana-instance/49053/7 "2017-07-06T13:32:25Z")

</div>


