# Export files as Calc files (.ods) for Libreoffice or any spreadsheet software (Excel etc.)

**URL:** https://community.mp3tag.de/t/export-files-as-calc-files-ods-for-libreoffice-or-any-spreadsheet-software-excel-etc/41130
**Category:** Support
**Created:** [March 18, 2018, 4:19pm UTC](https://community.mp3tag.de/t/export-files-as-calc-files-ods-for-libreoffice-or-any-spreadsheet-software-excel-etc/41130 "2018-03-18T16:19:27Z")
**Posts on this page:** 1
**Showing post:** 5

<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: [March 18, 2018, 6:07pm UTC](https://community.mp3tag.de/t/export-files-as-calc-files-ods-for-libreoffice-or-any-spreadsheet-software-excel-etc/41130/5 "2018-03-18T18:07:27Z")

</div>

A spreadsheet program should be able to import "csv" files - these are plain text files where every field is separated by a special character, in many cases a comma or semicolon, but best is the tab character.  
I think that there is already an example export script in MP3tag.

Or have a look at this thread:

> [@Exporting to excel](https://community.mp3tag.de/t/exporting-to-excel/13552/4):
>
> Yes, using the system variable %\_counter% there is no need to set up a user defined counter variable. Right after a closed loop the system variable %\_max\_counter% provides the maximum count of the last loop. I would code the report like this ... (maybe it would be more safe to replace the semicolon delimiters by the tab character $char(9)) 1: $filename($getEnv('USERPROFILE')'\Desktop\20120616.Test.Graeme.csv',UTF-16)'"ID";"Title";"Artist";"Album Artist";"Com";"Album";"Track";"Year";"Length"…

---

_[View the full topic](https://community.mp3tag.de/t/export-files-as-calc-files-ods-for-libreoffice-or-any-spreadsheet-software-excel-etc/41130)._