CSV/Excel/Spreadsheet to Zotero

I have about 450 articles in a Google Sheets file. Publication year, authors, title - only those 3 information, no DOIs or links or anything else.

How do I put all this into my Zotero library? I've read discussions threads talking about b2bib or delimiters or Python etc, but it's difficult for me to understand all that. Is there a simpler way for a simple user such as myself?

I'm doing this because I plan to use Zotero's "Find Available PDF" feature to find full texts for each article. I could probably do that manually but it will definitely take up some time.
  • If you can post a link to the csv I'll convert it to an importable format.
  • FWIW, "Find Available PDFs" will not work for items without DOI or URL. You can try to run the DOI manager add-on to get the DOIs before running find available PDF, but I'm not sure the info you have (without journal title) will be enough to get the DOIs.
Sign In or Register to comment.