You can create multiple notes or tags from a CSV file. This is handy for importing data like NPS feedback, survey responses, and customer feedback to analyze in Dovetail, or if you have an existing set of tags you’d like to import.
CSV import is primarily designed for creating lots of small—to—medium notes, not importing large, formatted documents like interview transcripts. Your data should have at least one column for the title of each note (or tag), and then as many columns as you like for the content of the note.
The first row needs to be the title of each column. For example, if you’re importing survey responses, the first row should contain values like Name and Email, along with your questions like “Why did the chicken cross the Möbius strip?” and so on. (The answer is “to get to the same side.”)
You can map this field to multiple columns. We support all UTF-8 characters, including emoji, and the limit for content is 100,000 characters. This is a required field for notes but not tags.
You can map this field to one column. We recommend the ISO 8601 date format, otherwise YYYY/MM/DD HH:MM. This is an optional field.
You can map this field to one column. We support all UTF-8 characters, including emoji, and the limit for the title is 200 characters. This is an optional field.
Once you’ve got your CSV file in the correct format with the right columns, open the project you’d like to import your data into, then:
The next step is to select columns to import from your spreadsheet. If your spreadsheet contains a date column, Dovetail might have already detected it, and it’ll be green.
First, decide which column to set as the title:
Next, decide which columns to import as content. These columns will be imported as the ‘body’ of note. This will be the data you will highlight and tag, or if you’re importing tags, this will be the description for the tag.
If you’d like to analyze the sentiment of your data, keep the Analyze sentiment checkbox checked. Dovetail will add ‘Positive’ and ‘Negative’ tags to content that expresses a strong positive or negative sentiment.
Next to the button Import rows, open the select menu after ‘as’ and decide whether you’d like to import your data as notes (default) or tags. Open the select menu after ‘into’ and choose what group to put the imported data in.
Lastly, click Import rows to start the import. Dovetail will import the data in the green columns for every rows.
Here are a few things to note about CSV import: