# Placeholders export data
**URL:** https://community.mp3tag.de/t/placeholders-export-data/48731
**Category:** Support
**Created:** [April 25, 2020, 8:02am UTC](https://community.mp3tag.de/t/placeholders-export-data/48731 "2020-04-25T08:02:39Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@hannes1](https://community.mp3tag.de/u/hannes1)
#### Post date: [April 25, 2020, 8:02am UTC](https://community.mp3tag.de/t/placeholders-export-data/48731/1 "2020-04-25T08:02:39Z")
Hi All,
Can someone help me with the export data of my music collection.
This is the 1rst time i use the export function. My export data is CSV. I can open it in Exel. No problem.
If I watched it in Exel I'm missing the Genre and length of time song in my collection.
Can someone help please, how can I get it these 2 functions in my export CSV file?
I'm not technical enough how to put it in mp3tag.
Han
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [April 25, 2020, 9:14am UTC](https://community.mp3tag.de/t/placeholders-export-data/48731/2 "2020-04-25T09:14:55Z")
> [@hannes1](#):
>
> my export CSV file
I don't know what your export file looks like.
The variables for
> [@hannes1](#):
>
> Genre and length
are %genre% and %\_length%
You find this information in the help:
[Tag Field Mappings – Mp3tag Documentation](https://docs.mp3tag.de/mapping) with a list of fields
[Format Strings and Placeholders – Mp3tag Documentation](https://docs.mp3tag.de/format) with a list of more property variables.
---
### Author:  [@hannes1](https://community.mp3tag.de/u/hannes1)
#### Post date: [April 25, 2020, 9:27am UTC](https://community.mp3tag.de/t/placeholders-export-data/48731/3 "2020-04-25T09:27:06Z")
Thank you. But i don't know how I get the placeholders in the export fiile. Sorry, but this is the 1st time I use the export file. Mostly I use MPEG audio colection, but I wanted to try the mp3tag export file.
In Exel I have made by hand:
Artist - Titel - Length - Year - Genre - LOcation - Notes
Han
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [April 25, 2020, 9:52am UTC](https://community.mp3tag.de/t/placeholders-export-data/48731/4 "2020-04-25T09:52:11Z")
> [@hannes1](#):
>
> In Exel I have made by hand:
> Artist - Titel - Length - Year - Genre - LOcation - Notes
This is not really beneficial, I would say as the data is determined by the export script.
Even though you can name your column headers as you like, I would like to point out that there is no field for Location or Notes, at least not with this name. You would have to think of some kind of mapping.
You know already the link to the list of tag field names.
The export file is a plain text file - have you tried to edit it?
I think that in the default CSV export script, %\_length\_seconds% is already included. You could replace that with just %\_length%.
And then you add simply %genre% somewhere in the list of variables (and delete all the fields that you don't want).
---
### Author:  [@hannes1](https://community.mp3tag.de/u/hannes1)
#### Post date: [April 25, 2020, 10:41am UTC](https://community.mp3tag.de/t/placeholders-export-data/48731/5 "2020-04-25T10:41:49Z")
> [@ohrenkino](#):
>
> The export file is a plain text file - have you tried to edit it?
Heuuh..... No. How do I do that? This is completely new to me. Sorry.
Hint: Maybe a good tutorial with pics for the non-technical persons.... like me.
Han
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [April 25, 2020, 10:58am UTC](https://community.mp3tag.de/t/placeholders-export-data/48731/6 "2020-04-25T10:58:50Z")
> [@hannes1](#):
>
> How do I do that?
Click on the edit button.
---
### Author:  [@LyricsLover](https://community.mp3tag.de/u/LyricsLover)
#### Post date: [April 25, 2020, 12:05pm UTC](https://community.mp3tag.de/t/placeholders-export-data/48731/7 "2020-04-25T12:05:23Z")
> [@hannes1](#):
>
> Hint: Maybe a good tutorial with pics for the non-technical persons.... like me.
---
### Author:  [@hannes1](https://community.mp3tag.de/u/hannes1)
#### Post date: [April 25, 2020, 12:17pm UTC](https://community.mp3tag.de/t/placeholders-export-data/48731/8 "2020-04-25T12:17:03Z")
#LyricsLOver,
Thank you. That was very clear for me.I'll give it a try.
Han
---
### Author:  [@hannes1](https://community.mp3tag.de/u/hannes1)
#### Post date: [April 25, 2020, 8:30pm UTC](https://community.mp3tag.de/t/placeholders-export-data/48731/9 "2020-04-25T20:30:06Z")
#LyricsLover,
It works great. THX. Only 1 small problems with the lenth.
It gives me 3 digits, like 234, instead of 2:34 . But, still it works.
Han
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [April 25, 2020, 8:34pm UTC](https://community.mp3tag.de/t/placeholders-export-data/48731/10 "2020-04-25T20:34:13Z")
What are you using?
%\_length\_seconds%?
%\_length%
---
### Author:  [@LyricsLover](https://community.mp3tag.de/u/LyricsLover)
#### Post date: [April 25, 2020, 8:37pm UTC](https://community.mp3tag.de/t/placeholders-export-data/48731/11 "2020-04-25T20:37:51Z")
> [@hannes1](#):
>
> It gives me 3 digits, like 234, instead of 2:34
`%_length_seconds%` will give you `234` seconds.
`%_length%` will give you `03:54` (03 minutes and 54 seconds)
---
### Author:  [@hannes1](https://community.mp3tag.de/u/hannes1)
#### Post date: [April 26, 2020, 3:56am UTC](https://community.mp3tag.de/t/placeholders-export-data/48731/12 "2020-04-26T03:56:03Z")
#LLover,
Thank you. It works. Know I get it. Sorry for that............. A little shame on me.... I'm old.
Han
---
### Author:  [@system](https://community.mp3tag.de/u/system)
#### Post date: [February 9, 2026, 12:28pm UTC](https://community.mp3tag.de/t/placeholders-export-data/48731/13 "2026-02-09T12:28:33Z")