►
From YouTube: How to structure data in Dovetail using import
A
So,
let's
start
in
dovetail
and
let's
have
a
look,
how
we
normally
structure
our
data.
So,
as
you
can
see
here,
we
normally
do
it
by
grouping
our
content
by
users
and
by
that
we
list
all
our
questions
and
answers
that
apply
to
individual
user.
On
the
same
on
the
same
card,
in
the
same
document
by
that
we
can't
really
compare
these
answers
and
we
can't
get
a
sense
of
priority
importance,
because
we
can't
really
know
to
how
many
users,
the
specific,
positive
or
negative
feedback
applied,
and
we
can
still
do
it.
A
We
can
still
extract
it
from
here
and
create
new
cards,
but
this
is
yeah.
This
is
a
very
manual
task
and
yeah.
We
probably
don't
want
to
do
it
so,
instead
of
that,
what
I
would
like
to
suggest
is
to
group
your
questions
or
group,
your
data
by
questions-
and
this
is
your
end
result.
So
you
see
a
list
of
questions
that
you
asked
during
your
interview
or
your
usability
session
and
all
the
answers
on
the
card.
A
With
with
this
question,
and
by
that,
as
you
can
see
here,
you
can
easily
compare
these
answers.
You
can
get
a
quick
sentiment
like
whether
this
was
in
general
positive
or
negative
feedback,
and
you
can
quickly
convert
it
to
insights
and
recommendations.
A
Okay,
so
how
to
start.
The
important
first
step
is
to
take
all
your
notes
in
a
spreadsheet,
and
this
is
important
to
well.
You
can
do
it
in
google
spreadsheet,
you
can
do
it
in
microsoft
excel.
The
important
thing
is
that
you
have
your
questions
in
the
first
column
and
answers
that
apply
to
your
participants
in
other
columns
like
we
showing
here
in
this
example,
then
the
next
step
is
to
download
it
and
again
important
thing
is
to
do
it
as
a
csv
file.
A
A
In
this
step,
you
mark
you
mark
your
content,
so
you're
telling
dovetail
how
the
data
in
your
files
should
be
treated.
The
the
questions
that
you'll
be
using
will
become
eventually
cards
or
titles
of
your
cards,
and
answers
from
your
users
will
become
content
on
these
cards.
You
repeat
that
for
every.
A
Okay
very
quickly,
you'll
see
the
result
of
the
import,
so
you
see
all
the
questions
from
from
our
study
and
now
the
first
thing
what
I
normally
do
I
is,
I
try
to
group
them
by
themes.
So,
as
you
could
see,
we
had
some
questions
about
the
experience
we
had
some
questions
about
about
the
company
type
or
the
or
broaden
sense
about
the
user.
So
we
can.
A
We
can
just
quickly
create
one
group
which
will
be
about
experience
with
gitlab,
and
this
question
will
definitely
apply
to
it
and
this
one
as
well
and
another
group
about
about
the
user.
Okay.
A
So
if
we
want
to
then
for
example,
and
get
a
sense
like
from
which
what
what
kind
of
companies
they
were,
they
were
coming
from
their
their
job
titles
we
can.
We
can
find
these
answers
in
this
group.
A
Okay,
the
next
step
is
to
go
to
individual
questions
and
and
try
to
use
our
tags
to
to
help
us
get
a
better
sense
understanding
of
of
their
feedback.
So,
as
you
can
see
here
dovetail
already
applied
some
some
tags
positive
darks.
But
when
you
review
this
this
file,
you
can
also
correct
it.
A
If
you
think
that
it's
not
it's
not
exactly
what
what
the
user
said
and
also
apply
new
tags,
if
you
think
it
makes
it
make
sense
here,
okay,
so
you
have
you
have
your
questions,
all
the
answers
in
the
same
document
on
the
same
card,
and
now
you
can
easily
convert
it
to
to
a
highlight
and
and
change
it
later
to
a
recommendation.