# List only albums
**URL:** https://community.mp3tag.de/t/list-only-albums/10630
**Category:** General Discussion
**Created:** [August 11, 2010, 9:02am UTC](https://community.mp3tag.de/t/list-only-albums/10630 "2010-08-11T09:02:25Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@miomir](https://community.mp3tag.de/u/miomir)
#### Post date: [August 11, 2010, 9:02am UTC](https://community.mp3tag.de/t/list-only-albums/10630/1 "2010-08-11T09:02:25Z")
I would like to get a simple report from my mp3 music collection listing only album name, year and artist. To do that I tried to do the following:
Scan my music collection wih Mp3tag
Export the results into Excel
Use Excel's Advanced Filter option - Unique (records only) to eliminate multiple song entries for every album.
However, this does not work always too well and was wondering if anyone has a better solution for this.
---
### Author:  [@dano](https://community.mp3tag.de/u/dano)
#### Post date: [August 11, 2010, 10:54am UTC](https://community.mp3tag.de/t/list-only-albums/10630/2 "2010-08-11T10:54:01Z")
This gets you only one entry per album:
```
$filename(album.txt)$loop(%album%,1)%artist%; %album%; %year%
$loopend()
```
---
### Author:  [@kaokulk](https://community.mp3tag.de/u/kaokulk)
#### Post date: [December 7, 2010, 6:51pm UTC](https://community.mp3tag.de/t/list-only-albums/10630/3 "2010-12-07T18:51:52Z")
QUOTE (dano @ Aug 11 2010, 07:54) \<{POST\_SNAPBACK}\>
This gets you only one entry per album:
```
$filename(album.txt)$loop(%album%,1)%artist%; %album%; %year%
$loopend()
```
Awesome! I was looking for just such a thing.
I want to get rid of artists and albums that are close, but not exact. This will make it obvious.
Thanks!
---
### Author:  [@rungumprun](https://community.mp3tag.de/u/rungumprun)
#### Post date: [December 22, 2010, 6:43pm UTC](https://community.mp3tag.de/t/list-only-albums/10630/4 "2010-12-22T18:43:35Z")
I've had the same problem finding bad album fields, and this looks very promising. But what do I need to do to use it? I don't see a "report" feature anywhere. thanks.
---
### Author:  [@pone](https://community.mp3tag.de/u/pone)
#### Post date: [December 22, 2010, 7:07pm UTC](https://community.mp3tag.de/t/list-only-albums/10630/5 "2010-12-22T19:07:29Z")
> [@rungumprun](#):
>
> But what do I need to do to use it? I don't see a "report" feature anywhere. thanks.
That above is an export script
[https://docs.mp3tag.de/export](https://docs.mp3tag.de/export)
[https://docs.mp3tag.de/export](https://docs.mp3tag.de/export)
[https://docs.mp3tag.de/export](https://docs.mp3tag.de/export)
---
### Author:  [@rungumprun](https://community.mp3tag.de/u/rungumprun)
#### Post date: [December 23, 2010, 12:23am UTC](https://community.mp3tag.de/t/list-only-albums/10630/6 "2010-12-23T00:23:55Z")
Worked great! Thanks!