Downloading Scopus records

From any University of Wolverhampton computer (or computer within the webdomain of a Scopus subscriber), visit the resources page, scroll down to Scopus and click the link to access it (if you are off campus you may need to enter your University of Wolverhampton username and password and click Log in twice; if you are using this in a different university, you may have another way of accessing the Scopus).

Click on the Advanced Search tab to see the large version of the search box and advanced search help.

Enter a query to match the documents that you want to analyse. As an example, the following query in the advanced search text box matches all Chemistry (subject area SUBJAREA is Chemistry) journal articles (document type DOCTYPE is article) about Alcohol (title, abstract or keywords TITLE-ABS-KEY contain alcohol) with a Spanish author (address field countries AFFILCOUNTRY include Spain) that were published in 2012 (publication year PUBYEAR is 2012):
TITLE-ABS-KEY(alcohol) AND AFFILCOUNTRY(Spain) AND SUBJAREA(CHEM) AND PUBYEAR IS 2012 AND DOCTYPE(ar) 

After clicking the magnifying glass to search, a list of 270 matches should appear. Out of interest, underneath the advanced search box is a list of the permitted commands. Clicking on any of these gives some help.

To save the results, first click the triangle to the right of the All menu and click Select all.

Next, click the Export button, change the format to CSV, select Citations and abstract information from the dialog box that appears.

After clicking the Export button, the file should save on your computer into a CSV (comma-separated variables) file called Scopus.csv. This file contains all the metadata needed for searches. Open the folder containing the file and rename it Chemistry Alcohol 2012 Spain.csv.

To convert this file to the tab-delimited format that Webometric Analyst prefers, from the Webometric Analyst classic interface, from the Tab-sep menu select Convert CSV to tab-separated, choose the Chemistry Alcohol 2012 Spain.csv file and answer No to the question about just swapping commas to tabs. A tab delimited file should now be created.

To obtain the corresponding world file, return to the main Search page in Scopus and enter the query below by clicking the magnifying glass search button.

TITLE-ABS-KEY(alcohol) AND SUBJAREA(CHEM) AND PUBYEAR = 2012 AND DOCTYPE(ar)

Scopus allows a maximum of 2000 results to be exported in one go but this search has 5,629, and so the Select All option can’t be used. The only way to select a large set of documents to save is to repeatedly click the Select page option on lots of pages of results. The following steps give an efficient way to do this.

Scroll to the bottom of the Scopus Results page to find the number of results per page to be displayed and change this to 200.

Scroll to the top of the page and click the Select page option in the Page or All set near the top of the page.

All the articles on this page should now be ticked. Now scroll to the bottom of the page and click the chevron to the right of Page 1, to go to Page 2 with the second 200 search results.

To get all of the Page 2 results ticked, scroll to the top of the page and tick next to the Page section to select the whole page.
Repeat this to select all of page 3 results as well. This gives a total of 600 results. This could be continued to get the first 2000 results but 600 is enough for now.

To save the selected 600 results, scroll to the top of the page and click the CSV export button . Rename the saved file as Chemistry Alcohol 2012 World.csv and use the Tab-sep menu option Convert CSV to tab-separated to convert it to a tab-delimited file called Chemistry Alcohol 2012 World.txt. Remember to answer No to the question about just replacing commas.
Repeat the above for the two queries below:

TITLE-ABS-KEY(alcohol) AND AFFILCOUNTRY(Spain) AND SUBJAREA(BIOC) AND PUBYEAR IS 2012 AND DOCTYPE(ar) 

Name the results file Biochemistry, Genetics and Molecular Biology Alcohol 2012 Spain.csv and convert it to Biochemistry, Genetics and Molecular Biology Alcohol 2012 Spain.txt using Webometric Analyst as above (197 matches).

TITLE-ABS-KEY(alcohol) AND SUBJAREA(BIOC) AND PUBYEAR = 2012 AND DOCTYPE(ar)

Save the first 600 results (out of 5,107) using the same steps as above to select the first three pages, rename the saved file Biochemistry, Genetics and Molecular Biology Alcohol 2012.csv and then convert it to Biochemistry, Genetics and Molecular Biology Alcohol 2012.txt using Webometric Analyst as above.

Advanced tip: To get a more age-balanced collection of articles, select the first three Scopus results pages as above, then change the sort order (top right button) to Date (Oldest) and save the first three pages of results in the new order – these are the oldest 600 articles. Saving the complete set of 6 pages creates a file of the 600 oldest and 600 youngest articles in the year, which is a fairer sample to compare with Spain.

Back to the overview page.