Solved

Importing from Excel problems

Posted on 2006-11-28
3
277 Views
Last Modified: 2010-04-08
Hi experts,

I've found some help by searching here but still can't get a proper import of names and address from an Excel file. Can you see what I'm doing wrong, please? I've got contact details in an Excel 2003 spreadsheet and different ones in Outlook 2003, and I want to combine them by importing the spreadsheet information into Outlook.

1. My own Excel contacts spreadsheet is arranged with each row representing a person. and the columns represent the fields such as first name, company, mobile phone number etc
2. To get the right format, I exported my existing Outlook contacts into a separate spreadsheet using default mapping. I then copied the column headers in that spreadsheet into a new worksheet in my contacts spreadsheet. I then copied the columns of data from the first worksheet into the appropriate columns on the new worksheet. Hopefully this put my data into the format that Outlook expects for an easy import. Not all of the cells have data in.
3. I then named all the columns containing data with the same name as Outlook had put into export columns in row 1, such as "FirstName". I did this by highlighting each entire column from row 2 to the last row in the data range (that rectangle containing data in any column), then clicking the cell name box on the top left and typing in the name and pressing Enter.
4. I then deleted the original worksheet, leaving just the single worksheet in the file, containing my data in the format exported by Outlook previously with all the data ranges named.
4. I then tried to import from my new spreadsheet into the Contacts folder. However when I got to the "Import a file" dialogue, I can see all my named fields with unticked boxes. If I tick the first box next to "Import "BusinessPhone" into folder: Contacts" I get "Map custom fields" dialogue coming up. This shows "From: MicrosoftExcel (new line) BusinessPhone", then it says "Value (newline) F1". I've got a list of fields in the "To:" side, and if I scroll down to show Business Phone and then drag "F1" into it and click OK I go back to the Import a File dialogue. Looks reasonable. I repeat this for all the fields in Import a file dialogue, which are all my named fields. Most times if said "F1" as above, but sometimes it said something that I recognised to be the contents of the cell in row 2 of that column. I don't know where it was getting "F1" from.
5. Then click Finish.
6. Lots of importing goes on, and I find I've now got literally thousands of address cards, mostly blank, some containing just the first name, others just the last name, and so on - a card for every single cell in the spreadsheets data area! It has failed to import the cells from each row into a single address card which is of course what I expected.

Under Contacts in Outlook, I've got an area on the top left that shows 6 rows, "Contact", "Contacts in personal folders", "Search results in personal folders", then the last 2 again, and finally "Search results". I'm puzzled by this too!

Thanks,

Stuart
0
Comment
Question by:StuartOrd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 30

Accepted Solution

by:
irwinpks earned 250 total points
ID: 18026552
Save your Excel file as CSV and import it that way.
0
 

Author Comment

by:StuartOrd
ID: 18026695
Brilliant, that worked fine! Why don't they just tell us to do it that way...........?

Any idea why I've got the bit mentioned at the end? Tell you what, I'll post another question

Many thanks

Stuart
0
 
LVL 30

Expert Comment

by:irwinpks
ID: 18030125
I ran into that problem years ago, and found that CSV in it's raw form was easy to manipulate.

Thank you for the quick score! :-)
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

697 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question