Import data to projects

​

Overview

Text, audio, video, and documents can be imported into projects for you to analyze, and transform common themes into docs. These include:

• Raw notes taken during a customer interview.
• Video or audio from interviews, usability test, sales call, or product demo.
• Survey responses imported via a spreadsheet.

By housing data in projects, you can capture key moments by highlighting and tagging this content. For example, any video or audio file imported into a project can be transcribed by an advanced AI-powered speech engine. From there, you can create highlights that turn your raw recordings into tagged, searchable audio and video clips.

---

​

What data can be imported into a project?

Managers and Contributors can import data into a project using the file picker, or using one of our integrations including Google Drive, Zoom, or OneDrive. We currently support the following file types for projects:

• Video and audio files: Zoom cloud recordings, Google Meet recordings, Teams cloud recordings
• Documents: PDFs (.pdf), Microsoft Word documents (.docx), Microsoft Powerpoint files (.pptx), Keynote presentations (.key), Apple Pages (.pages), Google cloud documents (sheet, slide or drawing), OneDrive documents (PDF, Word documents, Excel sheets and Powerpoint)

When importing any file type, you can select one or many files at a time. When importing files in bulk, these will be housed as individual data points in the same project.

---

​

Import video or audio files

The most common type of data imported into project are video and audio files. If you just want a transcript of one recording, Transcribe a video walks through it end to end. You can import video or audio files into a project in one of three ways – directly from your computer, selecting your files via an available integration, or by setting up a calendar sync to import recordings automatically from events.

• To import your data, select Import or + in the top right of the screen in your project.
• From there, select your files from Google Drive, Zoom, OneDrive, or your computer.

To automatically import video recordings using our calendar integrations, you can set up a calendar sync with Google Calendar or Outlook Calendar. We currently support importing Zoom or Teams cloud recordings with the below combinations:

• Zoom with Google Calendar or Outlook Calendar
• Teams with Outlook Calendar

Once set up, recordings will be automatically added to your project once the live event has completed.

---

​

Import presentations and documents

Any document brought into Projects is powered by Optical Character Recognition (OCR) to help transform them into machine-readable content that can be instantly summarized and surfaced in search alongside workspace data. We currently support PDFs (.pdf), Microsoft Word documents (.docx), Microsoft Powerpoint files (.pptx), Keynote presentations (.key), Apple Pages (.pages), Google cloud documents (sheet, slide or drawing), OneDrive documents (PDF, Word documents, Excel sheets and Powerpoint).

• To import your document, select Import or + in the top right of your project.
• Once imported, your document will live as a standalone object in your project. From there, you can change the preview within your note to display: Full document, Single page or Card.

Note: preview won’t be available for other filetypes, e.g. zip files

---

​

Import survey data from a spreadsheet

You can import survey response data from a CSV spreadsheet for deeper analysis alongside your customer calls. In a project, you can view each participant’s completed survey structured on a single page, with a breakdown of each question and answer they have submitted. The file should be UTF-8 encoded Comma Separated Value (CSV) file with a header row and have at least column each for:

• Title – text format (200 character limit). This is typically the name or unique identifier of the survey participant.
• Content – required, text format (300,000 character limit). Columns mapped to Content become the body of data object that will be analyzed. For surveys, question columns will be automatically mapped to content.

A basic example of how the CSV should be structured is: For columns that are survey questions, we will also automatically format these as Free text, Single select or Multi-select at import. To ensure multi-select answers are imported correctly, add ; between options in the CSV. For example:

• To import a CSV, select Import or + in the top right of the screen in your project and select your file.
• From there, review and confirm what columns from your spreadsheet you wish to import and preview how it will be presented on a page in your project.
• Once import is complete, each participant’s completed survey will map as a single object in your project, with each question and answer mapped into it’s own question block.

---

​

Import historical data in bulk

Easily migrate and consolidate your customer data into projects using bulk import. This allows you to upload multiple files and folders at once, streamlining your workflow. Read our doc on how to prepare and import folders of historical data into Dovetail →

---

​

Automatically import data using Zapier

With Zapier, you can import text-based data automatically into a project from other apps. For example, you could create notes from SurveyMonkey responses, connect an NPS tool like Delighted or AskNicely, or add people to your database via a Google Form. To view what apps you can use via Zapier, please view our Zapier directory.

​

FAQs