I'm trying to import my library from Goodreads and am having some trouble, I think with the formatting of the Goodreads csv file. Below is an example of 5 books from the Goodreads csv file:
Code: Select all
Book Id,Title,Author,Author l-f,Additional Authors,ISBN,ISBN13,My Rating,Average Rating,Publisher,Binding,Number of Pages,Year Published,Original Publication Year,Date Read,Date Added,Bookshelves,Bookshelves with positions,Exclusive Shelf,My Review,Spoiler,Private Notes,Read Count,Recommended For,Recommended By,Owned Copies,Original Purchase Date,Original Purchase Location,Condition,Condition Description,BCID
479056,The 21 Irrefutable Laws of Leadership: Follow Them and People Will Follow You,John C. Maxwell,"Maxwell, John C.",,0785288376,9780785288374,0,3.92,Nelson Business,Hardcover,304,2007,1998,,8/4/10,"own, philosophy, philosophy-leadership, to-read","own (#25), philosophy (#4), philosophy-leadership (#4), to-read (#68)",to-read,,,,,,,1,8/18/09,Amazon,Like new,,
3707083,The Seven Worlds of Theodore Roosevelt,Edward Wagenknecht,"Wagenknecht, Edward",,,,0,0,"Longmans,Green & Co,",Hardcover,325,1958,1958,,7/29/11,"history, history-biography, own, to-read","history (#72), history-biography (#10), own (#70), to-read (#88)",to-read,,,,,,,1,7/29/11,Craigslist,Good,,
1291184,The Rise of Theodore Roosevelt,Edmund Morris,"Morris, Edmund",,034528707X,9780345287076,0,3.5,Ballantine Books (Mm),Paperback,886,1980,1979,,7/29/11,"history, history-biography, to-read","history (#71), history-biography (#9), to-read (#87)",to-read,,,,,,,1,7/29/11,Craigslist,Good,,
2411348,The Life of J.E.B. Stuart,Mary L. Williamson,"Williamson, Mary L.",,1930092229,9781930092228,3,3,Christian Liberty Press,Paperback,132,1997,1997,,7/28/11,"history, history-civil-war, history-war","history (#70), history-civil-war (#1), history-war (#39)",read,,,,,,,1,8/10/04,Gift,Very good,,
188119,"How to Stay Alive in the Woods: A Complete Guide to Food, Shelter and Self-Preservation Anywhere",Bradford Angier,"Angier, Bradford",,1579122213,9781579122218,0,4.08,Black Dog & Leventhal Publishers,Hardcover,320,2001,1962,,7/28/11,own and technical,own (#69) and technical (#6),read,,,,,,,1,12/25/04,Gift,Like new,,
After the import, there are random quotes at the beginning/end of the Title field, and the Author, Publisher, Pages, and Rating field data are all mixed up:
Could you let me know what's going wrong here, and what I can do to fix it? Or can you make a customized Goodreads import?
Let me know if you need more info.
Thanks so much.
