Excel is neither very ‘mac’ nor a traditional tool for literature reviews, but I’ve decided to create a brief post on how I use it to get a quick glance of a large body of literature.
First, I create an excel document with a name that reflects a thematic area. The choice of theme reflects a thematic area that I want to review.
Second, I create a set of columns, with categories such as name of author, name of publication, year of publication, name of journal, focus of article, research question(s), method, theory and key concepts, country where the research has been conducted, key findings, relevance for my ongoing projects, and so on.
Third, I ‘fix’ the columns containing the name of author, year and title of publication, so that this information will always stay on the left even if I scroll to the far right of the document.
Then, I start filling in the relevant information.
I also add different tabs for different kind of articles, for example, a tab for empirical articles, one for theoretical articles, and one for review articles.
The end result looks something like this:
So, what are the advantages of working in this way?
- It helps me to get a quick overview over a large thematic body of literature.
- It helps me to quickly compare research questions, methodological approaches or key findings across a large number of articles.
- I can easily sort the information in different ways; for example, I can arrange them according to name of journal if I’m targeting a particular journal for my next article, I can arrange them by year of publication to get a quick glance of how research in a particular area has advanced over the past couple of decades, or I can arrange them by country if I’m interested in a particular geographical area.
I’ve been exploring OmniOutliner recently as an alternative to Excel. While I think OmniOutliner is a great tool (and this will be the subject of a future post), I’m sticking with Excel for now for this purpose – primarily because keeping columns fixed isn’t possible in OmniOutliner (as far as I know, at least), and because sorting is a bit easier in Excel.