Each row must have the minimum required information and no duplicate contacts. Review your import file for accuracy: You’ll want to review the accuracy of each email address and/or physical address for each of your contacts.Note: There cannot be any AOL email addresses in the first 5 rows or the import file will not start. If there is any missing information in these rows the import process will not start. Verify the first 5 rows are complete: This will be rows 2 through 6.Verify every row has the minimum required information: Regardless of if you exported your file from another program or created your own list, each row must have a First Name, Last Name, and either an Email Address OR Complete Physical Address.Now that you have created your import file, you will want to review your file and make sure it is ready to be imported: Do not add, delete, or move any columns or rows. You will keep the exported file exactly as it is when you exported it. If your contacts are stored in Outlook 2007, Top Producer 8i, or MyRealEstateTools, you will first need to export your contact database from one of those programs. Exporting Outlook 2007, Top Producer 8i, or MyRealEstateTools/MyRedTools File Types Note: If there is not an exact corresponding column in the template, you will either have to select a similar column heading or manually enter that information after you have completed the import process. The file will not import unless you change the column heading to Email Address 1.įor any column that has information you want imported, you will need to change the column heading to match the Basic Contact List template. Notice how the email address column is titled E-mail Address. You do not need to re-order your columns.įor example, if you export your contacts from Gmail and open the exported file in Excel, the column headings will look like this: Only the column headings have to match in order to import your file. Note: The order of the columns will not affect the import. You will need to make sure that the column headings in row 1 of the file you exported match the way the column headings in the Basic Contact List Template are spaced and capitalized. If your contacts are stored in any program other than Outlook 2007, Top Producer 8i, and MyRealEstate Tools, you will need to export your contacts from that program first. Complete Physical Address (address, city, state, zip).Enter the following required information: To create your own list, open the template you just saved. Note: If you do not have Microsoft Excel, please review the FAQ tab for this page on the steps you’ll need to take. You can then save this file to your computer. If prompted, choose to open the file in Excel.
#How to import contacts into outlook 2007 from excel download
Click the link that says Download Basic Contact List Template. If you are creating your own custom list you will first need to download the Basic Contact List Template. When you select Basic Contact List, you will then see a list of the Minimum Column Requirements, as well as a link to Download Basic Contact List Template. Importing contacts that were exported from any program other than Outlook 2007, Top Producer 8i, and MyRealEstate Tools.įrom the Import page, in column 1, select Basic Contact List from the Type of File drop down menu.Creating your own import file from a database that cannot be exported to Excel.The Basic Contact List file type is used when you are: Importing using the Basic Contact List File Type There are four file types that you can import: