# No .csv after exporting as a csv file **URL:** \ **Category:** Support\ **Created:** [March 21, 2023, 11:34am UTC](https://community.mp3tag.de/t/no-csv-after-exporting-as-a-csv-file/60444 "2023-03-21T11:34:18Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![xpac5896a](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/x/85f322/32.png) [@xpac5896a](https://community.mp3tag.de/u/xpac5896a)\ **Post date:** [March 21, 2023, 11:34am UTC](https://community.mp3tag.de/t/no-csv-after-exporting-as-a-csv-file/60444/1 "2023-03-21T11:34:18Z")
I exported some files in csv format and noticed that there is no extension .csv after the file name MP3TAG. The correct file name should be MP3TAG.CSV, consequently it cannot be opened in the correct way to import the data into Excel. My question is why? ![2023-03-21_07-24-19](https://community.mp3tag.de/uploads/default/original/2X/c/c6d2b8571e7b9390f612132c2254ef158377ead3.jpeg) ---
**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 21, 2023, 11:37am UTC](https://community.mp3tag.de/t/no-csv-after-exporting-as-a-csv-file/60444/2 "2023-03-21T11:37:15Z")
You would have to show us the export script and the settings that you use in the Export dialogue. I doubt that excel cannot open such a file if you first open Excel and then open the file with Excel functions. Fascinatingly, the dump that you show, displays the file "mp3tag" with the green X that I think comes from Excel - so apparently Excel is already set to open that file. ---
**Author:** ![xpac5896a](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/x/85f322/32.png) [@xpac5896a](https://community.mp3tag.de/u/xpac5896a)\ **Post date:** [March 21, 2023, 11:48am UTC](https://community.mp3tag.de/t/no-csv-after-exporting-as-a-csv-file/60444/3 "2023-03-21T11:48:44Z")
ohrenkino: Here is the script I used: $filename(csv,utf-16)Year;Title;Artist;Album;Track;Length;Genre;Comment; $loop(%\_filename\_ext%)%year%;%title%;%artist%;%album%;%track%;$ifgreater(%\_length\_seconds%,3600,%\_length%,00:%\_length%);%genre%;%comment%; $loopend()build on %\_date% with %\_app% - the universal Tag editor - [Mp3tag - the universal Tag Editor (ID3v2, MP4, OGG, FLAC, ...)](http://www.mp3tag.de/en/) no changes other than the formula you gave me for minutes and seconds and needless to say the arrangement of headers. ---
**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 21, 2023, 11:52am UTC](https://community.mp3tag.de/t/no-csv-after-exporting-as-a-csv-file/60444/4 "2023-03-21T11:52:14Z")
As the script does not specify a particular filename, please note the 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. Also, could it be that you have set the explorer to hide extension of known files? ---
**Author:** ![xpac5896a](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/x/85f322/32.png) [@xpac5896a](https://community.mp3tag.de/u/xpac5896a)\ **Post date:** [March 21, 2023, 11:56am UTC](https://community.mp3tag.de/t/no-csv-after-exporting-as-a-csv-file/60444/5 "2023-03-21T11:56:31Z")
I forgot to mention that you cannot open a csv file directly into Excel, as you well know. You must open the csv file by going to File\>Open\>Browse\>Folder name\>All Files. I found that if you Rename the file to MP3TAG.CSV, Excel will give you the dialog you need to bring the data into Excel correctly but you shouldn't have to do that because it should already have the .csv extension. ---
**Author:** ![xpac5896a](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/x/85f322/32.png) [@xpac5896a](https://community.mp3tag.de/u/xpac5896a)\ **Post date:** [March 21, 2023, 12:03pm UTC](https://community.mp3tag.de/t/no-csv-after-exporting-as-a-csv-file/60444/6 "2023-03-21T12:03:05Z")
Quoting from the documentation: `$filename(name,enc)` Optional statement that sets the file name, file extension, and/or encoding of the exported file. Needs to appear at the beginning of the export configuration. The optional second parameter sets the encoding of the export file. Possible values are `ansi`, `utf-8`, and `utf-16`. If you note that the string starts as $filename(csv,utf-16) which should tell the file what it should be and it's not. ---
**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 21, 2023, 12:38pm UTC](https://community.mp3tag.de/t/no-csv-after-exporting-as-a-csv-file/60444/7 "2023-03-21T12:38:12Z")
> [@xpac5896a](#): > > If you note that the string starts as $filename(csv,utf-16) which should tell the file what it should be and it's not. The documentation also says: "The default file name and/or file extension can be set from the export configuration (see `$filename()` below). Otherwise the previously used file name is prefilled. The file name to be used can always be adjusted upon export when the export dialog is shown." So: please show us the Export dialogue Ctrl+E and which filename you have defined there. ---
**Author:** ![MotleyG](https://community.mp3tag.de/user_avatar/community.mp3tag.de/motleyg/32/440_2.png) [@MotleyG](https://community.mp3tag.de/u/MotleyG)\ **Post date:** [March 21, 2023, 1:10pm UTC](https://community.mp3tag.de/t/no-csv-after-exporting-as-a-csv-file/60444/8 "2023-03-21T13:10:15Z")
In the Export config window that opens, you need to include the .csv extension on whatever filename you define. When you first select the export type, it will include a default name like "New export file.csv" that you can of course change, but still requires the extension there. ---
**Author:** ![system](https://community.mp3tag.de/uploads/default/original/2X/c/ce7035d426cb755a7916793326d23b465222a407.png) [@system](https://community.mp3tag.de/u/system)\ **Post date:** [April 20, 2023, 1:10pm UTC](https://community.mp3tag.de/t/no-csv-after-exporting-as-a-csv-file/60444/9 "2023-04-20T13:10:31Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.