My Music Tools - the music soft from the whole worldMy Music ToolsMy Music Tools - the music soft from the whole world

How to export ID3 tags to MS Excel?

Introduction.

ID3 tags are normally used in connection with MP3 files. They are special fields in an audio file, which contain such details as title, artist, year, album, comment, track number, etc. ID3 tags are recognized by most software and hardware players that support the MP3 format. Music tags help sorting, filtering and finding songs.

Microsoft Excel is a powerful spreadsheet application by Microsoft Corp., part of MS Office. It offers quite a number of built-in features and supports macros, which makes it highly flexible and extensible. You may want to export audio tags into MS Excel to perform some batch operation and import the updated details back, to create some kind of list, to create and print a CD inlay, etc.

Audio tags can be easily exported to MS Excel with mp3Tag Pro.

Step 1: Download and install the program.

Download mp3Tag Pro to your computer and start the file. Follow instructions of the setup wizard to install the tag editor.

Step 2: Start the program. Select MP3 files.

Start mp3Tag Pro. The main window of the tag editor will appear:

Select your MP3 files

In the "Folders" area (1), find and select the folder with your audio files, which you want to export tags from.

In the main area (2), select audio files. To select all files, click the green checkmark button in the upper right corner.

If you want to include files from nested folders (subfolders), press the "Scan subfolders" button near the green checkmark button.

Finally, click the "Export / Playlists" button (3) in the "ID3 tags" area below the list.

Step 3: Export tags to Excel.

This will open a new window:

Export tags to Excel

From the "Export to" dropdown list (1), select "MS Excel".

Now take a look at the list of the available values with checkboxes on the left (2). If there is a checkmark, the corresponding field will be exported.

If you do not need to export some fields, just remove the corresponding checkmarks in this list.

You can also change order of exported fields. Just highlight (click) a field in this list and use the green arrows above it to move the field up or down.

Finally, click the "Save playlist or Export data" button below (3). This will open an MS Excel window with your tags:

Spreadsheet with tags

In order to be able to export to MS Excel, you need Microsoft Office (including Excel) to be installed on your system. If you do not have it, the program will display an error message.

You can export tags to other spreadsheet applications using CSV as the intermediate format. Just select "CSV" in the "Export to" field.

mp3Tag Pro can also import tags from a CSV file.

Product Page


Search