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:
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.