# Exporting Metadata for view in CSV/Excel

**URL:** <https://forums.plex.tv/t/exporting-metadata-for-view-in-csv-excel/835698>\
**Category:** Metadata & Adding Files\
**Tags:** server-linux, server-qnap\
**Created:** [March 25, 2023, 9:47pm UTC](https://forums.plex.tv/t/exporting-metadata-for-view-in-csv-excel/835698 "2023-03-25T21:47:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rp1989](https://avatars.discourse-cdn.com/v4/letter/r/74df32/32.png) [@rp1989](https://forums.plex.tv/u/rp1989)\
**Post date:** [March 25, 2023, 9:47pm UTC](https://forums.plex.tv/t/exporting-metadata-for-view-in-csv-excel/835698/1 "2023-03-25T21:47:02Z")

</div>

Server Version#: 4.103.2  
Device: QNAP TVS-H474

A SQLite query to extract metadata of your plex library. I wanted a way to view information about my media directly from the plex media library. I know there are softwares out there than can scan your raw media files but i need this information all in once place to easily filter on bits I wanted to check such as upgrading some of my lower quality videos etc. I have created the attached SQL script that extracts the data that i need:

Media Items ID  
Metadata Items ID  
Title (With Episode numbers and year)  
TV Show Title (With Season number and year)  
Library Name (With section ID)  
Duration  
File Size (MB)  
Bitrate (Kbps)  
Resolution  
Container  
Video Codec  
Audio Codec  
Audio Channels

I would really like to also display the play count for all plex users combined against each media file but I can’t figure out an accurate way to do this. Would appreciate some help on this if anyone is aware.  
[Plex\_Metadata\_Export\_Query.txt](https://forums.plex.tv/uploads/short-url/4RfE5W4I7D6PLDA4ToS6qsp6anT.txt) (3.4 KB)

I am aware Tautulli can readly do the above but it doesn’t work that great for TV Shows and you are limited to viewing 100 rows at a time.

---

<div class="post-metadata">

**Author:** ![tom80H](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/tom80h/32/19753_2.png) [@tom80H](https://forums.plex.tv/u/tom80H)\
**Post date:** [March 25, 2023, 11:12pm UTC](https://forums.plex.tv/t/exporting-metadata-for-view-in-csv-excel/835698/2 "2023-03-25T23:12:21Z")

</div>

Check out [WebTools-NG](https://forums.plex.tv/t/webtools-ng/598539) – that should cover what you’re looking for (and more).

---

<div class="post-metadata">

**Author:** ![SwiftPanda16](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/swiftpanda16/32/81839_2.png) [@SwiftPanda16](https://forums.plex.tv/u/SwiftPanda16)\
**Post date:** [March 26, 2023, 2:29am UTC](https://forums.plex.tv/t/exporting-metadata-for-view-in-csv-excel/835698/3 "2023-03-26T02:29:46Z")

</div>

> **[Exporter Guide](https://github.com/Tautulli/Tautulli/wiki/Exporter-Guide)**
>
> A Python based monitoring and tracking tool for Plex Media Server. - Tautulli/Tautulli

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\
**Post date:** [June 24, 2023, 2:30am UTC](https://forums.plex.tv/t/exporting-metadata-for-view-in-csv-excel/835698/4 "2023-06-24T02:30:26Z")

</div>

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