# Problems transferring HTML to Excel
**URL:** \
**Category:** Support\
**Created:** [February 13, 2018, 1:36pm UTC](https://community.mp3tag.de/t/problems-transferring-html-to-excel/40793 "2018-02-13T13:36:25Z")\
**Posts on this page:** 1\
**Showing post:** 4
**Author:**  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\
**Post date:** [February 14, 2018, 12:36pm UTC](https://community.mp3tag.de/t/problems-transferring-html-to-excel/40793/4 "2018-02-14T12:36:54Z")
> [@fobar2017](#):
>
> I’ve tried the csv file type and it does go into Excel however all I end up with is one big string of data not a spreadsheet , unless there’s a way of converting the data into a spreadsheet and if there is I have no clue how to do it and as far as a csv file is concerned you can only use 1 csv file per page where copying and pasting the results of a HTML page is continuous.
The workflow should be modified from copy&paste to "Export, then open in Excel".
See the Excel File\>Open options where you can select CSV as file type.
Still, the ordinary CSV export script could be modified in such a way that the semicolon is replaces by a tab character as this usually avoids problems with data that already contains a semicolon.
Also, this thread may be of interest as it deals with the total length:
> [@Sum "Length" on html standard output](https://community.mp3tag.de/t/sum-length-on-html-standard-output/19724):
>
> All my outputs in regards to albums are done in "html\_standard". I've added "length" to the output just for reference. The question is, can the "total length" (time) be added to the"html\_standard" output? I know that on the bottom of MP3Tag it gives you the info on how long a particular album is. Needless to say there are albums that are over 60 minutes (actually double discs) so the coding would have to allow for that. I've tried doing it in Excel but I gave up, no matter how I formatted the ce…
Just to give you an impression of a simple csv-export script:
$filename(csv,utf-16)Artist$char(9)Composer$char(9)Album$char(9)Title
$loop(%artist%)%artist%$char(9)%composer%$char(9)%album%$char(9)%title%
$loopend()
Select a couple of files,
Create a new export,
copy the code and overwrite with it the sample export script of the new export.
Save the export script
Execute the export.
If everything is set to normal in your system, then you will probably be asked whether you want to open the result in Excel.
---
_[View the full topic](https://community.mp3tag.de/t/problems-transferring-html-to-excel/40793)._