UCLA Labor Center

Narrative Tools and Resources

We’ve created your very own narrative analysis toolkit!  The resources and tools feature below are open-access (free) and can support you in your narrative analysis research methodology.  Happy analysis!

Narrative Analysis & Excel

That’s right– you can utilize excel as a tool for text analysis!  Download the easy-to-follow guide below (citation and abstract below) and/or watch the video clips below to explore data analysis tools.

Amozurrutia, J.A., & Servós, C.M. (2010). Excel Spreadsheet as a Tool for Social Narrative Analysis. Qual Quant, 45, 953-967. DOI 10.1007/s11135-010-9406-9

Qualitative research is an open field where different researchers from several disciplines deal with social meanings and with the issue of understanding. During the last two decades, the use of computers and software has extended to become a relevant part of our daily landscape and also a basic device of social research, even in relation to a qualitative approach. There are many applications of qualitative research software specially designed by a diversity of firms and institutions producing different levels of sophisticated tools that can be used in the social research process. This paper presents a protocol for using an Excel spreadsheet as a tool for analyzing social discourses. We will show how to work with the documents produced in the empirical data collection and the criteria to structure the components of the application and its main representations. Finally, we offer a methodology for developing a personalized application in order to orient social design as a powerful and reflexive tool that contribute to a social thinking immersed in continuous improvement.


[youtube id=”c_r1eqwBlWM”]

Utilize excel as a means to perform text analysis. Excel allows you to automatically find unique phrase patterns within text, identify phrase and word frequency, custom latent variable frequency and definition, and find unique and common words within text phrases. Watch this webinar to better understand how to use excel to organize and code qualitative data.

 QDA Minor Lite

QDA Miner Lite is a free and easy-to-use version of our popular computer assisted qualitative analysis software.  It can be used for the analysis of textual data such as interview and news transcripts, open-ended responses, etc. as well as for the analysis of still images. This video is a short introduction to QDA Miner, a qualitative data analysis software for mixed methods research.

[iframe id=”https://www.youtube.com/embed/zYKxGSqQ1pY”]

Click here to download the QDA Minor Lite program.

Coding Analysis Tookit (CAT)

Coding Analysis Toolkit (CAT) is a free service of the Qualitative Data Analysis Program (QDAP), and hosted by the University Center for Social and Urban Research, at the University of Pittsburgh, and QDAP-UMass, in the College of Social and Behavioral Sciences, at the University of Massachusetts Amherst.  The toolkit consists of a ASP.NET based suite of tools to facilitate efficient and effective analysis of text datasets that have been coded using the CAT coding module or ATLAS.ti.  You can download the quickstart guide below:

Click here to download the CAT Quickstart Guide


Click here to download the CAT program. 


Click here to watch the introduction to coding data in CAT

Originally released in 2009, this video introduces the basic Coding Analysis Toolkit (CAT) features. CAT is a free, open source, web-based system for having multiple coders label a semi-structured text data set.