# Need to export last modified column into Excel

**URL:** https://community.mp3tag.de/t/need-to-export-last-modified-column-into-excel/65174
**Category:** Support
**Created:** [June 30, 2024, 1:08pm UTC](https://community.mp3tag.de/t/need-to-export-last-modified-column-into-excel/65174 "2024-06-30T13:08:53Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![afcchris](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/a/53a042/32.png) [@afcchris](https://community.mp3tag.de/u/afcchris)
#### Post date: [June 30, 2024, 1:08pm UTC](https://community.mp3tag.de/t/need-to-export-last-modified-column-into-excel/65174/1 "2024-06-30T13:08:53Z")

</div>

Hi all

For some reason I am having trouble adding the last modified date when i export into Excel. This is the config of my export:

```auto
$filename(csv,utf-16)Title;Artist;Album Artist;Album;Track;Codec;Sample Rate;Bitrate;Path;Modified
$loop(%_filename_ext%)%title%;%artist%;%albumartist%;%album%;%track%;%_codec%;%_samplerate%;%_bitrate%;%_folderpath%;%_modified%
$loopend()build on %_date% with %_app% - the universal Tag editor - http://www.mp3tag.de/en/

```

Can someone tell me what i need to add for that column?

Regards  
Chris

---

<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: [June 30, 2024, 1:15pm UTC](https://community.mp3tag.de/t/need-to-export-last-modified-column-into-excel/65174/2 "2024-06-30T13:15:15Z")

</div>

> [@afcchris](#):
>
> %\_modified%

Please check the documentation:

> **[Format Strings and Placeholders – Mp3tag Documentation](https://docs.mp3tag.de/format/#file-properties)**
>
> Documentation on format strings and placeholders to describe the structure of file names and imported data. Mp3tag is the universal Tag Editor.

There are at least 3 variables:

| Varable | Description |
| --- | --- |
| %\_file\_mod\_date% | Short modification date |
| %\_file\_mod\_datetime% | Long modification date |
| %\_file\_mod\_datetime\_raw% | Long modification date (unformatted) |

---

<div class="post-metadata">

### Author: ![afcchris](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/a/53a042/32.png) [@afcchris](https://community.mp3tag.de/u/afcchris)
#### Post date: [June 30, 2024, 2:27pm UTC](https://community.mp3tag.de/t/need-to-export-last-modified-column-into-excel/65174/3 "2024-06-30T14:27:18Z")

</div>

Thanks a lot. I did see that but wasn't sure if it was right

---

<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: [July 30, 2024, 2:27pm UTC](https://community.mp3tag.de/t/need-to-export-last-modified-column-into-excel/65174/4 "2024-07-30T14:27:39Z")

</div>

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