# Reporting / Listing media

**URL:** <https://community.mp3tag.de/t/reporting-listing-media/52254>\
**Category:** Mac\
**Created:** [March 5, 2021, 6:27pm UTC](https://community.mp3tag.de/t/reporting-listing-media/52254 "2021-03-05T18:27:38Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![dkluis](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/fbc32d/32.png) [@dkluis](https://community.mp3tag.de/u/dkluis)\
**Post date:** [March 5, 2021, 6:27pm UTC](https://community.mp3tag.de/t/reporting-listing-media/52254/1 "2021-03-05T18:27:38Z")

</div>

The windows version support listing/reporting all media and attributes but I cannot find it in the mac version. I tried CMD+A and CMD+C to cut and paste all media info to try to copy it into a spreadsheet but that does not work.

Help, what is a workaround?

Thanks

---

<div class="post-metadata">

**Author:** ![Florian](https://community.mp3tag.de/user_avatar/community.mp3tag.de/florian/32/5759_2.png) [@Florian](https://community.mp3tag.de/u/Florian)\
**Post date:** [March 5, 2021, 6:33pm UTC](https://community.mp3tag.de/t/reporting-listing-media/52254/2 "2021-03-05T18:33:25Z")

</div>

Hi and welcome!

Can you see this topic, it might already shed some light into this 🙂

> [@Export in Mp3tag for Mac](https://community.mp3tag.de/t/export-in-mp3tag-for-mac/52098/2):
>
> I've moved your post to #mac from the German category slight_smile The Export currently exists in a slightly different way and only as hidden feature face_with_monocle If you select files in Mp3tag for Mac and copy via Cmd+C, a textual representation of the files is copied to the clipboard. You can modify the format of this textual representation using a [formatstring](https://community.mp3tag.de/t/format-strings-and-available-placeholders/51688) and the defaults command via Terminal.app defaults write app.mp3tag.Mp3tag CopyFormat '"%album%$char(9)%track%$char(9)%t…

---

<div class="post-metadata">

**Author:** ![dkluis](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/fbc32d/32.png) [@dkluis](https://community.mp3tag.de/u/dkluis)\
**Post date:** [March 6, 2021, 1:26pm UTC](https://community.mp3tag.de/t/reporting-listing-media/52254/3 "2021-03-06T13:26:13Z")

</div>

Thank you for that info. The single line select copies the info fine.

I am actually trying to copy all entries (~1150) in one go, but it only seems to copy the first one and ignores all others, even though I have selected / highlighted all of them.

---

<div class="post-metadata">

**Author:** ![dkluis](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/fbc32d/32.png) [@dkluis](https://community.mp3tag.de/u/dkluis)\
**Post date:** [March 6, 2021, 2:29pm UTC](https://community.mp3tag.de/t/reporting-listing-media/52254/4 "2021-03-06T14:29:27Z")

</div>

Correction: The copy and paste works if I copy it into Microsoft visual code but not when I copy it into Excel...

---

<div class="post-metadata">

**Author:** ![Florian](https://community.mp3tag.de/user_avatar/community.mp3tag.de/florian/32/5759_2.png) [@Florian](https://community.mp3tag.de/u/Florian)\
**Post date:** [March 6, 2021, 4:51pm UTC](https://community.mp3tag.de/t/reporting-listing-media/52254/5 "2021-03-06T16:51:39Z")

</div>

Maybe you'd need to adjust the format for Excel. What are you currently using?

---

<div class="post-metadata">

**Author:** ![dkluis](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/fbc32d/32.png) [@dkluis](https://community.mp3tag.de/u/dkluis)\
**Post date:** [March 6, 2021, 6:54pm UTC](https://community.mp3tag.de/t/reporting-listing-media/52254/6 "2021-03-06T18:54:07Z")

</div>

I am using the standard from the 1st answer.

```nohighlight
defaults write app.mp3tag.Mp3tag CopyFormat '"%album%$char(9)%track%$char(9)%title%$char(9)%artist%$char(9)%_length%$char(9)%discnumber%"'

```

---

<div class="post-metadata">

**Author:** ![Florian](https://community.mp3tag.de/user_avatar/community.mp3tag.de/florian/32/5759_2.png) [@Florian](https://community.mp3tag.de/u/Florian)\
**Post date:** [March 7, 2021, 9:34am UTC](https://community.mp3tag.de/t/reporting-listing-media/52254/7 "2021-03-07T09:34:37Z")

</div>

This looks good (I've adjusted the formatting).

Is this Excel on Windows? It might be that you'd need to paste via Microsoft Visual Code and copy the whole text from there.

---

<div class="post-metadata">

**Author:** ![dkluis](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/fbc32d/32.png) [@dkluis](https://community.mp3tag.de/u/dkluis)\
**Post date:** [March 7, 2021, 11:47am UTC](https://community.mp3tag.de/t/reporting-listing-media/52254/8 "2021-03-07T11:47:45Z")

</div>

Excel on Mac. I did the ms vc step and that worked.

---

<div class="post-metadata">

**Author:** ![Florian](https://community.mp3tag.de/user_avatar/community.mp3tag.de/florian/32/5759_2.png) [@Florian](https://community.mp3tag.de/u/Florian)\
**Post date:** [March 7, 2021, 3:30pm UTC](https://community.mp3tag.de/t/reporting-listing-media/52254/9 "2021-03-07T15:30:17Z")

</div>

OK, glad you got it working. I've also installed Excel to try this and it also accepts only the first line of many in my tests.

I have currently no idea on how to circumvent this (without the intermediate step through another text editor), but I'll keep an eye on it.