Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Convert Excel addresses into Address Book format Apps
I moved an address book with about 50 names in Excel's .xls format into the Adress Book using the Palm Desktop Software as a go-between in about five minutes.

Here's how...
  1. Just export the interesting section of the Excel file as a tab-delimited list .txt (use iCExcel or Excel itself).

  2. Create a new user in Palm Desktop. In the toolbar, click on your username, and then select "Edit users..." from the pop-up menu then click the New User button.

  3. Import the generated file with File -> Import...

  4. Select the proper format (Fields:Adresses, Delimiter:Tab and Return)

  5. Shuffle the fat-printed field names (eg: Name) into the corresponding places of your file (eg: Jones) then press OK.
Your data is now imported into Palm Desktop, and you are halfway through the procedure now. To finish:
  1. View the imported adresses in Palm Desktop (View -> Adress List) then select all the records (Command-A)

  2. Export the records (File->Export) in the appropriate Format (Format:vCard) as .vcf

  3. Open your Adress Book and drop the .vcf file onto the group you want your addresses to show up in, and voila, there they are!
No doubt the basic feature to import text files into the Adress Book should have been integrated already, but this solution is way less complicated than it sounds.
    •    
  • Currently 2.50 / 5
  You rated: 2 / 5 (4 votes cast)
 
[29,476 views]  

Convert Excel addresses into Address Book format | 2 comments | Create New Account
Click here to return to the 'Convert Excel addresses into Address Book format' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Mozilla
Authored by: macsforever2000 on Sep 16, '02 11:40:19AM

I did something similar. I exported my addresses into tab delimited format (from YoYo of all things!) but I simply used Mozilla to import them. Then Mozilla can export into LDIF format which is recoginzed by the new Address Book.

[ Reply to This | # ]

Mozilla
Authored by: yerdle on Mar 30, '05 09:25:27AM

Thanks. You both just saved me a lot of work!



[ Reply to This | # ]