# Import from file?

**URL:** https://community.mp3tag.de/t/import-from-file/11443
**Category:** General Discussion
**Created:** [January 14, 2011, 11:45pm UTC](https://community.mp3tag.de/t/import-from-file/11443 "2011-01-14T23:45:57Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![HI\_WAY\_2\_THE\_DANGERZ](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/h/cc9497/32.png) [@HI\_WAY\_2\_THE\_DANGERZ](https://community.mp3tag.de/u/HI_WAY_2_THE_DANGERZ)
#### Post date: [January 14, 2011, 11:45pm UTC](https://community.mp3tag.de/t/import-from-file/11443/1 "2011-01-14T23:45:57Z")

</div>

Hello!

I work at a place where it is NOT COOL to tag my music with MP3tag at work.

During my lunch hour I like to sometimes edit information for my current tracks using Excel. Once at home I cut and paste the information into Excel ... and cut and paste and cut and paste...

Is it possible to import certain columns from an Excel file. Really tonight I am only intrested in the information in one column. I could save that column out as a .txt file if MP#tag could import that.

Any ideas?

Thanks

---

<div class="post-metadata">

### Author: ![mjcm](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/m/9d8465/32.png) [@mjcm](https://community.mp3tag.de/u/mjcm)
#### Post date: [January 15, 2011, 12:32am UTC](https://community.mp3tag.de/t/import-from-file/11443/2 "2011-01-15T00:32:16Z")

</div>

This should you get started.

[importing song titles from excel...](https://community.mp3tag.de/t/11156/1)

---

<div class="post-metadata">

### Author: ![pone](https://community.mp3tag.de/user_avatar/community.mp3tag.de/pone/32/272_2.png) [@pone](https://community.mp3tag.de/u/pone)
#### Post date: [January 15, 2011, 12:37am UTC](https://community.mp3tag.de/t/import-from-file/11443/3 "2011-01-15T00:37:13Z")

</div>

mp3tag can import from txt files with the Text file - Tag Converter: ![](http://help.mp3tag.de/images/mt_tff.png)  
export it from excel in a way that every line coresponds to one file.  
take care that you have to sort the mp3 files in the same order as the lines in the txt files.  
you can export/import as many fields/colums you like. just use a clear marker between the different fields within the line.

example:  
textfile:  
Artist 1|Album 1|Title 1  
Artist 2|Album 2|Title 2  
Artist 3|Album 3|Title 3  
...

formatstring:  
%artist%|%album%|%title%|

---

<div class="post-metadata">

### Author: ![HI\_WAY\_2\_THE\_DANGERZ](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/h/cc9497/32.png) [@HI\_WAY\_2\_THE\_DANGERZ](https://community.mp3tag.de/u/HI_WAY_2_THE_DANGERZ)
#### Post date: [January 15, 2011, 1:12am UTC](https://community.mp3tag.de/t/import-from-file/11443/4 "2011-01-15T01:12:03Z")

</div>

I need to get some sleep and think about this one in the morning. Thank you for your help.