# Adding Length (time) to CSV

**URL:** https://community.mp3tag.de/t/adding-length-time-to-csv/55643
**Category:** Support
**Tags:** player
**Created:** [December 28, 2021, 4:43pm UTC](https://community.mp3tag.de/t/adding-length-time-to-csv/55643 "2021-12-28T16:43:03Z")
**Posts on this page:** 1
**Showing post:** 17

<div class="post-metadata">

### Author: ![LyricsLover](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/l/c6cbf5/32.png) [@LyricsLover](https://community.mp3tag.de/u/LyricsLover)
#### Post date: [December 30, 2021, 1:50pm UTC](https://community.mp3tag.de/t/adding-length-time-to-csv/55643/17 "2021-12-30T13:50:10Z")

</div>

> [@xpac5896a](#):
>
> I just wish I could find that function to convert those single rows into columns in Excel. My only question is how.

Additional note for the import of a CSV into MS Excel:

Don't just double click on your CSV file to open it in Excel.  
Open Excel first and then inside Excel click on  
Open -\> Search  
then change the extension from the default `*.xls` to  
`All files *.*` or  
`Text files *.csv` to find your `*.csv` file.

 ![image](https://community.mp3tag.de/uploads/default/original/2X/9/95e706c6171b5c991886a9947f81b5b16949d390.png)

Then click on the Open-Button.  
This way, you get a 3 step wizard to import your data into Excel.  
In Step #1 of #3 you should choose **Delimited** (even if Excel tells you it has detected "Fixed width")

 ![image](https://community.mp3tag.de/uploads/default/original/2X/4/44959442dac0cb978817557ef46a80f7cf882c1a.png)

In Step #2 of #3 you can define your delimiter (a TAB or `;` or § or whatever you use)

 ![image](https://community.mp3tag.de/uploads/default/original/2X/4/4b67d0085755a0904fa55e6123ce4be56853357b.png)

---

_[View the full topic](https://community.mp3tag.de/t/adding-length-time-to-csv/55643)._