# Exporting and Importing

**URL:** <https://community.mp3tag.de/t/exporting-and-importing/48363>\
**Category:** Support\
**Created:** [March 29, 2020, 3:47pm UTC](https://community.mp3tag.de/t/exporting-and-importing/48363 "2020-03-29T15:47:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MikeFid](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/m/a9adbd/32.png) [@MikeFid](https://community.mp3tag.de/u/MikeFid)\
**Post date:** [March 29, 2020, 3:47pm UTC](https://community.mp3tag.de/t/exporting-and-importing/48363/1 "2020-03-29T15:47:22Z")

</div>

Hi Everyone,

I'm fairly new to mp3tag but I have a background in databases (very proficient in excel as well). I exported a few test records to .csv

title;artist;albumartist;album;track;year;genre;filename

I opened excel, formatted to text, open file, found the csv, opened it and set it to delimited with semicolon as the separator. That way I can see all the records in individual cells, do the tidying.

Now for the import. I'm using Convert\>Text File - Tag and I set the format sting exactly as shown below.

%title%%artist%%albumartist%%album%%track%%year%%genre%%filename%

But I'm getting this in the Preview - The fields I set as parameters are blank and the data is dumping in the filename field

"G:\Entertainment\Tunes\Clean Up Completed\Pop\Chumbawumba\Chumbawumba - Tubthumper.mp3" -\>  
title:  
artist:  
albumartist:  
album:  
track:  
year:  
genre:  
filename: Tubthumper Chumbawamba Chumbawamba Tubthumper Pop Chumbawumba - Tubthumper.mp3

I thought this was pretty straight forward but I'm clearly missing something. Any help is much appreciated.

Thank you,  
Mike

---

<div class="post-metadata">

**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:** [March 29, 2020, 4:50pm UTC](https://community.mp3tag.de/t/exporting-and-importing/48363/2 "2020-03-29T16:50:21Z")

</div>

I do not see a field separator in

> [@MikeFid](#):
>
> %title%%artist%%albumartist%%album%%track%%year%%genre%%filename%

but this could be due to the forum formatter.  
Anyway: you have to find a really unique field sepatator, e.g. for Export (and import into Excel) the tab character $char(9) would be even better than the semicolon.  
When you re-import, it is a little tricky to enter a tab character as it is also a GUI control key.  
I would suggest that you use the | as separator, so that the field list looks like

`%title%|%artist%|%albumartist%|%album%|%track%|%year%|%genre%|%filename%`

and naturally the records in the text file also have the bar as separator.

---

<div class="post-metadata">

**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:28pm UTC](https://community.mp3tag.de/t/exporting-and-importing/48363/3 "2026-02-09T12:28:29Z")

</div>