# Simple export to spreadsheet **URL:** \ **Category:** Support\ **Created:** [December 7, 2023, 2:29pm UTC](https://community.mp3tag.de/t/simple-export-to-spreadsheet/63036 "2023-12-07T14:29:05Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![JohnMacLean](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/j/e56c9b/32.png) [@JohnMacLean](https://community.mp3tag.de/u/JohnMacLean)\ **Post date:** [December 7, 2023, 2:29pm UTC](https://community.mp3tag.de/t/simple-export-to-spreadsheet/63036/1 "2023-12-07T14:29:05Z")
I wish to export a list of Albums to a spreadsheet. Nothing else - I can manage without Artists, Filenames, Composers or anything else. Just Albums is fine. I've looked through the FAQ and I see that there are export scripts but I don't understand how to use them. Is there a simple instruction that I can use to copy the list of Albums? ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [December 7, 2023, 2:34pm UTC](https://community.mp3tag.de/t/simple-export-to-spreadsheet/63036/2 "2023-12-07T14:34:48Z")
> [@JohnMacLean](#): > > I see that there are export scripts but I don't understand how to use them. See the documentation: > **[Exporting Tag and File Information – Mp3tag Documentation](https://docs.mp3tag.de/export/)** > > Documentation on exporting tag and file information to text-based file formats. Mp3tag is the universal Tag Editor. ---
**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:** [December 7, 2023, 4:15pm UTC](https://community.mp3tag.de/t/simple-export-to-spreadsheet/63036/3 "2023-12-07T16:15:57Z")
> [@JohnMacLean](#): > > I wish to export a list of Albums to a spreadsheet. The CSV export configuration that comes with Mp3tag is a good starting point. You can use it to create a `*.csv` file and import the resulting file to your spreadsheet application. It exports more information than album only, but you can edit the export configuration as outlined in [Editing Export Configurations](https://docs.mp3tag.de/export/#editing-export-configurations) if you need to. ---
**Author:** ![JohnMacLean](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/j/e56c9b/32.png) [@JohnMacLean](https://community.mp3tag.de/u/JohnMacLean)\ **Post date:** [December 7, 2023, 8:30pm UTC](https://community.mp3tag.de/t/simple-export-to-spreadsheet/63036/4 "2023-12-07T20:30:45Z")
Many thanks. That seems to be what I first tried, but I got a message: “cannot create xxx.csv” This time I tried it, it has worked. I don’t know what I did wrongly the first time, but I now have the information I want. Thank you for your prompt response! ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [December 8, 2023, 6:46am UTC](https://community.mp3tag.de/t/simple-export-to-spreadsheet/63036/5 "2023-12-08T06:46:21Z")
> [@JohnMacLean](#): > > This time I tried it, it has worked Now that you know how to handle an export script, I come back to > [@JohnMacLean](#): > > I wish to export a list of Albums to a spreadsheet. Nothing else - I can manage without Artists, Filenames, Composers or anything else. Just Albums is fine. I could offer this export script that does not create anything but a list of albums: ```auto $filename(album_export.csv,utf-8)Album $loop(%album%,1)%album% $loopend() ``` Please note that if you have albums titled like "Greatest Hits" for several artists, then you need more sort criteria than just the album name. ---
**Author:** ![JohnMacLean](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/j/e56c9b/32.png) [@JohnMacLean](https://community.mp3tag.de/u/JohnMacLean)\ **Post date:** [December 8, 2023, 7:03pm UTC](https://community.mp3tag.de/t/simple-export-to-spreadsheet/63036/6 "2023-12-08T19:03:53Z")
That looks exactly what I wanted, and I guessed it would look something like that. However, I don't **know how to handle an export script** , because I have no idea where to enter that text. Is it within the Mp3tag program? In the Windows box at the bottom of my screen? Somewhere else? When I select File/Export I didn't see a place to enter a script but I don't know which other menu to look in. Also, do I type "$Filename" or is that a placeholder for the actual name of a file? I only got the required result by accepting the default File/Export option (second time round but not first time). Fortunately, I am experienced enough with text handling in Excel to separate the Album names from the other fields and deal with unwanted repetition easily. ---
**Author:** ![LyricsLover](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/l/c6cbf5/32.png) [@LyricsLover](https://community.mp3tag.de/u/LyricsLover)\ **Post date:** [December 8, 2023, 7:45pm UTC](https://community.mp3tag.de/t/simple-export-to-spreadsheet/63036/7 "2023-12-08T19:45:12Z")
> [@JohnMacLean](#): > > because I have no idea where to enter that text. > Is it within the Mp3tag program? File -\> Export -\> CSV (example export file) -\> Click on the second icon called "Edit": ![image](https://community.mp3tag.de/uploads/default/original/2X/f/fc9d03e9eb70645cd4b163128b0a953514810b84.png) Your default text editor (assigned to the file extension \*.txt) will be loaded and there your can edit the script. Don't forget to save your modifications. This will be explained in the already suggested help: ![image](https://community.mp3tag.de/uploads/default/original/2X/d/d414662a92fe1098252d6f0888d11ceafd5d52df.png) ---
**Author:** ![system](https://community.mp3tag.de/uploads/default/original/2X/c/ce7035d426cb755a7916793326d23b465222a407.png) [@system](https://community.mp3tag.de/u/system)\ **Post date:** [January 7, 2024, 7:45pm UTC](https://community.mp3tag.de/t/simple-export-to-spreadsheet/63036/8 "2024-01-07T19:45:37Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.