Discussion Forums - Questions about PaperBackSwap Questions about PaperBackSwap

Topic: exporting lists to excel

Club rule - Please, if you cannot be courteous and respectful, do not post in this forum.
  Unlock Forum posting with Annual Membership.
Subject: exporting lists to excel
Date Posted: 6/24/2009 10:53 PM ET
Member Since: 12/20/2008
Posts: 1,417
Back To Top

I downloaded my RL and when I open it in excel, it was all wonky.  Excel had given me options on how I wanted the columns, but I can't figure out what I should do.

Anyone with experience in exporting your lists and opening them in Excel?

Thanks!

Date Posted: 6/25/2009 12:39 AM ET
Member Since: 6/3/2009
Posts: 243
Back To Top

Easiest fix would be to format the coiumns to the width needed for the info in each column..

One thing I have noticed when downloading into excel, it saves it in a odd format. Once you have fixed the columns to your liking and you are about to save, click save as and use the scroll bar to change the format to an excel workbook.

 

Im not sure if I helped with the actual problem or not. :) But I had issues with the list it downloaded too, until I changed format to excel workbook.

 

 

Date Posted: 6/25/2009 7:37 AM ET
Member Since: 3/7/2009
Posts: 10,955
Back To Top

What was wonky about it and what options did Excel give you?  Mine just opens with four columns kind of squished together, so I make the columns a little wider so I can read the most of the Title and Author.

Date Posted: 6/25/2009 9:29 AM ET
Member Since: 12/20/2008
Posts: 1,417
Back To Top

When I try to open the downloaded file, Excel says:

"The Text Wizard has determined that your data is delimited.

If this is correct, choose Next, or choose the data type that best describes your data."

Then I have 2 choices which have the cirlce bullet "check boxes" (so, I can only choose one or the other, not both):

  • Delimited: Fields such as commas or tabs seperate each field
  • Fixed Width: Fields are aligned in columns with spaces between each field

 

I don't remember which options I've tried, but so far, all I get is a mess of numbers and equal signs and ellipses, and it is smushed into the same tab as the title, so I'm guessing the numbers are ISBNs.

 

 

Date Posted: 6/25/2009 9:51 AM ET
Member Since: 3/7/2009
Posts: 10,955
Back To Top

You should pick delimited.  The file is a CSV file, while means "comma separated values." 

Date Posted: 6/25/2009 9:54 AM ET
Member Since: 12/20/2008
Posts: 1,417
Back To Top

thanks Jenna!

eta: omg! once you know what you're doing, the rest is easy!



Last Edited on: 6/25/09 9:57 AM ET - Total times edited: 1
Date Posted: 6/25/2009 10:00 AM ET
Member Since: 3/7/2009
Posts: 10,955
Back To Top

Yay!  Glad it worked. :)