# Export collection data in excel or csv

**URL:** <https://discourse.getcockpit.com/t/export-collection-data-in-excel-or-csv/1889>\
**Category:** Support\
**Created:** [March 30, 2021, 11:51am UTC](https://discourse.getcockpit.com/t/export-collection-data-in-excel-or-csv/1889 "2021-03-30T11:51:22Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![raffaelj](https://yyz2.discourse-cdn.com/flex030/user_avatar/discourse.getcockpit.com/raffaelj/32/331_2.png) [@raffaelj](https://discourse.getcockpit.com/u/raffaelj)\
**Post date:** [April 6, 2021, 11:39am UTC](https://discourse.getcockpit.com/t/export-collection-data-in-excel-or-csv/1889/3 "2021-04-06T11:39:09Z")

</div>

> [@dipakmali1993](#):
>
> @lang(‘Export Data’)
> 
> using above code to download the data

Common, using backticks or [fenced code blocks](https://github.github.com/gfm/#fenced-code-blocks) isn’t that hard. I had to “edit” your post with moderator rights to be able to see your html code. Double posting the same html doesn’t help either.

**Translation for other readers:** @dipakmali1993 clicked on the link “Export Data” in entries view and posted the html source code of that link - which of course is displayed as html.

> [@dipakmali1993](#):
>
> getting json data in excel file

I won’t explain, how to use Excel. There are other forums and manuals around.

> [@dipakmali1993](#):
>
> i m trying to export collection data in excel , csv format.

How the database system works:

> [@I need help to understand Cockpit, database concepts and query system](https://discourse.getcockpit.com/t/i-need-help-to-understand-cockpit-database-concepts-and-query-system/815/4):
>
> Cockpit is written to work with MongoDB and it has a wrapper ([MongoLite](https://github.com/agentejo/cockpit/tree/next/lib/MongoLite)) to use SQLite with MongoDB syntax. When you use it with SQLite, you can’t use the familiar SQL queries anymore. You have to use mongo queries. Cockpit passes the filters (nearly) directly to MongoDB , so while using Cockpit, you learn the mongo syntax along the way. MongoLite passes custom functions to SQLite to filter the stored json strings. It is not fully implemented, so if you miss some very unique filter options or f…

How to export as xls/xlsx/ods/csv:

> [@Export collection as excel/csv](https://discourse.getcockpit.com/t/export-collection-as-excel-csv/1579):
>
> Hello guys, I’m trying to find a way to export collection entries as excel/csv and not json. Does anybody knows a way to do that? Thank’s for your help!

Again: This was the first search result for “export excel” 😉 To be fair - searching for “export csv” doesn’t list that thread for some reason…

PS: You leaked the mail address of your colleague in your screenshot.

---

_[View the full topic](https://discourse.getcockpit.com/t/export-collection-data-in-excel-or-csv/1889)._