# Help with tag conversion / offline tag editing **URL:** \ **Category:** Support\ **Created:** [February 12, 2018, 2:34am UTC](https://community.mp3tag.de/t/help-with-tag-conversion-offline-tag-editing/40748 "2018-02-12T02:34:00Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![jsomethin](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/j/9de053/32.png) [@jsomethin](https://community.mp3tag.de/u/jsomethin)\ **Post date:** [February 12, 2018, 2:34am UTC](https://community.mp3tag.de/t/help-with-tag-conversion-offline-tag-editing/40748/1 "2018-02-12T02:34:00Z")
Hello I've exported the mp3 data and I'm trying to edit in Excel, and then upload those changes. The export format I used was this: ```auto $filename(csv,utf-16)Title~Artist~AlbumArtist~Album~Track~Path~Filename~ $loop(%_filename_ext%)%title%~%artist%~%albumartist%~%album%~%track%~%_folderpath%~%_filename_ext%~ $loopend()build on %_date% with %_app% - the universal Tag editor - http://www.mp3tag.de/en/ ``` My export file looks like this (I removed header and footer.....also, I've added words (like Artist, etc.) in the actual artist name, so that I can verify that the data imported). Anyway, this is the exported file (after I made some changes to the contents (like Artist name, etc.): ```auto Title~Artist~AlbumArtist~Album~Track~Path~Filename Piano & I~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~1~M:\Alicia Keys - songs in A minor\~1-Piano & I.wav The Life~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~10~M:\Alicia Keys - songs in A minor\~10-The Life.wav Mr. Man~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~11~M:\Alicia Keys - songs in A minor\~11-Mr. Man.wav Never Felt This Way~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~12~M:\Alicia Keys - songs in A minor\~12-Never Felt This Way.wav Butterflyz~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~13~M:\Alicia Keys - songs in A minor\~13-Butterflyz.wav Why Do I Feel So Sad?~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~14~M:\Alicia Keys - songs in A minor\~14-Why Do I Feel So Sad.wav Caged Bird~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~15~M:\Alicia Keys - songs in A minor\~15-Caged Bird.wav Lovin' U~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~16~M:\Alicia Keys - songs in A minor\~15-Lovin' U.wav Girlfriend~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~2~M:\Alicia Keys - songs in A minor\~2 - Girlfriend.wav How Come U Don't Call Me Anymore~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~3~M:\Alicia Keys - songs in A minor\~3 - How Come U Don't Call Me.wav Fallin'~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~4~M:\Alicia Keys - songs in A minor\~4 - Fallin'.wav Troubles~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~5~M:\Alicia Keys - songs in A minor\~5 - Troubles.wav Rock Wit U~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~6~M:\Alicia Keys - songs in A minor\~6 - Rock Wit U.wav A Woman's Worth~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~7~M:\Alicia Keys - songs in A minor\~7-A Woman's Worth.wav Jane Doe~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~8~M:\Alicia Keys - songs in A minor\~8-Jane Doe.wav Goodbye~Alicia Keys – Artist~Alicia Keys – Album Artist~songs in A minor – Album~9~M:\Alicia Keys - songs in A minor\~9-Goodbye.wav ``` When I try to import, I choose the file, and I use the format string: `%title%~%artist%`%albumartist%~%album%~%track%~%_folderpath%~%_filename_ext%~` When I click Preview, I get: "M:\Alicia Keys - songs in A minor\1-Piano & I.wav" -\> "M:\Alicia Keys - songs in A minor\2 - Girlfriend.wav" -\> ...etc Can anybody tell me what it is I'm missing? Thanks! -J ---
**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:** [February 12, 2018, 6:26am UTC](https://community.mp3tag.de/t/help-with-tag-conversion-offline-tag-editing/40748/2 "2018-02-12T06:26:26Z")
> [@jsomethin](#): > > %title%~%artist%`%albumartist%~%album%~%track%~%\_folderpath%~%\_filename\_ext%~ If I see that correctly, you are missing a ~ between %artist% and %albumartist%. Instead you have a `. So I suspect that the pattern does not match. ---
**Author:** ![jsomethin](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/j/9de053/32.png) [@jsomethin](https://community.mp3tag.de/u/jsomethin)\ **Post date:** [February 12, 2018, 1:31pm UTC](https://community.mp3tag.de/t/help-with-tag-conversion-offline-tag-editing/40748/3 "2018-02-12T13:31:53Z")
Yeah, that's just a typo in this thread....I've double checked and it's there when I try the convert. ---
**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:** [February 12, 2018, 2:50pm UTC](https://community.mp3tag.de/t/help-with-tag-conversion-offline-tag-editing/40748/4 "2018-02-12T14:50:28Z")
The correct format string matching the data set is `%title%~%artist%~%albumartist%~%album%~%track%~%_folderpath%~%_filename_ext%` Besides from the typo @ohrenkino spotted, your format string had an additional trailing `~` character. ---
**Author:** ![jsomethin](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/j/9de053/32.png) [@jsomethin](https://community.mp3tag.de/u/jsomethin)\ **Post date:** [February 12, 2018, 9:17pm UTC](https://community.mp3tag.de/t/help-with-tag-conversion-offline-tag-editing/40748/5 "2018-02-12T21:17:31Z")
Ok...fixed both of those, and now I'm getting different error: No matching entry for file "M:\Alicia Keys - songs in A minor\1-Piano & I.wav." .....etc ---
**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:** [February 13, 2018, 7:16am UTC](https://community.mp3tag.de/t/help-with-tag-conversion-offline-tag-editing/40748/6 "2018-02-13T07:16:38Z")
> [@jsomethin](#): > > No matching entry for file “M:\Alicia Keys - songs in A minor\1-Piano & I.wav.” Do you have this file in your file list or is it differently named? If you use `%_filename_ext%` when importing from text files, Mp3tag attempts to match entries based on this filename. Use `%dummy%` instead, if you want to skip this matching and simply import based on the order of the files in the file list. ---
**Author:** ![system](https://community.mp3tag.de/uploads/default/original/2X/c/ce7035d426cb755a7916793326d23b465222a407.png) [@system](https://community.mp3tag.de/u/system)\ **Post date:** [February 9, 2026, 12:27pm UTC](https://community.mp3tag.de/t/help-with-tag-conversion-offline-tag-editing/40748/7 "2026-02-09T12:27:14Z")