# Creating an excel file from MP3 Tag Data
**URL:** https://community.mp3tag.de/t/creating-an-excel-file-from-mp3-tag-data/63218
**Category:** Support
**Created:** [December 27, 2023, 7:19am UTC](https://community.mp3tag.de/t/creating-an-excel-file-from-mp3-tag-data/63218 "2023-12-27T07:19:25Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Doron](https://community.mp3tag.de/u/Doron)
#### Post date: [December 27, 2023, 7:19am UTC](https://community.mp3tag.de/t/creating-an-excel-file-from-mp3-tag-data/63218/1 "2023-12-27T07:19:25Z")
I want to convert my MP3 Music Folders into Excel Sheets which contain the MP3 Tag Data. Please guide me as to how to go about it as I am a novice on MP3 Tag Editor.
---
### Author:  [@LyricsLover](https://community.mp3tag.de/u/LyricsLover)
#### Post date: [December 27, 2023, 7:34am UTC](https://community.mp3tag.de/t/creating-an-excel-file-from-mp3-tag-data/63218/2 "2023-12-27T07:34:44Z")
You can start with this documentation:
> **[Exporting Tag and File Information – Mp3tag Documentation](https://docs.mp3tag.de/export/)**
>
> Documentation on exporting tag and file information to text-based file formats. Mp3tag is the universal Tag Editor.
There is no direct way to create a \*.xls or \*.xlsx file from Mp3tag.
You need to create a CSV file first (with all the columns and data you want to export) and then import this CSV file into excel.
What do you want to achieve in Excel?
Most steps are also possible in Mp3tag itself, without the additional steps of export/import.
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [December 27, 2023, 7:36am UTC](https://community.mp3tag.de/t/creating-an-excel-file-from-mp3-tag-data/63218/3 "2023-12-27T07:36:45Z")
Just another thread about data transfer to excel
> [@Exporting To Excel?](https://community.mp3tag.de/t/exporting-to-excel/14921):
>
> 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
I agree with @LyricsLover:
> [@LyricsLover](#):
>
> Most steps are also possible in Mp3tag itself, without the additional steps of export/import
which may be particularly tricky if you are
> [@Doron](#):
>
> a novice on MP3 Tag Editor
---
### Author:  [@hannes1](https://community.mp3tag.de/u/hannes1)
#### Post date: [January 13, 2024, 2:54pm UTC](https://community.mp3tag.de/t/creating-an-excel-file-from-mp3-tag-data/63218/4 "2024-01-13T14:54:19Z")
Try MPEG Audio Collection. It's windows based. It is old, but still working on Win.10 and 11.
---
### Author:  [@MP3-User](https://community.mp3tag.de/u/MP3-User)
#### Post date: [January 28, 2024, 2:27pm UTC](https://community.mp3tag.de/t/creating-an-excel-file-from-mp3-tag-data/63218/5 "2024-01-28T14:27:17Z")
Die \*.csv Datei in Excel öffnen und die erste Spalte (A) markieren, jetzt auf die Registerkarte "Daten" wechseln und auf "Text in Spalten" klicken. Im ersten Fenster "Getrennt" wählen und im folgenden Fenster als Trennzeichen "Semikolon" wählen. Im letzten Fenster wird eine Vorschau angezeigt, "Standard" wählen und OK, das war es.
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [January 28, 2024, 2:29pm UTC](https://community.mp3tag.de/t/creating-an-excel-file-from-mp3-tag-data/63218/6 "2024-01-28T14:29:12Z")
Stay in English in the English sections of the forum, please.
---
### Author:  [@system](https://community.mp3tag.de/u/system)
#### Post date: [February 27, 2024, 2:30pm UTC](https://community.mp3tag.de/t/creating-an-excel-file-from-mp3-tag-data/63218/7 "2024-02-27T14:30:09Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.