# Literature review ## Using a Table (Excel) - [Inside Higher Ed - Organizing Your Literature: Spreadsheet Style (2017-10-24)](https://www.insidehighered.com/blogs/gradhacker/organizing-your-literature-spreadsheet-style) - The author, Kathleen Clarke, was inspired by Elaine Campbell’s blog post, [How I Use Excel to Manage my Literature Review (2016-05-20)](https://alawuntoherself.com/2016/05/20/how-i-use-excel-to-manage-my-literature-review/) - Clarke keeps two types of spreadsheets: Major and Minor - Clarke uses a spreadsheet to capture the following data as she reads - ID number (I’ll come back to this) - Year - Author(s) + Year - Title - APA Reference - Type of Resource - Abstract - Keywords - Location (Canada, United States, United Kingdom, Other) - Purpose/Objectives - Research Questions - Survey/Interview/Focus Group Questions - Sample - Quantitative/Qualitative Design - Main Findings - Notes (including quotations) - This could easily work with [[Dataview SOP|Dataview]] and [[Obsidian]], and the templates with pre-populated data I export from [[Zotero]]