HI, I’m looking to export a used playlist to a file, maybe excel so I can look back and see when I played a particular song. I can see how to do it, save as etc but don’t see an Excel option and the TXT file always comes out blank, although there’s are rows in there but it doesn’t display any text at all.
Open to suggestions on how I can do this 
Nige
Hello Nige,
you can set up your own custom text playlist export file here:
The logging variables are listed in our Wiki:
https://wiki.mairlist.com/reference:logging_variables
So you can create a *.txt file in a csv format that can be imported in Excel.
Ah, Ok thank you, I’ve sort of worked it out and came up with this which seems to work apart from the date comes up with the date of 30/12/99 and not todays date for some reason, sorry if I’m being thick 
Nige
Hello Nige,
using camera pictures from your screen is not very helpful.
Would you mind copying (a part of) the text of the file in the forum, eventually formatted as code?
Thank you,
Uli
Ok sorry if it wasn’t clear. I added this in the " Format for custom text playlist export" section %a,%b,%D,%M,%y
And this is how its displaying. the song is there etc but the date is wrong…
Song 1) Moodswings - Spititual High (State of ind),Spititual High (State of ind) - 1992,30,12,99
Song 2) Joshua Kaddison,“Jessie” - A3 F 1994,30,12,99
Song 3) Dan Fogelberg,Same Old Lang Syne - 1980,30,12,99
Tested with this format in the configuration:
Jessy Matador,Allez Ola Olé [Electro House Mix],29,12,21
Martin Solveig feat. Alma,All Stars,29,12,21
Kylie Minogue,All The Lovers,29,12,21
Stromae,Alors on Danse,29,12,21
Samantha James,Amber Sky,29,12,21
A Reminiscent Drive,Ambrosia,29,12,21
I am wondering where the - comes from in this example from your text file:
Moodswings - Spititual High (State of ind),Spititual High (State of ind) - 1992,30,12,99
Maybe something is not correct in your ID3-Tags?
The date is something I cannot explain. How did you setup (and saved) the playlist?
Ah so the coding is all good but its just the date that is the issue.
The “-” in the file name is the format i usually use and all my songs in the database use “name” - “Title” - “year”
I save the playlist as the date of the show so this one is saved as 29th Dec 21.mlp
I’m jinxed when it comes to tech stuff
Yes I did save it as a TXT file
Try export as .csv Comma Separated Variable.
Once you have the file it will open on most Computers as a text file, but can also be opened by excel.
I hope this helps.
