Taperssection.com

Gear / Technical Help => Post-Processing, Computer / Streaming / Internet Devices & Related Activity => Topic started by: heath on June 24, 2011, 09:06:02 AM

Title: Excel Based ID3 editing?
Post by: heath on June 24, 2011, 09:06:02 AM

Hey kids,

I have approximately 500 MP3s that I need to edit ID3 tags for.  I have a spreadsheet that contains columns for each MP3's filename and what each tag should be for each file.  Is there any app that can take an excel spreadsheet and use it's data to tag MP3s?  Any input would be greatly appreciated. (and will save me countless hours of doing these by hand...)



h

Title: Re: Excel Based ID3 editing?
Post by: Fatah Ruark (aka MIKE B) on June 24, 2011, 10:34:10 AM

Media Monkey will look them up over the interwebs.

Not sure how much needs to be tagged in advance or how it does it. (ie it may only be able to tag song titles by the album name).

It's free so you can always give it a try.

Title: Re: Excel Based ID3 editing?
Post by: heath on June 24, 2011, 11:30:41 AM

Thanks for the input, but there won't be info on these via interwebs...  Unique collection that I personally transferred from transcription discs.  Doesn't exist anywhere else.

Title: Re: Excel Based ID3 editing?
Post by: 3-Fan on June 24, 2011, 01:14:26 PM

In Foobar you can tag files from something on you put in your clipboard.  First copy out of Excel the track names > Highlight tracks to tag in FOOBAR > Right Click > Properties > Tools > Auto Fill Tracks > Source (choose clipboard: line per track > then I use a pattern of %title%.

I use this all the time when Foobar won't auto fill in the information from a .txt file.  I just copy the song title out and use the above process.

Hope this helps!

Title: Re: Excel Based ID3 editing?
Post by: keytohwy on June 25, 2011, 06:38:45 PM

Quote from: heath on June 24, 2011, 11:30:41 AM

Thanks for the input, but there won't be info on these via interwebs...  Unique collection that I personally transferred from transcription discs.  Doesn't exist anywhere else.

xACT can tag from a text file, so you could copy in the necessary titles, and go from there.

Title: Re: Excel Based ID3 editing?
Post by: JackoRoses on June 26, 2011, 02:36:47 PM

Quote from: heath on June 24, 2011, 09:06:02 AM

Hey kids,

I have approximately 500 MP3s that I need to edit ID3 tags for.  I have a spreadsheet that contains columns for each MP3's filename and what each tag should be for each file.  Is there any app that can take an excel spreadsheet and use it's data to tag MP3s?  Any input would be greatly appreciated. (and will save me countless hours of doing these by hand...)



h

mp3tag takes a txt file and tags files, not exactly ideal for your situation with spreadsheets but an option if you don't find what you want.

Title: Re: Excel Based ID3 editing?
Post by: heath on July 05, 2011, 04:35:28 PM

Thanks for the help so far, guys.  Still looking....

Title: Re: Excel Based ID3 editing?
Post by: scb on July 06, 2011, 09:56:42 PM

Quote from: heath on June 24, 2011, 09:06:02 AM

Hey kids,

I have approximately 500 MP3s that I need to edit ID3 tags for.  I have a spreadsheet that contains columns for each MP3's filename and what each tag should be for each file.  Is there any app that can take an excel spreadsheet and use it's data to tag MP3s?  Any input would be greatly appreciated. (and will save me countless hours of doing these by hand...)



h

i could probably make something for you that'd read the info and tag the files.  probably wouldn't take more than a half hour for me to do