Google-sheets – How to create a checklist in Google Keep from a Google Sheets spreadsheet

google sheetsgoogle-keep

I exported my list of books I own from Shelfari, and want to create checklists in Keep for certain authors that will make it easier to browse second hand stores and not buy things I already have. I can get the complete list of books from the authors' websites (or Wikipedia), but it I am struggling with connecting the two Google services.

If I wasn't sitting in a Hotel on vacation I would actually code something that uses APIs to do it, but I'm pressed on time. Is there a built-in way to do this?

Best Answer

You may use the Web version of Keep (https://keep.google.com) and copy/paste all items directly there and it will create a checkbox on each line you pasted. It will sync automatically with the mobile app.