Systematic Literature Review – Using Excel to help manage references for the systematic literature review process
06/07/2018
What’s the issue?
One of the questions which often comes up when discussing the SLR process is how do I manage my references in the most efficient way during the process of going from my search results, to my final list of articles?
Each step of the SLR process has its own challenges. Firstly you need to identify your keywords, then construct your search strings, then work out the combinations of the search strings and which databases to use e.g. EBSCO Business Source Complete, ABI Inform, Scopus and Web of Science, in order to retrieve the articles which are key to your research topic.
Not all the articles retrieved will be relevant and you will need to filter your initial results sets according to your inclusion and exclusion criteria, by looking firstly at the title and abstract, and then at the full text in order to identify the final articles. At each stage you will need to be able to note:
- how many articles there were
- for each of your search string combinations
- from each of your chosen databases.
Sounds simple enough, until you realise that there will inevitably be duplication between the sources…
The excellent news is that you can now export all of your references, with abstracts, directly from EBSCO Business Source Complete, ABI Inform and Scopus. The download option to use for EBSCO Business Source Complete and Scopus is the CSV option. For ABI Inform it is XLS.
Exporting from Ebsco
Exporting from ABI Inform
Once you have downloaded the information into Excel you can then use the power of Excel to help you tag, filter and sort your references so that you can easily identify duplicates and also keep track of which references were found in each database.
Other blog posts you may find useful
- Systematic Literature Review – Where do I begin?
- Systematic Literature Review – Selecting your Sources
- Systematic Literature Review – Identifying your search terms and constructing your search strings
- Systematic Literature Review – Combining your search strings to create your search strategy
If you have any comments about this post or would like further help or information please contact MIRC.
Categories & Tags:
Leave a comment on this post:
You might also like…
Finding your reading materials
You can find all the resources you need to support your work from our library website. You will need to select the library you are most associated with to get started: Science and engineering students primarily use the ...
My first time on a camping archaeological dig
Hannah Kloster, current Forensic Archaeology and Anthropology MSc student, talks about her experiences on a recent archaeological dig with Cranfield Forensic Institute (CFI). Was it your first time on such a dig? This was ...
If only… A snapshot of life with hearing loss
If only… My day starts with being shaken awake by my vibrating alarm clock. Being deaf means that a normal alarm clock has no effect. After showering and dressing I put in my hearing aid ...
New students can book a tour of Kings Norton Library from 3rd October
To help new students find their way around Kings Norton Library, staff will be offering lunchtime tours: Monday 3rd October – 1:15-1:45pm Tuesday 4th October – 12:15-12:45pm Wednesday 5th October – 12:15-12:45pm Thursday 6th October ...
HR in the new world: Shaping industries with the help of Cranfield
“I can absolutely pinpoint the moment I decided HR was for me,” enthuses Cranfield alumna Carrie Cushing (MSc International Human Resource Management, 2013). “I was in an undergraduate lecture on organisational behaviour. I found it ...
Additional support from Library staff for new students: 26 September – 27 October
We are looking forward to meeting all our new students (if we haven't met you yet!) You can find us at the Information Fair during Registration this week and, of course, you can find us ...