How to export or save a .csv file from Excel
This video show you how to save or export a comma delimited file, or -csv- file from excel in order to import into your conXt address book or many other places.
Closed Caption:
in this video I'm going to show you how
to save an excel file as a CSV file or
comma delimited file as it's known and
the file that we will end up with is a
dot CSV extension in it and that's the
kind of file that you will need to
upload it to connect and is often the
kind of common currency to move data
between different platforms
so what you see right here in front of
you is just an Excel document that i
created over standard contacts excel and
only has this many fields but you could
have as many fields as you want and all
i'm going to do i'm in office 2010 but
it is generally the same for all the
various versions of office
i'm going to go to file save as down
here under save as type
i'm going to choose , the limited . csv
i'll just leave the name example . csv
and i'm going to click save now it's
important to note you're going to see to
dialog boxes pop-up just warning you
that the format is different you're
going to click ok on the first one
you're going to click yes on the second
one and what that's going to do is now
save that as a CSV file
let's take a look and there's our
example that CSV file
now let's go ahead and quickly import it
i'll click on more options click on
browse choose custom format
first click on browse click on example .
csv the form the file we just created on
this double click
now make sure that all of the tags to
see if that will calm the left is your
CSV file and on the right are the kinect
fields make sure they match
i'm going to say do not import on the
middle name all the other ones match
automatically and then i'll click import
and here we go it was Count Dracula
thanks thanks
Video Length: 02:31
Uploaded By: conXtAddressBook
View Count: 73,786