How to automatically retrieve journal ranking and quartile from article list For a grant application I need to generate a list of my supervisor's publications (hundreds of articles) sorted by date, and for each publication they want impact factor, ranking, and quartile ranking of the journal in the year of publication. If I have to look up this manually it will take me a week. I only have the list of the publications in a CV, not even in a citation manager.

Can anybody help? How can this be done semi-automatically?
The typical place to obtain journal IF and ranking data in a searchable and sorted format is your institution's library. They usually subscribe to commercial ranking services that provide spreadsheets (typically Excel). 

If you are a member of the institution (researcher, student) this should be made available to you. Depending on the type of subscription, the library might be reluctant to just share the file via email (in my experience, they are usually allowed to do so). In this case, ask if you can use one of the library's computers to extract the information you need.

Once you have the list of journals sorted, it'll be a bit of legwork to match articles to their respective journals, but a hundred should be doable in a few hours