Learn
Help
Updates

Go to app
Log inGet Dovetail free

Product

OverviewAnalysisInsightsIntegrationsEnterpriseChannelsMagicPricingLog in

Company

About us
Careers12
Legal

© Dovetail Research Pty. Ltd.

TermsPrivacy Policy
Help centerMake sense of your data

Import data to projects

Last updated30 September 2024
Read time7 min

Contents


Who can use this feature

👤 Available on all Free, Professional, and Enterprise plans

🔒 Managers and Contributors with edit access

Overview

In Dovetail, research data is stored in ‘notes’. Notes can contain text, images, audio, video, tables, a transcript from an audio or video file, and more. Notes are flexible and can support a wide variety of research methodologies and data formats including:

  • Raw notes taken during a customer interview.

  • Video or audio from interviews, usability test, sales call, or product demo.

  • Survey responses or qualitative customer feedback imported via a spreadsheet.

By housing data in notes, you can capture key moments by highlighting and tagging this content. For example, for any video or audio content uploaded into a note can be transcribed by an advanced AI-powered speech engine. From there, you can create highlights to turn your raw recording into tagged, searchable audio and video clips.


Import your data

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).

For import, 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.


Automatically import your data

Using Zapier and our Google Calendar and Outlook Calendar (Coming soon) integrations, you can import data into your project automatically.

With Zapier, you can import text-based data 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.

For automatically importing video recordings using our calendar integrations, you must be using Zoom. For example:


When you open your data, you'll see its body, the editor toolbar at the top, and a sidebar with icons to the right. In the sidebar, this is where you'll find and quickly navigate to your note's magic summary, highlights, tags, fields, and comments.

You can also collapse the sidebar from view. To do this, hover over the border and click the arrow to Hide sidebar. The sidebar can be re-opened at any time with the same action.


Working with transcripts

When you upload a video or audio file, we’ll automatically detect the language and generate a transcript and summary of your data.

Set a default transcription language

Workspace admins can set a default transcription language for your entire workspace, and users with edit access to a project can set a default language for that project only. This is great if your video and audio files are always in the same language, or if your language isn't supported for auto-detect.

  • To set the default workspace transcription language, workspace admins will need to navigate to Settings → Transcription → Workspace transcription language.

  • To set a default transcription language at the project level, open that project’s settings and navigate to Transcription → Project transcription language.

If you’ve already uploaded and transcribed a file and need to change the transcription language, open the note with the incorrect transcription and navigate to Transcription options (•••) → Language → select the correct language from the dropdown menu → Regenerate. Here, you can also choose to save this language for future uploads to this project, which will set the project’s default transcription language.

Important: Regenerating a transcript will remove any highlights created from the previous transcript and will regenerate the note summary


Supported transcription languages

You can transcribe conversations in 41 languages and receive a full native-language transcript back. Please find a full list of supported languages below.

AfrikaansArabic (Gulf)Arabic (Modern Standard)Bulgarian
CatalanChinese SimplifiedChinese TraditionalCroatian
CzechDanishDutchEnglish (US)
FarsiFinnishFrenchGerman
GreekHebrewHindi (Indian)Hungarian
IndonesianItalianJapaneseKorean
LatvianLithuanianMalayNorwegian
PolishPortuguese (Brazilian)RomanianRussian
SlovakSlovenianSpanishSwedish
TamilTeluguThaiTurkish
Vietnamese

Unsupported languages for auto-detect

Unfortunately, Dovetail cannot automatically detect every language that we currently support at this time. If the spoken language cannot be detected, a transcript will still be generated; however, it will not be accurate.

Please refer to the list of unsupported languages below before using auto-detect.

Unsupported languages for automatic detection

Bulgarian, Catalan, Czech, Greek, Finnish, Croatian, Hungarian, Lithuanian, Latvian, Norwegian, Polish, Romanian, Slovak, Slovenian, Swedish, and Vietnamese


Set up custom vocabulary for transcription

To improve the accuracy of transcripts, you can submit a list of custom words or phrases that are not found in a dictionary (for example, company names or industry jargon) before starting a transcription.

  • To do this, upload your file, select Begin, and navigate to Custom vocabulary.

  • From there, enter words or phrases into the textbox and select Start transcription when complete.

Share a custom vocabulary across the workspace

To avoid entering terms every time before a transcription, workspace admins can save a global list of up to 100 words or phrases by navigating to Settings → Transcription → Workspace custom vocabulary. This will apply to all transcripts users create across all projects.


Import your own transcript

For when you need human-level accuracy with your transcripts or to analyze conversations in a language that we don't yet support – we've also added the option to bring your own transcript (in the form of a caption file).

We support importing any WebVTT (Web Video Text Tracks) caption file. When you upload a .vtt caption file, we'll use the caption timestamps to sync with your video or audio file playback.

  • To import your own transcript, click ••• (Actions) below a video or audio file → Click Upload transcript → Select a compatible .vtt file.

Please note: When importing .vtt files, the speaker names must be formatted as <v NAME > for Dovetail to extract the speaker name correctly


Working with documents

Once imported, a preview of your document file will appear, allowing you to highlight, tag, comment and search text content within your project and workspace.

You can change the preview within your note to display: Full document, Single page or Card. To access these options, click on the "More" button in the preview window.

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


