# 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:** 1
**Showing post:** 2

<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

---

_[View the full topic](https://community.mp3tag.de/t/how-can-i-export-all-the-mp3tag-data-in-to-an-excel-spreadsheet/61101)._