I have a very simple configuration to export the entire collection to a csv file. However, I would appreciate to be able to change the column width for each on the resultant file. Is it possible?
csv-music_list.mte (246 Bytes)
Where do you want to adapt the column width?
In the importing program?
You could probably test this and export a CSV file from that program and then import it again and see whether the original column width has been kept of whether a default column width is used.
TBH: I do not see any function or parameter that sets the column width. The CSV-file is a plain text file without any formatting information.
A CSV file is a plain text file that, due to its format, is typically created for import into spreadsheets (e.g., Excel). Of course, you can adjust column widths in spreadsheets.
Thanks, guys. That is what I thought, although I was hoping for a different comment.
I do change the column widths once the file is part of OpenOffice Calc, but it takes up plenty of time. It seems as though the export process takes the amount of characters in each field into consideration.
AFAIK you can adapt the column width of all filled columns in 1 go if you select the whole spreadsheet with the column anchor at the top left and double-click on the first divider.
Again: The export is a plain text file and does not know anything about columns and their widths. That processing is handled by the importing application.
It would be interesting to know what the purpose of the export is. I do not know any tagging supporting function that is better in an external application and needs a csv export with all its problems.
In answer to your question, the reason for the export is to keep track of songs played on our internet radio station, in order to eliminate duplicates. I have a OpenOffice Calc spreadsheet (I hate to support Microsoft!
) with dates of broadcast. When adding new tracks to our library, I export from mp3tag (the best there is
), but keep the previous two for reference. I only export certain columns (see attached), but prefer certain widths to see everything on one screen at a glance. Fortunately I only do this once every 4 to 6 weeks, so I'll have to adjust the column width manually every time, as I agree that it is certainly handled by the program being exported to.
csv-music_list.mte (246 Bytes)
Thank you.
I think that you can import into an exiting spreadsheet - and the exisiting configuration will be kept.
So if you create a template with the desirable layout, then it should not be necessary to adapt the column width every time.
Thanks, guys. At first, trying to 'import' via File/Open, it actually opened a new instance, not a new sheet. I then used the Sheet/External links function and it worked fine. The only problem is that I can't delete the csv files, but at least it is a lot easier than having to manually change column width every time. I appreciate your help. ![]()

