Export to Excel Document

View previous topic :: View next topic
  • Quote
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.
_________________
follow me on the bandcamp.
  • Quote
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
  • Quote
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).

New topic  Closed
Topic Posters
All times are GMT>

Page 1 of 1


 

Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Similar Topics
Topic Author Forum
Excel Docs craola Suggestions
Export song rating by year? RoundTheBend Suggestions
[ Poll ] Australia's Best Export videoheadcleaner Music
George Harrison document - Martin Sco... Error Finn Music

 
Back to Top
Best Ever Albums
Install BEA for an app-like experience.