Import Your Contacts into GMail您的联系人导入Gmail
November 23rd, 2007 · by David Bradley 2007年11月23日由戴维布拉德利
I’ve been using the Thunderbird email client for a couple of years now, prior to that I was using Pegasus Mail, but sometimes I’d prefer to be able to access my email online without having to worry about a program installed on an arbitrary laptop.我一直在使用的雷鸟电子邮件客户端了几年现在，在这之前，我用飞马邮件，但有时我更希望能够获得我的电子邮件网络，而无需担心程序上安装一个任意笔记本电脑。 As such, I thought it was time I exported my Thunderbird contacts and added them to my main Google mail account.因此，我认为这是当时我出口我的Thunderbird接触和他们说我的主要谷歌电子邮件帐户。
It’sa breeze to export your whole address book from Thunderbird.这是微风出口您的整个地址簿从雷鸟。 Simply click the Address Book icon in the toolbar (or hit Ctrl 2 in Windows).只要按一下通讯簿图标，工具栏（或Ctrl键2的Windows ） 。 Select the address book to export (I have all “collected” addresses added to my Personal Address Book in the program, so there is only one with any entries).选择地址簿出口（我有所有“收集”地址添加到我的个人通讯簿中的程序，所以只有一个与任何条目） 。 Then choose the address book’s Tools menu and click Export.然后选择地址簿的工具菜单，并单击导出。 the default format is LDIF, but you can choose from Tab Delimited and Comma Separated.预设的格式是LDIF ，但你可以选择制表符分隔和逗号分隔。 It’s the latter, comma separated (CSV) you want for GMail.这是后者，逗号分隔文件（ CSV ）您想要的Gmail 。 Save the file.保存该文件。
Next, login into your GMail account and choose the Contacts link.下一步，登录到您的Gmail帐户，并选择联系人联系。 Once you’re on that screen you will see two links in the blue above your current listing of contacts - Import Export.一旦你的屏幕上你将看到两个链接在上面蓝色您目前上市的接触-进出口。 The choice is obvious - Import.选择是显而易见的-导入。
In the popup dialog box, browse for the CSV file you just created in the Thunderbird (or other email client).在弹出的对话框中，浏览档案您刚刚创建的雷鸟（或其他电子邮件客户端） 。 Now, click the Import Contacts button.现在，请按一下按钮，导入联系人。 GMail will extract each comma separated entry from the file and add each contact to your GMail contacts list. Gmail将提取逗号分隔每个项目从文件和每个联系人添加到您的Gmail通讯录。 Now that is done, you can access your email contacts anywhere you can login to your GMail account.现在能做到这一点，你可以访问您的电子邮件联系，您可以随时随地登录到您的Gmail帐户。
Of course, Google is also rolling out IMAP access to GMail which will allow you to synchronize your email client with your email account too.当然，谷歌还推出了的IMAP访问Gmail ，让您同步您的电子邮件用户端与您的电子邮件帐户过多。
WARNING: Your mileage may vary, apparently it doesn’t work quite so slickly for some users for some unknown reason.警告：您的里程可能会有所不同，显然它并不那么slickly给一些用户对一些原因不明。 So please test on a small data set before you run it on a 1000+ contacts list.所以，请测试一个小的数据集，然后才能运行在一个1000 +的联系人列表。
30 responses so far ↓ 30日的答复迄今↓
Actually, I was a little economical with the truth in terms of how slick the process is.其实，我是一个小的经济与真理在如何带过程。
I had thousands of contacts in Thunderbird and received this message:我有成千上万的接触， Thunderbird和收到此讯息：
“Import completed, 3000 contacts have been successfully imported. “导入完成后， 3000联系人已成功导入。 Your contacts file is too large to be imported all at once.”您的通讯录文件太大，无法一次全部导入。 “
So, I ended up having to split the Thunderbird CSV file and carrying out the import in two steps.所以，我最后不得不分裂雷鸟CSV文件并进行进口分为两个步骤。 But, that’s not too time consuming.但是，这不是太费时。
russ // 拉斯 / / Dec 16, 2007 at 4:09 pm 07年12月16号在下午4点09
hmmm…didnt work for me, it said no contacts imported because they had no name or email - the csv export from thunderbird is a different format to gmail. hmmm ... didn't工作对我来说，这表示没有任何接触进口的，因为他们没有姓名或电子邮件-出口的C SV从雷鸟是不同的格式到G mail。 darn it, thought it was going to be easy织补它，认为这是将容易
Hmmmm indeed.经由确实。 It worked reasonably well for me, aside from the number limitation.它的工作相当不错对我来说，除了数量的限制。 But, I see how it could go wrong, like you say where a contact is listed in the Thunderbird address book only as an email not by name.但是，我看到它如何能出问题，像你说的是一个接触中所列的地址簿雷鸟只是作为一个电子邮件而不是由名称。 If I find out any more on that I’ll let you know or if any readers have insights please post them here.如果我发现任何更多的，我会告诉您如果读者有任何见解，请在此。
Mana // 法力 / / Dec 22, 2007 at 8:04 pm 2007年12月22日在下午8点04
This also happened to me.这也发生在我身上。 I have 7o contacts in my Thunderbird address book, and they all have a name and and email.我7o接触我的Thunderbird的地址簿，他们都有一个名字和和电子邮件。 However, after I save it as a .csv, I try to import them and this message pops up:然而，当我将它保存为以。 csv ，我尝试汇入他们和这个讯息弹出：
“We were not able to import any of the “我们无法进口任何
contacts found in the uploaded file.接触中找到上传的文件。
69 contacts have been ignored because 69接触已被忽略，因为
they didn’t have a name or email.”他们没有姓名或电子邮件。 “
Like I said, I have 7o addresses stored in my address book, and they are all located in the same folder - the personal one.正如我所说的，我有7o地址保存在我的地址簿，和他们都设在同一文件夹中-个人之一。 But to say 69 contacts have no name or email means that one of my 7o contacts “fits” the requirements (though, technically, all of them do).但是，要说69的接触没有姓名或电子邮件意味着，我的一个7o接触“适合”的要求（虽然，在技术上，他们都这样做） 。
Maybe having only a tiny bit of HD space left might affect this, but I don’t know…也许只有一点点的HD剩余空间可能会影响到这一点，但我不知道...
Please help, and thanks.请帮助，并感谢。
John // 约翰 / / Jan 15, 2008 at 5:10 am 2008年一月十五日在上午05时一十
Didn’t work for me either.没有工作对我来说不是。 After several attempts, I gave up and exported contacts to Outlook Express, and from there sent them to Gmail.经过多次尝试，我放弃了和出口接触到Outlook Express ，并从那里把他们送到到Gmail 。
I blame Outlook!我谴责展望！
db分贝
obfusco // obfusco / / Jan 16, 2008 at 5:08 am 2008年1月16日在上午05点08
Sounds like the problem might be missing csv headers, the first line should have a comma separated list of field titles:听起来这个问题可能是失踪的csv格式的标题，第一行应该有一个逗号分隔的列表外地标题：
first name,last name,display name,nickname,email address,alt email address, work phone,home phone,fax,pager,mobile,address1,address2,city,stat e,zip,country,work address1,work address2,work city,work state, work zip,,,,organization,,,,,,,,,,notes名字，姓氏，显示姓名，昵称，电子邮件地址，旧的电子邮件地址，工作电话，家庭电话，传真，寻呼，移动电话，地址，地址，城市，状态，邮政编码，国家，工作地址，工作地址，工作城市，工作状态，工作拉链， ， ， ，组织,,,,,,,,,,说明
was suggested at有人建议在 http://broadbandforum.in/procedures/3902-exporting-thunderbird-address-book-gmail/
See also又见 http://mail.google.com/support/bin/answer.py?answer=12119
Obfusco, thanks for the insights and links. Obfusco ，感谢您的见解和联系。 Hopefully, anyone having problems will be able to figure out a fix from that information.我们希望，任何人有问题将能够制定出一个解决该信息。
db分贝
Anonymous // 无名氏 / / Jan 29, 2008 at 12:34 am 2008年1月29日在上午12时34分
David, Obfusco - I’ve had problems also.大卫Obfusco -我有问题也。 Apparently when I imported contacts into gmail, some unrecognized fields were mangled.显然当我进口的联系人导入Gmail ，一些无法辨识领域的错位。 That resulted in some fields containing newlines.这导致在一些领域包含换行符。 When exporting this from Google, the newline is exported inside a quoted field, but Thunderbird (and OpenOffice Calc) still treat it as the start of a new line - not a field with a newline.当出口从谷歌的换行符出口援引内场，但雷鸟（和OpenOffice计算）仍把它当作开始了新的生产线-不是一个领域一个换行符。
Does anyone have a foolproof way to do this?有谁有一个简单的办法做到这一点？ It seems that lots of readers are having problems and the solution I offered does not work universally.看来，很多读者有问题和解决我提出不普遍。
db分贝
Dmitry // 德米特里 / / Feb 12, 2008 at 7:53 pm 2008年二月12日在下午7点53分
It worked for me, but just barely.它的工作对我来说，只是勉强。 Gmail imported the Thunderbird CSV file, but it recognized the Nickname field as Name, and dumped everything else into Notes - including the e-mail address. Gmail的进口雷鸟CSV文件，但它承认昵称领域的名称，并抛弃一切到笔记-包括e - m ail地址。 So to use this address book I have to copy the e-mail from Notes to its proper field for each of the contacts.因此，使用此地址簿我要复制电子邮件说明其适当领域的每个接触。
Perhaps the solution is to edit the Thunderbird CSV and rename the fields so that gmail can recognize them.也许解决办法是修改雷鸟CSV和重新命名等领域，才能使Gmail可以识别它们。
Interesting thought Dmitry.有趣的思想德米特里。 Maybe someone could create an addon for Thunderbird that would hack the database appropriately…也许有人可以创建一个附加的雷鸟将破解适当的数据库...
db分贝
avko // avko / / Feb 14, 2008 at 5:10 pm 08年二月14日在下午5点10分
It worked for me, using obfusco’s method:它的工作对我来说，使用obfusco的方法：
1) export from Thunderbird to ‘comma separated’ file 1 ）出口雷鸟，以'逗号分隔'文件
2) open file in notepad 2 ）打开文件在记事本
3) replace first line with: 3 ）替换第一线为：
first name,last name,display name,nickname,email address,alt email address, work phone,home phone,fax,pager,mobile,address1,address2,city,stat e,zip,country,work address1,work address2,work city,work state, work zip,,,,organization,,,,,,,,,,notes名字，姓氏，显示姓名，昵称，电子邮件地址，旧的电子邮件地址，工作电话，家庭电话，传真，寻呼，移动电话，地址，地址，城市，状态，邮政编码，国家，工作地址，工作地址，工作城市，工作状态，工作拉链， ， ， ，组织,,,,,,,,,,说明
4)save 4 ）保存
5) import into gmail 5 ）进口到Gmail
This worked also for contacts without e-mail address这个工作还没有接触e - mail地址
Many thanks for the walk-through Avko!许多感谢，步行通过Avko ！ Maybe others will have equal success using that approach.也许其他人都享有平等的成功使用这种办法。
db分贝
I hit the same wrinkle.我击出相同的皱纹。 After reading the suggestions here and trying a few things, I can report that the column names (of interest to me) ‘Display Name’ and ‘Primary Email’ should be renamed ‘Nickname’ and ‘Email’ (case sensitive) when exporting to Gmail.在阅读的建议，并试图在这里几件事，我可以报告说列名称（感兴趣的我） '显示名称'和'主电子邮件，应改名为'昵称'和'电子邮件' （区分大小写）当出口Gmail了。 That solved my problem.这解决我的问题。 Thanks for having this discussion.多亏了这次讨论。
Darwins last blog post..文思最后的博客帖子.. Esbjörn Svensson: When Everyone Has Gone Esbjörn斯文森：当每个人都已经
Many thanks for the extra tip Darwin.许多感谢达尔文额外的小费。
emorris // emorris / / Jul 12, 2008 at 12:15 pm 2008年7月12号在下午12点一刻
@avko + others: @ avko +其他：
You need to use ‘E-mail Address’ and ‘Alt E-mail Address’.您需要使用' E - mail地址'和'备选E - mail地址。 The dashes in E-mail are important, otherwise GMail will not recognise it as the email address.破折号中的电子邮件是重要的，否则Gmail将不承认它作为电子邮件地址。
All I did was (on the first line) change ‘Primary Email’ to ‘E-mail Address’ and ‘Secondary Email’ to ‘Alt E-mail Address’.我所做的只是（第一线）的变化，主要的电子邮件'至' E - mail地址'和'次要电子邮件'至'备选E - mail地址。 Thanks.谢谢。
Neil Ehrenberg // 尼尔藻 / / Jul 29, 2008 at 8:27 am 2008年7月29日在上午08时27分
I hate to sound like a broken record, but I too had the same type of problem exporting the e-mail addresses from Thunderbird ( Using Vista) as others have mentioned.我恨听起来像一个打破纪录，但我也有同样类型的问题，出口e - mail地址从雷鸟（使用Vista ）为他人所提到的。 I followed the above suggestions on changing the words in the first line (block or column titles) from the original .CSV file as recommended.我也跟着上述建议改变的话在第一线（块或列标题）从原来的。 CSV文件的建议。 The original .mab file was 469KB.原来的。人与生物圈计划文件是469KB 。 The CSV ended up only 76KB and I thought I lost contacts when only 15 showed up.名额的CSV只有76KB ，我想我失去了联系，当时只有15个出现。 After editing the first line (I found that each title with the comma separation could stay as Capital and lower cased letters) and then importing the revised CSV file, I ended up with 901 contacts (WOW).修改之后的第一线（我发现，每个标题与逗号分开可以留作为资本，降低套管字母） ，然后导入CSV文件修改，我结束了与901联系系统（ WOW ） 。 It just took a while for G-mail to turn them into the correct looking contact..这只是花了一段的G邮箱把它们变成正确的期待与.. Thanks to all who participated in the above discussions.感谢所有谁参加了上述讨论。
Here is how mine looked:以下是如何防雷期待：
First Name,Last Name,Display Name,Nickname,E-mail Address,Alt E-mail,Work Phone,Home Phone,Fax,Pager,Mobile,Address1,Address2,City,State,Zip,Country,Work Address1,Work Address2,Work City,Work State,Work Zip,Work Country,Job Title,Department,Organization,Web Page 1,Web Page 2,Birth Year,Birth Month,Birth Day,Custom 1,Custom 2,Custom 3,Custom 4,Notes,名字，姓氏，显示姓名，昵称， E - mail地址，备选电子邮件，工作电话，家庭电话，传真，寻呼，移动，地址，地址，城市，州，邮政编码，国家，工作地址，工作地址，工作城市，工作状态，工作邮编，劳动国别，职称，部门，组织， Web页1 ，网页2 ，出生年份，出生月份，出生日，自定义1 ，自定义2 ，自定义3 ，自定义4 ，债券，
Neil Ehrenberg, San Jose, CA尼尔藻，加利福尼亚州圣何塞，
gHacks has an alternative approach that might work better for those Scientext.com readers struggling with CSVs etc有一个替代的办法，可能会更好地为这些Scientext.com读者挣扎CSVs等
I can confirm that Neil Ehrenberg’s method worked perfectly for me.我可以证实，尼尔藻的方法完美的我。
I couldn’t get it to work with any of the other responses though; Gmail just dumped all of the details into “Notes”, which was useless…我无法让它与任何其他的反应虽然;的Gmail刚刚倾倒的所有细节到“注释” ，这是无用...
Gary C // 加里ç / / Sep 15, 2008 at 3:47 pm 9月15日， 2008年在下午3时47分
I used Neil Ehrenberg’s suggestion (dropping that final dangling comma after Notes) and it worked well.我用尼尔藻的建议（下降，最后悬逗号后注） ，它运作良好。 You may get some errors and you should look at them RIGHT AWAY, as it seems that once you move on you can never see which ones got “ignored” etc.您可能会得到一些错误，你应该看看他们马上，因为它看来，一旦你进入你不能看到了哪些“忽略”等
Thanks to all who have participated in this thread.感谢所有谁参加了这个线程。 VERY HELPFUL!非常有帮助！
John // 约翰 / / Sep 27, 2008 at 11:36 pm 9月27日， 2008年在下午11时36分
emorris, thank you on your note about having to use ‘E-mail Address’ and ‘Alt E-mail Address’ as the column headers. emorris ，谢谢你注意到了有关使用' E - mail地址'和'备选E - mail地址'的栏标题。
Joe // 乔 / / Sep 30, 2008 at 4:44 pm 9月30日， 2008年在下午4时44分
I tried david’s and then obfusco’s approach, stupidly trying to load them in without testing the approach.我试图大卫然后obfusco的办法，傻试图加载它们在未经检验的办法。 Now I have 2 times 2800 unsearchable emails described as (unnamed contact).现在我的2倍2800 unsearchable电子邮件描述为（匿名联系） 。 When you click on one, you can see all the detail, but gmail can’t.当您按一下，您可以看到所有的细节，但Gmail不能。 When I tried to delete them All, I was told you can only delete 500 at a time, and I don’t see a button for 500.当我试图删除一切，我被告知你只能删除500的时间，我没有看到一个按钮，为500人。 This is a prescription for carpel tunnel of the finger.这是一种处方皮隧道的手指。
Ouch!哎哟！ Sorry Joe.对不起乔。 I’ve amended the original post to warn users to test on a small data set first.我已经修改了原来的文章警告用户测试在一个小的数据集第一。
Twila // Twila / / Oct 2, 2008 at 11:33 pm 2008年10月2日在下午11点33分
Regarding selecting only 500 addresses at a time to delete (see Joe’s post):关于仅选择500个地址的时间删除（见乔后） ：
Select one address, hold down the shift key and click an address further down (can be several pages down).选择一个地址，按住SHIFT键，然后按一下讲话进一步下降（可多个页面向下） 。 Continue to hold down the shift button until the computer catches up to you.继续按住SHIFT按钮，直到电脑赶上你。 You can unselect this way also if you go too far: continually keeping the shift button down, back track until you have what you want selected.您可以取消这种方式也如果你走得太远：保持不断的转变按钮，返回轨道，直到您想要选择。 Let up on the shift key and press the “delete” key.让我们行动shift键，然后按下“删除”键。
Hope this makes sense.希望这是很有意义的。
Doretta Harter // Doretta哈特 / / Oct 4, 2008 at 2:17 am 08年10月4日在上午2时17分
I’m new to g-mail.我新来克的电子邮件。 I read with interest on how to export Thunderbird Personal Address Book.我阅读兴趣就如何出口雷鸟个人通讯录。 I have worked weeks on this, literally to the point it is making me ill.我工作过的周上，字面的一点是让我生病。 Can anyone help this 75 year old lady?任何人都可以帮助这个七十五年老太太？
Trent // 特伦特 / / Oct 10, 2008 at 10:14 am 二〇 〇八年10月10日在10:14 am
Easy way:简单的方法：
1. 1 。 Export LDIP from Thunderbird从出口LDIP雷鸟
2. 2 。 Import into Outlook Express导入Outlook Express的
3. 3 。 Export from outlook as a csv从Outlook导出为CSV
4. 4 。 Import into Gmail导入到Gmail
I had to do all this, so I could finally import contacts into Twitter我只好把所有这一切，使我终于可以接触到的进口开源
5. 5 。 Import into twitter via Gmail导入叽叽喳喳通过Gmail
What a mess really.真是一个烂摊子真的。
If only there were a universal tool that could pull together all contacts and emails, sort them, remove the duplicates, make sure each name had a tag, email and their web addres…如果只存在一个普遍的工具，可以将所有的接触和电子邮件，排序，删除重复，确保每个名称有标记，电子邮件和网页地址...
Dream on.梦的。
wrybread // wrybread / / Nov 13, 2008 at 1:59 am 08年11月13号在上午01时59分
I too had a problem importing email from Thunderbird to Gmail.我也有问题进口雷鸟电子邮件到Gmail 。 Gmail would dump everything into the “notes” field, and name the contact “unnamed contact”. Gmail的垃圾都将纳入“注意到”的领域，名称的接触“匿名接触” 。 Nice.好的。
I tried the solutions here and they didn’t work for me.我试图解决在这里和他们没有对我的工作。 What did work was opening the .csv file that was exported from Thunderbird and changing the first line to this:什么工作是开放的。 csv文件，是出口的雷鸟和不断变化的第一线，以这一点：
First Name,Last Name,Name,Nickname2,E-Mail,alt email address, work phone,home phone,fax,pager,mobile,address1,address2,city,stat名字，姓氏，姓名， Nickname2 ，电子邮件，旧的电子邮件地址，工作电话，家庭电话，传真，寻呼，移动电话，地址，地址，城市，统计
That’s similar to a suggestion here, but note that email is called “E-Mail”, and the display name is Name.这是类似建议，但指出，电子邮件被称为“电子邮箱” ，并显示名称是名称。 You can probably call what I’m calling Nickname2 simply Nickname, I did that for testing but it worked so I didn’t change it back.或许您可以要求什么我打电话Nickname2只是昵称，我这样做的测试，但它使我没有改变它回来。
It still dumps all snail mail addresses into the Notes field, but at least it puts the email addy into the email field, which means the address book is usable for sending emails.它仍然堆放场的所有电子邮件地址蜗牛的债券领域，但至少它把电子邮件阿迪到电子邮件领域，这意味着地址簿是用于发送电子邮件。
I’m amazed this was so hard.我很惊讶，这是如此艰苦。
By the way you can see what field names gmail expects by exporting your gmail address book and having a look at the headers.顺便说一下你可以看到什么字段名称的Gmail预计出口您的Gmail地址簿，并看一看标题。
Danny // 丹尼 / / Nov 28, 2008 at 10:54 am 2008年十一月二十八日在上午10时54分
None of the above solutions fully worked for me (although I didn’t try the outlook approach).以上都不是解决方案完全适合我（虽然我没有尝试的前景办法） 。 When importing a csv file from thunderbird Gmail would put the email address in the notes section.当导入csv文件从雷鸟的Gmail将电子邮件地址的说明中区段。
I tried exporting a couple of email addresses from gmail to see what format it would like.我试图出口一对夫妇的电子邮件地址在Gmail中看到什么格式它想。 It was a csv format with Name, E-mail and Notes fields.这是一个csv格式的姓名，电子邮件和债券领域。 I took my exported csv file from Thunderbird and changed the columns to match what gmail exported.我把我的出口csv文件从Thunderbird和改变了列匹配的Gmail出口。 This new file imported successfully and put the email address in the correct location.这种新的文件已成功导入和实施中的电子邮件地址的正确位置。 Note, after importing I composed an email, but the auto-suggest of email addresses did not initially work.请注意，进口后我组成一个电子邮件，但自动显示的电子邮件地址起初没有工作。 After I moved a suggested email address into my contacts then the auto-suggest started working for all my contacts.当我提出一项建议的电子邮件地址到我的接触，然后自动开始工作建议为所有我的联系人。
Leave a Comment发表您的评论