Best Ever Albums

Re: Export to Excel Document

albummaster — Thu, 21 Aug 2014 14:20:22 GMT

Author: albummaster

Posted: 08/21/2014 18:20

Tbh, CSV is the most open file format that the site can provide. Most text editors and spreadsheet programmes can read this format. A minor point, CSV is actually comma separated so there should be no need to do text to columns in Excel, it should open automatically into columns (at least in the versions that I've tried) - just do File->Open and choose 'Text files' as the file type (Excel will know it is comma-separated from the .csv file extension).

Re: Export to Excel Document

antiloopje — Wed, 20 Aug 2014 16:55:51 GMT

Author: antiloopje

Posted: 08/20/2014 20:55

Most pages have a 'download csv file' link. csv files can easily be read into excel:

Open the file with excel

go to the data tab
select entire A column
choose "text to columns"

screen 1: delimited
screen 2: comma
finish

replace content of destination cells

You should now have a reasonable excel file

Export to Excel Document

craola — Wed, 20 Aug 2014 16:32:54 GMT

Author: craola

Posted: 08/20/2014 20:32

It would be nice to have a feature to export different lists (ratings, Wish List, etc.) to an Excel document. I spent an hour the other copying over a bunch of stuff, and it pretty well dried my acorns out.