Page 1 of 1

SKP Export history problem

Posted: Mon Oct 13, 2014 9:23 am
by tinmanjim
When exporting the history in csv (comma separated values) format, the values all export nicely. That's not a lot of help, however, because there are no actual commas in the generated file. As a result, when the file is opened in excel what you get is "Singer Date Song title Artist..." all in one column, with the related data all in one column beneath it. The results are only sort-able by name.

Is this something that could be fixed easily? It would sure make my life a little easier if the top of the generated file read "Singer, Date, Song title, Artist..." instead, with the associated fields following suit.

Thanks for the great product; keep up the good work.

Posted: Mon Oct 13, 2014 4:50 pm
by gjjolly
Export singer history > remember file location> open Excel > click on data tab > get external data > from text
> locate CVS file exported > Import > delimited > next > Tab delimiter > next > General format > finish > import data > OK