Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: MP3tag to spreadsheet - select fields

27 Jan 2010   #1

Linux CENTOS 7 / various Windows OS'es and servers
MP3tag to spreadsheet - select fields

Hi there
I'm fairly new to all this "Digital Music" stuff so excuse if this seems a trivial problem for a lot of users.

I've ripped my CD's and now I'm trying to create some sort of decent library system.

I'm using mp3tag v245a and it shows me the data I want to export to EXCEL (as a CSV file) - no problems with this

However when I run the export it copies ALL the headings not just the ones I want - and because some of the tags are missing the EXCEL import gets some data in the wrong columns.

All I want is just ALBUM, File Name (this is the ripped file name prefixed by a number), Path (I'm going to link this to a MySQL DB for streaming later on) Track title from the tag.

Enc screen from mp3tag v245a.

The windows normal Cut and Paste doesn't seem to work either

I'm sure loads of you must have used this program for getting data into a spreadsheet.

Here's the screenshot for example of the columns I need to export

Any of you Music Gurus who can sort me out with this.


Attached Thumbnails
MP3tag to spreadsheet - select fields-mp3tag.png  
My System SpecsSystem Spec
27 Jan 2010   #2

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium SP1, 64-bit


My general advice would be to look for a prog that is specifically designed as a catalog program as opposed to a tagging program. It might give you more control and accuracy. I have no idea what prog that might be as I am not in the flac world.

I have mp3s and use a prog called mp3utility. It reads everything in a directory and its subdirectories and saves it to a csv, which can then be imported to Excel.

You might end up with column headings you don't care about such as sample rate, running time, bitrate, channel mode, etc.

Frankly, I think if you rely on tags you are destined for a lot of hand editing and manicuring. The more tags you care about on a given selection, the more manicuring required.

All I care about is song title and artist--very very rarely anything else. My file naming convention is artist name space hyphen space song title, so everything I want is in the file name. Even then, it's a ongoing battle against errors of one kind or another.

Here is a screen cap of the output of mp3utility. There are 20 or 30 columns off screen to the right that I don't care about.

Attached Thumbnails
MP3tag to spreadsheet - select fields-untitled-1.jpg  
My System SpecsSystem Spec

 MP3tag to spreadsheet - select fields

Thread Tools

Similar help and support threads
Thread Forum
Win 7 Explorer and displaying MP3TAG metadata fails
Hello, recently, my windows 7 Explorer (file manager) is unable to display MP3TAG metadata of music when view files in details view or even when right clicking and getting the property on the file itself. Explorer (file manager) is unable to read/access the metadata on single computer. if I...
General Discussion
Preventing MP3TAG App from Starting Player
I started to use the MP3TAG app to modify music data. My problem is that sometimes when selecting a track for editing the music player will activate and start playing the track. I do not know why this happens and I want to stop this from happening. -thx
Music, Pictures & Video
Make the tab key only select text fields, not menus and other stuff
Hello, When I've got any kind of dialogue box open with text fields, I use the tab key to hop between the text fields. But, doing this also hops to any pop-up menus, which means I can change the thing in the pop-up menu using the up/down cursor keys, which might possibly be useful in a very few...
General Discussion
Album Art comes back even after removing using Mp3tag
Here is the problem: I have removed all the album art(pictures) using mp3tag and now there are no images showing in map3tag. I have also deleted VLC player's album art cache. I also made sure that no folders were hidden having those images by showing system protected hidden folders and all. ...
Music, Pictures & Video
How to combine fields in Access 2010 based on 2 equal fields?
Hi all, Im really in need of some help from some Access experts! Im a newbie to Access, but I got myself busy with quite a big project... Im trying to map out the product supply to shops in the whole country. Ive come quite far for a starter, but I keep having 3 questions, it would be great...

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 14:03.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App