Export Import Format

Export Import Format

The easiest way is to run an export (add 1 book first) and copy the format.

Notes:

1. Up to version 3.8.x there were up to 24 fields, in version 4.0 there are 29 potential fields in a standard CSV file (with ” enclosing cells).
2. All fields except for author and title can be left blank.
3. Each book should be on 1 line. Replace any newlines in fields (such as notes) with “\n” (minus the quotes)
4. It is strongly suggested that you edit the CSV file as text: if using a spreadsheet it is essential that you import all fields as ‘text’ otherwise ISBNs may lose leading zeroes, and dates may be truncated or reformatted in ways that make them unreadable.

Fields:

1. _id: For new books this would be blank. See also book_uuid, below.
2. author_details: The names of the authors - e.g. a book by Richard Morgan would be `Morgan, Richard` and a book by Buzz Aldrin and John Barnes would be `Aldrin, Buzz|Barnes, John`
3. title
4. isbn
5. publisher
6. date_published: in `yyyy-mm-dd` format
7. rating: `0-5`
8. bookshelf_id: would be blank or `1` for new books
9. bookshelf: Would be blank or `Default`
10. read: have you read this book `0` for no, `1` for yes
11. series_details: The series the book belongs to. The 4th book of the discworld series would be `Discworld (4)`
12. pages: How many pages in the book
13. notes: free notes
14. list_price: Exclude the $ sign
15. anthology: Is the book an anothology - `0` = no, `1` = yes all by the same author, `2` = yes by different authors
16. location: free text field
17. read_start: when did you start reading the book in `yyyy-mm-dd` format
18. read_end: when did you finish reading the book in `yyyy-mm-dd` format
19. format: One of `Paperback, Hard Cover, eBook, Audiobook, Guide / Companion`
20. signed: Is the book signed - `0` = no, `1` = yes
21. loaned_to: The name of the person the book is loaned to
22. anthology_titles: A pipe (|) delimited list of anthology titles. Each title is split into two parts. Part 1 the title itself, part 2 is the author. e.g. `All Cats Are Grey * Norton, Andre|The Assassin * Silverberg, Robert`
23. description: Free text description
24. genre:
25. (V4.0) date_added: The date when the book was added to the catalogue; leave blank for new books
26. (V4.0) goodreads_book_id: The internal goodreads Book ID for the book. Do not edit this field unless you are sure what you are doing
27. (V4.0) last_goodreads_sync_date: The last date/time that this book was sent to goodreads
28. (V4.0) last_update_date: the last date/time that this book was updated
29. (V4.0) book_uuid: the global unique ID for this book. As of version 4.0 this supersedes the ID in terms of identifying a book. If book_uuid is present in a CSV file, the ID field is ignored when searching for an existing book. This makes it possible to scan books on multiple devices and combine collections by copying CSV files and .jpg files from one device to another.