Unlock Forum posting with Annual Membership. |
|
|||
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! |
|||
|
|||
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.
|
|||
|
|||
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. |
|||
|
|||
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):
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.
|
|||
|
|||
You should pick delimited. The file is a CSV file, while means "comma separated values." |
|||
|
|||
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 |
|||
|
|||
Yay! Glad it worked. :) |
|||