Convert a Spreadsheet for Webometric Analyst
Sets of publications that are stored in a spreadsheet can be saved in a format similar to that of the Web of Science so that Webometric Analyst can process them. The following rules must be followed for this:
- Each publication must be in a separate row of the spreadsheet.
- The key information from each publication must be entered into separate cells.
- The publication year must be on its own in a column – the same column for all publications.
- The article title must be on its own in a column – the same column for all publications
- The journal name must be on its own in a column – the same column for all publications
- The article authors must be on their own in a single column – the same column for all publications The author name list must conform to either the WoS or the Scopus standard, as follows. Each author name must have the author last name, followed by a comma, followed by the author first name or initials, followed by a semi-colon and the next author (e.g., Macovez, Roberto; Lopez, Nuria; Mariano, Marina; Maymo, Marc; Martorell, Jordi). Or each author must start with their last name, then a space, then their initials followed by full stops, then a comma and the next author (e.g., Payen O., Chevallier F., Mongin F., Gros P.C.).
There must be a header row at the top of the spreadsheet with headings for the columns and the data must start in row 2.
With a spreadsheet in the above format, choose File|Save As (or equivalent) and select the Text (Tab delimited *.txt) format from the choices box. If there isn’t an equivalent to this, save as CSV and then use the Tab delimited option in Webometric Analyst to convert the saved file to tab delimited format.
The saved file can then be used to make web searches, search Mendeley (for this, add an extra DOI column if you have it) or calculate citation indicators (if you have an extra column for citations). The only change to the instructions elsewhere in this document is to select Other rather than WoS or Scopus, when, asked what type of information is in the file, and then check the questions about column numbers carefully and enter appropriate column numbers, when requested.
If you have a mix of files from different sources, such as WoS world files and group files saved from Excel, then it is important to conduct the Mendeley searches and the stage of making web searches separately for each format so that Webometric Analyst does not use the wrong columns to create the searches at any stage.
Back to the overview page.