Importing my contacts from Outlook into Thunderbird
I'm switching from Outlook to Thunderbird Nebula 128.6.0 and I am attempting the import of my "Contacts" from Outlook into Thunderbird "Address Book" via .csv file. My contacts from Outlook are a mess as over the years I did not always enter them by manually as a field at a time. Sometimes the address entry was pasted into Outlook or via a download and this produces a .csv with a poor data structure. There is no way I would expect to get a decent data transfer from such a jumble so in an effort to supply Thunderbird with a half decent .csv file I decided to edit the Outlook exported .csv to match a Thunderbird .csv export. I made up a new Address Book in Thunderbird with a few names and addresses and exported it to a .csv. Unfortunately when I look into the exported file some data does not appear to have been exported. For example I only have one phone number exported under 'Work Phone' although there are two or more listings in my made up contact in the address book. The same with email addresses, only the first two listings are exported under 'Primary Email' and 'Secondary Email' although I have more in the made up contact in the Thunderbird Address Book. I wonder if anyone else has undertaken this task and can share any tips for the best way to approach this, or maybe tell me where Thunderbird is putting the data that it does not export? I note that Thunderbird structures the phone numbers as 'Work Phone', 'Home Phone', 'Fax Number', 'Pager Number', but the "New Contact" screen does not have any of these input options. I'm a bit stumped at the moment so any ideas or help would be most appreciated. Regards. Greg
تمام جوابات (2)
Just to share my experience: - phone numbers go ok, up to three - home, work, none - and they go in primary secondary and cell entries in CSV columns. - email addresses up to two. - I used same approach that you mentioned - first creating a sample of a few to work with. the export is limited, but the import appears to be wide open if you omit the first row of csv.
my suggestion if you have many multiple entries beyond that would be to create a second copy of your csv file, omitting the top row. Then, import to a new addressbook and then thunderbird will open a matching table to select the desired entries you want. Then, import to those selections and then browse addressbook to see where the entries ended up. From that, I think can then devise which columns for your purposes. If you're okay with two email address and no more than three phone numbers, you can probably bypass this manual process. Good luck. :)
Thank you David I will give it a go!