There is no easy answer. We suggest doing your search within your favourite database (Scopus/Google Scholar/ABI) and exporting results to a .csv file. This can be done via Endnote too but it is difficult
From Scimago - 'download the data' of desirable journals (e.g. Q1 journals in a subject area) into csv
The best way to compare both lists is to install the “Fuzzy Look-Up” excel add-in and match based on Journal titles. Fuzzy match is far more forgiving in terms of cross referencing slight variations in a string of words / characters. The excel add-in is available for free from Microsoft and in fairly straightforward to download, please see link here for download installer and instructions: https://www.microsoft.com/en-au/download/details.aspx?id=15011
This page provides a clear and concise set of instructions for how you might go about using Fuzzy Match to cross reference your publications list with the Scimago list.
When assembling an evidence summary for a review article or more formal type systematic review there may arise the need to engage software other than citation management apps (read, Endnote, Mendeley at al.) to record and audit retrieved literature. An obvious choice is typically Excel given most citation management software will generate and export a spreadsheet quite readily, much the least the ease and simplicity of collaborating with a team on a spreadsheet via Office365. Most citation management software handle bulk deduplication of records, however, where the quality and completeness of records from various databases is variable enlisting something like Excel with more flexibility and advanced text filtering facility makes screening publications while keeping track of the inclusion/exclusion of publications far easier. Enter the free Excel add-in, Fuzzy Lookup, a formula-free way of matching and filtering publications based on your own specimen criteria. The add-in is provided as a free download from this website and while there are innumerable tutorials the Business Liaison Librarians have put together a 'Tip Sheet' to keep at hand - see this link to download.
Click the image to download
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Australia License.
QUT acknowledges the Traditional Owners of the lands where QUT now stands.