Export tags to Excel

[Scorpius]

Hello, can I export all the tags to Excel? I've looked through how to export but I couldn't locate send it to excel.

[ohrenkino]

The search function in this forum with the search words "Export excel" reveals among others this topic:

Exporting To Excel?

Hello... I have a number of DVD's containing around 400 MP3's each. I use Microsoft Office 2007 and want to export the MP3 Tag list exactly to Microsoft Excel. I chose Export >csv... Transfer was quick, Excel document opened, but the transferred information was not in columns as per MP3 Tag, but in lines of text with punctuation etc. Can someone help? Many thanks

[Scorpius]

thank you for the assist, though scripting is not thing and I'm trying to learn as fast as I can. i tried $filename and it came close to what I want though it's not exporting to excel?

[ohrenkino]

MP3tag comes with a sample export script for the CSV format which should be something that Excel can import.
You may have to edit it for your requirements.
You may have to tune the import settings in excel to get a good result.
More on the handling of Excel and import of data from text files can be found on the Microsoft help pages:

Import or export text (.txt or .csv) files - Microsoft Support

[LyricsLover]

@Scorpius

though it's not exporting to excel?

What exactly do you mean with "not exporting to excel"?
Do you create a CSV file with Mp3tag that contains what you want?
Can you open this CSV file in Excel?

Please describe in more details what you have done and what exactly don't work.

[Scorpius]

can I export these columns MP tags to excel? Yes I did try though excel opens the file under an individual cell

[ohrenkino]

I can hardly see anything in that screenshot. A list of fields (preferably with their MP3tag names) would be much nicer.

I do not doubt that you tried but for further support it would be very helpful if you told us what you tried esp. in repect to the export script showing the code, the steps you took to create the CSV file, the settings that you used in excel to import the data.
Also, a search in the forum might give an answer straight away:

CSV Export with seperate cells

Trying to use the default CSV export but output creates a single cell for header and data output. I'd like each data item to reside in a single CSV cell instead of ";" as a separator.

and also here:

Export to columns

Is there anyway to export to Excel in a column format? I'd like to be able to delete some of the information and re-arrange the remainder of the information when exporting to a csv. Currently each line exports to a single cell and the information (Title, Album, Genre, etc.) can't be globally manipulated.

And finally, what is the purpose of all this?
I do not really see a lot of functions where Excel is better than MP3tag to manipulate tag data, on the contrary, I think there are a lot of functions in MP3tag that excel cannot offer.

I would assume that some time later you want to import the data again, so please make sure that you know the intricacies and what to look out for when importing data from text files:

Importing from Excel

Sir, I have generated Music.txt from iTunes. Now when I checked music files using Mp3Tag, then I found that many files are not have names of Composers. How can I replace the names of missing "Composers" only where the Filename.Mp3 with location path are same [ of iTunes & %_folderpath%%_filename_ext%]. for example if the song at: G:\iTunes\Music\Jis Desh Mein Ganga Behti Hai\Jis Desh Mein Ganga Behti Hai\31 Aa Ab Laut Chalen.mp3 is same as Mp3Tags i.e. %_folderpath%%_filename_ext% is not…