Import CSV spreadsheet data

You can create multiple notes at once from a single spreadsheet. This is handy for importing data like NPS feedback, survey responses, and customer feedback to bring in to Dovetail.

The file should be UTF-8 encoded Comma Separated Value (CSV) file with a header row and have at least 1 column each for:

  • Content – required, text format (300,000 character limit). This becomes the body of the note, which you can later highlight and tag.

  • Created date – must be in ISO 8601 date format or YYYY-MM-DD HH:MM

  • Title – text format (200 character limit)

During import, you will need to map columns from your spreadsheet to how it will be presented in your notes. For example, if you have a column for survey answers, you can add them to the body of your note by mapping this to the option ‘Content’.

If your spreadsheet contains a date column, Dovetail might have already detected it, which will be green.

Any fields that have been added to notes will also be available as fields to import into.

Automatic sentiment analysis for CSV import

You can leverage automatic sentiment analysis when importing a CSV document into notes to speed up your work.

To do this, toggle Run sentiment analysis on import and choose which sentiment analysis method you'd like to use.

  • General sentiment looks for any words that have strong positive or negative sentiment.

  • Targeted sentiment looks for strong positive or negative sentiment expressed in relation to something specific.

Sentiment analysis is conducted on the 'Content' column, and will be run on the whole note. Any sentences that are identified as having strong sentiments will be highlighted and tagged as either 'Positive' or 'Negative'.

FAQs


How do I import spreadsheet data into a specific group in a note board?

Groups and field values are now the same, so if you have a particular group you'd like to import data into, ensure that you set the correct field value for the data you're importing.

For instance, let's say you've grouped your view by Feedback type with values NPSIn app feedback, and Community chat. If you want to import some NPS feedback to the NPS column, you need to ensure that your csv data has a column that says "NPS." When importing the CSV, you need to match the Feedback type field with that column.

The uncategorized column is where content will appear when it doesn't have a field value associated with the field used in the Group by setting in the top right of the view. If we removed this, it would be challenging for you to figure out where notes (that don't have a field value assigned) have 'disappeared.'

How long should file import and transcription take?

Your recording will be uploaded into a note and processed to ensure fast playback. The amount of time this takes depends on the length of the recording. In general, processing takes about 30% of the length of the file; e.g. a 60 minute recording will take approximately 20 minutes to process and transcribe.

You can close the note and continue using other parts of Dovetail while your file is uploading. You can safely leave Dovetail entirely (e.g. close the browser window or turn off your computer) while it’s processing and being transcribed, and come back later as well.

What video and audio formats do you support?

Dovetail supports the following video formats: mp4, mov, mpeg, avi, and audio formats: mp3, m4a, and wav.

I can’t seem to get my CSV import to work! Is there anything I can do to troubleshoot this?

Yes! Before importing your CSV, review the below requirements to ensure a smooth import process.

  • Formatting like headings, bold, italics, lists, tables, and images are not supported when importing from a CSV. They may cause a failure.

  • The maximum length for notes is 300,000 characters. No single cell in your CSV file should exceed this limit. This will cause a failure.

  • Dovetail will interpret two newline characters as separate paragraphs.

  • Your file needs to be encoded as UTF-8 (this is usually the default).

  • Your CSV file should end in a .csv file extension.

I'm experiencing processing errors for my video/audio file

It is possible to experience a processing error when uploading a video or audio file into Dovetail. This may be due to the file being an unsupported file type or there's a corruption in the file.

To troubleshoot this, you may be able to get the file to process successfully by re-exporting and saving a new copy the file using QuickTime or VLC player. This file must be into one of our supported file formats for video and audio files.

Dovetail supports video formats - mp4, mov, mpeg, avi - and audio formats - mp3, m4a, wav.

Do you have any file size limits for upload?

Yes, please view our technical limits for files for more info! Technical limits

I'm not able to highlight and tag my note. How can I fix this?

There may be a few reasons for this!

  1. Your note may be locked from editing. The ability to edit a note can be toggled on/off in the top right corner of the note page.

  2. You may not have the right workspace role. Reach out to your workspace's admin to update your access to Manager or Contributor to edit project work in the workspace.

  3. You may not have the right project access to edit the project. Check the project's Share settings to review your access and reach out to someone with Full access to update your access.

Can I download a note/transcript from my project?

Yes! Check out Download project data with information on how to do this.

Can I share a link to just the highlights only version of my note?

It's only possible to share a link to the entire note at this time. You aren't able to copy a link that only contains the highlights only video/audio file with no other note data.

Can I edit imported documents/files?

No, you won't be able to edit any other file types when brought into Dovetail. You will only be able to highlight, tag, comment and search text content.

Give us feedback

Was this article useful?


Next article

Edit data and transcripts

Edit data and transcripts

Edit and update how your data is formatted in your project.

Last updated16 August 2024
Read time3 min

Product

OverviewAnalysisInsightsIntegrationsEnterpriseChannelsMagicPricingLog in

Company

About us
Careers12
Legal
© Dovetail Research Pty. Ltd.
TermsPrivacy Policy

Log in or sign up

Get started for free


or


By clicking “Continue with Google / Email” you agree to our User Terms of Service and Privacy Policy