Splitting Composer data to multiple columns in Excel

Some older database applications may export all composer and all publisher data (name, affiliation, share ..) to a single column, when you export the metadata to a comma separated or tab delimited file.

The NetMix system stores each composer name, affiliation and share in a separate column as recommended in the "metadata standard for production music" developed by the PMA (Production Music Association).

Example of incorrectly formatted Composer column:


Example of correctly formatted Composer columns per NetMix and PMA standard:


IF your source data is consistently formatted and contains a 'delimiter', then you can use a function in Excel to split the composer and publisher data into multiple columns.

Excel has a feature called "Convert Text to Columns":


How to use "Convert Text to Columns" is explained on the Microsoft website:


Have more questions? Submit a request


Article is closed for comments.
Powered by Zendesk