All Collections
How to Analyze Research Using Delve
Add and manage transcripts
Importing survey results, spreadsheet or CSV data into Delve
Importing survey results, spreadsheet or CSV data into Delve

Converting spreadsheet data into text format

LaiYee Ho avatar
Written by LaiYee Ho
Updated over a week ago

Use Delve to analyze any text-based qualitative data, including open ended survey results.

Delve only takes direct imports of .docx or .txt files, but here are a few steps you can take to format your survey results for analysis in Delve.

Import spreadsheet or CSV data by converting it to document text format.

Watch our step by step video:

In 8 minute video, we show how you can use Google sheets to convert your CSV file into a format that is optimized for analysis in Delve.

Ways to organize your data

While Delve is optimized for transcript data from in depth interviews, you can still make it work for Delve. Each file in Delve is called a "transcript" but you can use each "transcript" to represent either a question or a single participant.

Option 1. Make each "transcript" document represent a question.

Have all the participants' answers to that question in that single document.

Example:

Transcript name:

"Question 1: How did you learn about this program?"

Transcript text:

"Alyssa: I learned about it from social media.

Mark: I heard about you after I searched on Google.

Jackson: My friend told me about this."

Option 2. Make each "transcript" document represent a participant.

Example:

Transcript name:

"Alyssa"

Transcript text:

"Question One: I learned about it from social media.

Question Two: I was a teacher for 12 years before we implemented this program.

Question Three: It ended up being a good experience for us."

Did this answer your question?