# How can I export all the Mp3tag data in to an Excel spreadsheet?

**URL:** https://community.mp3tag.de/t/how-can-i-export-all-the-mp3tag-data-in-to-an-excel-spreadsheet/61101
**Category:** Support
**Created:** [May 28, 2023, 2:14pm UTC](https://community.mp3tag.de/t/how-can-i-export-all-the-mp3tag-data-in-to-an-excel-spreadsheet/61101 "2023-05-28T14:14:09Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Dave](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/ee7513/32.png) [@Dave](https://community.mp3tag.de/u/Dave)
#### Post date: [May 28, 2023, 2:14pm UTC](https://community.mp3tag.de/t/how-can-i-export-all-the-mp3tag-data-in-to-an-excel-spreadsheet/61101/1 "2023-05-28T14:14:09Z")

</div>

How can I export all the Mp3tag data into an Excel spreadsheet? The csv export option puts everything on one line and is not useful.

---

<div class="post-metadata">

### Author: ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [May 28, 2023, 2:17pm UTC](https://community.mp3tag.de/t/how-can-i-export-all-the-mp3tag-data-in-to-an-excel-spreadsheet/61101/2 "2023-05-28T14:17:22Z")

</div>

> [@Dave](#):
>
> The csv export option puts everything on one line and is not useful.

It is actually not the export option but the configuration of the target program.  
Open the generated csv file from within Excel as data to be imported and define the correct field separator in the import assistant.  
If that still does not work, edit the export script and replace all the `;` with `$char(9)`.

See also

> [@How to get a csv export with columns?](https://community.mp3tag.de/t/how-to-get-a-csv-export-with-columns/50222):
>
> Hi, I have used MP3tag for several years with great success. My computer rashed last year and I found myself stranded without MP3tag. I managed to find it again and everything works except that I am unable to export the result as a CSV excel sheet with full columns for each field. Can anyone send me the correct format for that export? Thanks Serge

or consult the forum search function

---

<div class="post-metadata">

### Author: ![confucius](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/c/9e8a1a/32.png) [@confucius](https://community.mp3tag.de/u/confucius)
#### Post date: [May 28, 2023, 11:41pm UTC](https://community.mp3tag.de/t/how-can-i-export-all-the-mp3tag-data-in-to-an-excel-spreadsheet/61101/3 "2023-05-28T23:41:15Z")

</div>

you could try this........

> [@Export or backup all tag fields](https://community.mp3tag.de/t/export-or-backup-all-tag-fields/9520):
>
> Mp3tagCompleteTags Export or backup all tag fields Here is a tool that lets you export all tag fields of the currently selected files By default it only works if your Mp3tag settings are in %APPDATA%\Mp3tag\ i.e. C:\Users\\<user\>\AppData\Roaming\Mp3tag\ It can be changed in the settings.ini file. I) Installation: Copy Mp3tagCompleteTags.exe to a folder of your choice. Run it once and follow the instructions! In Mp3tag go to "Tools \> Options \> Tools" and add Mp3tagCompleteTags.exe as a tool. A…

---

<div class="post-metadata">

### Author: ![system](https://community.mp3tag.de/uploads/default/original/2X/c/ce7035d426cb755a7916793326d23b465222a407.png) [@system](https://community.mp3tag.de/u/system)
#### Post date: [June 27, 2023, 11:41pm UTC](https://community.mp3tag.de/t/how-can-i-export-all-the-mp3tag-data-in-to-an-excel-spreadsheet/61101/4 "2023-06-27T23:41:43Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.