• To appreciate the use of Microsoft Excel for systematic reviews
• To increase your awareness of all the steps of a systematic review, including importing references and documents, plus documenting the whole process, including intermediate results
• To learn how to create transparent and complete reports for systematic reviews
Background Systematic reviews are complex and involve time-consuming, deep research in the academic literature to search, extract data, assess their quality and report the results. Digital tools and software have been developed to simplify different phases of this process but some of these are not free to use. Microsoft Excel is typically accessible to a great many researchers free of charge, so using it involves no further costs.
Aim To explain how to use Microsoft Excel to create transparent and complete reports for systematic reviews.
Discussion The author’s method includes six steps: downloading the references, preparing worksheets, removing any duplicate references, screening the references by title and abstract, screening the full text of references, and listing the articles for inclusion in the review.
Conclusion The Excel method is efficient and free and can produce transparent and complete reports of systematic reviews. It is a valid alternative to the systematic reviews produced by advanced tools and software.
Implications for practice The documents produced by this method are a good source for the direct production of scientific texts.
Nurse Researcher. 31, 1, 40-46. doi: 10.7748/nr.2023.e1866
Correspondence Peer reviewThis article has been subject to external double-blind peer review and checked for plagiarism using automated software
Conflict of interestNone declared
PermissionTo reuse this article or for information about reprints and permissions, please contact permissions@rcni.com
Write for usFor information about writing for RCNi journals, visit rcni.com/publish-article-with-rcni
For author guidelines, go to rcni.com/write-for-nurse-researcher
or
Are you a student? Our student subscription has content especially for you.
Find out more