Exporting list of my books to Excel - Site Help, Tips & Tricks - Eat Your Books

Forum

Welcome Guest! You can not login or register.

Notification

Icon
Error

Exporting list of my books to Excel   Go to last post Go to last unread
#1 Posted : Monday, March 18, 2019 9:29:18 PM(UTC)

Is there a way to export my library titles to Excel? I want to actually start USING my cookbooks more than I currently do, and thought one way of doing that is to pick a book and a page number at random, and make that recipe!  BUT, I can't seem to find a way to export the list of cookbooks so I can number them...  Any help would be so appreciated!!!

#2 Posted : Monday, March 18, 2019 10:41:37 PM(UTC)

I did that last year, I can't remember why now, I suspect it was for inventory purposes after a clear out. It only gives you the Title and Author, no page numbers or # of recipes, but it may do the trick for you.


This is what I did:
In EYB book view change to "list view"
Copy all 
Paste into a text editor (not Excel or Word, use the simplest editor you have). This strips out all formatting.
Copy stripped data and paste into Excel.
You may have to repeat if you have a lot of books, I know mine goes to two pages in the EYB list view.
Use the Excel sort function to clear out most of the extraneous info, leaving just the titles. With some creative labeling before the initial sort you can also add the authors in a second column to your list if you want. I use the automatic numbering - Sheet> Fill Cells > Series. I use LibreOffice in Linux, so Excel commands may vary.


There may be a more elegant way, but I know this works. 

#3 Posted : Tuesday, March 19, 2019 3:16:50 AM(UTC)

I'Ve cut and pasted... and as above, first I set the view to the list without images, so I only had two screens for 329 books..


but, as an alternative to your pick a number approach .. why not consider "pick an ingredient" and "pick a course" and just do a search for that ingredient...?


 Whatever you do, enjoy!

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