Spreadsheet (Excel) into Outlook address book

  • Thread starter Thread starter JamesH151
  • Start date Start date
J

JamesH151

I am making the conversion to Outlook, and would like to take my extensive
excel spreadsheet which contains all of my contact info, and convert it into
an address book file (.dat?)

Is this possible?

Thanks in advance
 
JamesH151 said:
I am making the conversion to Outlook, and would like to take my
extensive excel spreadsheet which contains all of my contact info,
and convert it into an address book file (.dat?)
Click to expand...

Outlook has no address book and does not use "address book files". Put
contacts into your Contacts folder(s) with FIle>Import and Export>Import
from another program or file. Make sure you've labeled the Excel columns
correctly and that you have selected and named the entire range of the data
you wish to import.
 
Is there any ambiguity as to what the naming convention of named ranges is?
I don't mean to sound flippant, but I can name the ranges whatever I want. I
suppose I could create a contact, export it...and determine names from there.
If I am making mistakes from the get go, please let me know.

Thanks
 
JamesH151 said:
Is there any ambiguity as to what the naming convention of named
ranges is? I don't mean to sound flippant, but I can name the ranges
whatever I want. I suppose I could create a contact, export it...and
determine names from there. If I am making mistakes from the get go,
please let me know.
Click to expand...

To import from a spreadsheet, you need exactly ONE named range. You select
the entire range of your data (all rows and all columns, including the
headers), then in the Name box to the left of the formula field, enter some
name you choose, like Contacts. Save the spreadsheet. Then when you
attempt to import the sheet in Outlook, you'll be able to specify that range
name when the wizard prompts you for it. You should be able to map the
appropriate columns when the wizard asks you for the mapping, but you could
simply export the existing contacts as a CSV and use the headers it shows in
your spreadsheet so you can use the standard mapping.

Alternatively, you can save your spreadhseet as a CSV and import from that.
You won't need a named range in that case.
 
Back
Top