English
日本の
PCVITA software to move Excel contacts into Outlook PST files
Excel to Outlook Address Book Tool
PCVITA Excel to Outlook Address Book Converter imports contacts from XLSX, XLS and CSV sheets into a new PST file, an existing PST file or your configured Outlook profile. Auto Map or manual mapping places names, phone numbers and email addresses in the right Outlook fields. Export to vCard, CSV, PDF, TXT or HTML as well. Free demo converts 10 contacts per Excel file and the full edition has no contact limit.
- Input
- XLSX, XLS, CSV, XLSM and XLSB sheets
- Destination
- PST file or Outlook profile
- Mapping
- Matched by Auto Map or by hand
- Also exports
- Five more file formats
Also loads several Excel files in one go and converts contacts that have no email address. See all features. Need only VCF files? Open the Excel to VCF Converter. Mac users can get the Mac edition.
How PCVITA Software Moves Excel Contacts Into Outlook
Your Excel contact sheet goes in first. PST files, Outlook profiles and other contact formats come out with the mapped fields in place.
Excel Contact Sheet
One file or many in a single job
- XLSX, XLS, CSV, XLSM and XLSB files
- Several Excel files added together
- Contacts shown in a preview first
PCVITA Excel Contacts Converter
Works on your Windows machine
- Auto Map or manual mapping
- Mapping saved and loaded later
- Empty email addresses allowed
Outlook Contacts and More
Six output formats, led by PST
- New PST or existing PST file
- Outlook profile you configured
- Five more file formats
- 1AddBrowse to your Excel file and preview the contacts.
- 2MapSelect PST, set the destination and map the fields.
- 3ExportClick Export and read the result count.
Import Excel Contacts to Outlook in 6 Steps
Six screens take you from the first click to saved contacts. Select a step tab to view its screen. The Software Guide holds the full walkthrough.
Step 1. Open the Software
Install the converter on Windows. Open Start, go to All Programs and launch the Excel contacts converter.
Step 2. Browse for the Excel File
Click Browse and select the Excel file. PCVITA software scans the file after you add it.
Step 3. Preview the Excel Contacts
When the scan ends, the Excel File Preview section lists your contacts. Read the rows and columns before you export.
Step 4. Select PST and Apply Setting
Select the PST radio button under Export Option. Under Apply Setting, choose Create New PST, Existing PST or MS Outlook Profile. Outlook must be configured for the profile option. Browse for the destination and tick Allow Empty Email Address to be Imported if you need those contacts.
Step 5. Map the Excel Fields
In the mapping window, select an Excel field and an export file field, then click Add. Select Auto Map to match the columns for you. Save the mapping and load it later for the next sheet.
Step 6. Export and Check the Result
Click Export. A message announces the end of the job. Yes shows the success and fail count. Open the destination to see your contacts.
Free demo, no licence needed. Every file converts its first 10 contacts.
Excel to Outlook Contact Import Features
What PCVITA software does with an Excel contact sheet, grouped by task.
Adds and Previews Your Excel Contact Sheets
Conversion starts with one click on Browse. Preview shows your contacts before anything is saved.
Add One File or Many
Add File(s) loads a single Excel file or several from your local storage in one go.
Ten Excel File Types
XLSX, XLS, CSV, XLA, XLAM, XLSB, XLSM, XLT, XLTX and XLTM files all load into the converter.
Preview After the Scan
Excel File Preview lists the scanned contacts, so you check rows and columns first.
No Contact Count Limit
Full edition sets no contact count limit, so a long sheet converts in one batch.
Microsoft Excel Not Needed
Excel contacts convert without Microsoft Excel installed on the machine.
Imports Contacts Into PST Files and Outlook Profiles
PST is the first export option. Three settings decide where your contacts land.
Create New PST
Save the contacts in a fresh PST file that you open in Outlook later.
Existing PST
Add the contacts to a PST file you already use.
MS Outlook Profile
Send contacts to the Contacts folder of a configured Outlook profile. Outlook must be configured for this option.
Contacts Without Email
Tick the checkbox to import contacts that have a name and phone number but no email address.
Choose the Destination
Browse for the folder that holds the PST file and the other output files.
Maps Excel Columns to Outlook Fields
Mapping decides which Excel column lands in which contact field.
Auto Map in One Click
Auto Map matches the Excel columns with the export file fields for you.
Manual Mapping
Select an Excel field and an export file field, press Add and include or exclude the columns you need.
More Than 8 Contact Fields
Map names, several phone numbers and custom contact fields, however many numbers one person has.
Save and Load Mappings
Save a mapping once and load it for the next Excel sheet with the same columns.
Exports Excel Contacts to Five More Formats
Your sheet also saves in five other formats when Outlook is not the target.
vCard 2.1, 3.0 and 4.0
Select the vCard version you need and create a single vCard file for all contacts. Version 4.0 is the latest and iCloud supports it.
Standard CSV or Google CSV
Standard CSV needs no mapping. Google CSV needs mapping and suits an import into a Google account.
One PDF for All Contacts
Tick the option to create a single PDF file that holds every contact.
TXT and HTML Files
Both formats follow the same steps as PST, vCard, CSV and PDF.
Success and Fail Count
Click Yes after the export to see how many contacts passed and how many failed.
See these options on your own sheet. Free demo handles 10 contacts from every file.
What Outlook Asks of Your Excel Contact Sheet
Four points from Microsoft on importing Excel contacts into classic Outlook plus the way PCVITA software answers them.
- 1
Outlook Reads CSV Files Only
Microsoft states that Outlook imports comma separated value (.csv) files and cannot import workbooks with multiple sheets. PCVITA software loads the Excel file itself, in ten file types.
- 2
Save As CSV Brings Warnings
Excel shows warnings when you save a sheet as CSV (Comma delimited). Microsoft says the warnings reflect CSV limits. PCVITA software skips the Save As step and previews your contacts as they are.
- 3
Semicolons Break Some Imports
Microsoft notes that locales like German save CSV files with semicolons. Outlook does not support a semicolon as a field separator. Excel contacts converter reads your sheet directly, so no separator needs fixing.
- 4
Mapping Happens by Hand
Microsoft has you drag columns onto Outlook fields in Map Custom Fields. PCVITA mapping window adds Auto Map, manual mapping and a saved mapping you load for the next sheet.
Get Your Excel Contacts Ready Before You Convert
Six checks before the first job. Work down the list, then open the converter.
- Keep a copy of your Excel file and give the columns clear headings like name, phone and email.
- Install Microsoft .NET Framework 4.5 or above on a Windows machine with 100 MB free disk space.
- Open the converter with Run as Administrator on Windows 10, 8.1, 8, 7 or Windows Server.
- Configure Outlook first if you plan to use the MS Outlook Profile option.
- Decide about contacts without an email address and tick the empty email checkbox when you want them.
- Test the free demo on your sheet before you buy. Download the converter demo and test the first 10 contacts of a file.
Windows and hardware lines follow the Specifications table below.
Excel Contacts Converter Pricing
Free demo first, then one licence. Every option works in both editions and only the contact count differs.
Demo Edition
Free
Convert 10 contacts per Excel file
- Contact limit10 per Excel file
- FeaturesAll
- LicenceNot needed
Version 3.0, 10.6 MB, Windows
Full Edition
$39 one licence
Convert unlimited contacts in every Excel file you add
- Contact limitNone
- FeaturesAll
- DeliveryEmail within 15 minutes
30 Days Money Back*, Safe & Secure checkout
Included in both editions Demo and full edition carry the same options with a different contact count
- Load Several Excel Files Together
- Preview Before You Export
- Auto Map and Manual Mapping
- Save and Load Mappings
- Three PST Destination Settings
- Contacts Without Email Addresses
- Five Extra Export Formats
- Export Result Summary
Excel to Outlook Converter Specifications
Version, system needs and file support in one place.
| Version | 3.0 (Windows) |
|---|---|
| File size | 10.6 MB |
| Windows versions | Windows 10, 8.1, 8 and 7, Windows Server 2008, 2012 R2 and 2016 |
| Prerequisite | Microsoft .NET Framework 4.5 or above |
| Hardware | Intel Core 2 Duo E4600 at 2.40 GHz, 4 GB RAM recommended, 100 MB free hard disk space |
| Free demo limit | 10 contacts per file in every export option |
| Delivery | Email within 15 minutes after payment confirmation |
| Mac edition | Version 3.2 for Mac OS X 10.8 to 10.15 with Java JDK 1.8.0 and JRE 8. Download the Mac edition |
| Input files | XLSX, XLS, CSV, XLA, XLAM, XLSB, XLSM, XLT, XLTX and XLTM |
|---|---|
| Output formats | PST, vCard, CSV, PDF, TXT and HTML |
| PST settings | Create New PST, Existing PST and MS Outlook Profile |
| vCard versions | 2.1, 3.0 and 4.0, with a single vCard file option |
| CSV settings | Standard CSV without mapping, Google CSV with mapping |
| Outlook versions | Outlook 2019, 2016, 2013 and lower versions |
| Contact limit | None in the full edition |
| Microsoft Excel | Not needed on the machine |
PCVITA Software vs the Outlook CSV Import Wizard
Microsoft’s own route next to PCVITA converter, so you can decide which one fits your sheet.
| Point | Outlook CSV Import | PCVITA Converter |
|---|---|---|
| Accepted file | CSV files, not workbooks with multiple sheets | Ten Excel file types, several files at once |
| Before the import | Save the sheet as CSV (Comma delimited) and accept warnings | Add the Excel file and preview it |
| Separators | Semicolons are not supported as a field separator | No delimiter file involved |
| Field mapping | Drag columns in Map Custom Fields | Auto Map, hand mapping and saved maps |
| Destination | A folder in your Outlook data, Contacts by default | PST file or Outlook profile |
| Other formats | Imports into Outlook only | Five more formats besides PST |
| Price | Included with Outlook | Free demo, full edition $39 |
Outlook import facts come from Import contacts from an Excel spreadsheet to classic Outlook (Microsoft Support). Converter details come from the Features and Specifications sections.
Outlook CSV Import Steps From Microsoft
- Open the worksheet with your contacts and select File, then Save As.
- Set Save as type to CSV (Comma delimited) and click Save. Click OK and Yes on the warnings.
- In Outlook, select File, Open & Export and Import/Export, then Import from another program or file.
- Choose Comma Separated Values, browse to the CSV file and select how Outlook treats duplicates.
- Select the Contacts folder, click Map Custom Fields, drag the columns onto Outlook fields and click Finish.
PCVITA converter skips the Save As step. Open the Software Guide for the PST screens.
Sources for Excel to Outlook Import Facts Microsoft page behind the import points on this page
- Microsoft SupportImport contacts from an Excel spreadsheet to classic Outlook
Questions on Importing Excel Contacts to Outlook
Answers to what users ask before and during a conversion, grouped by topic.
Working and limits How the converter behaves during the job
How do I move Excel contacts into Outlook with the converter?
Six steps move your contacts.
- Step 1. Open PCVITA software from the Start menu.
- Step 2. Click Browse and add the Excel file.
- Step 3. Preview the contacts in the Excel File Preview section.
- Step 4. Select PST, choose Create New PST, Existing PST or MS Outlook Profile and browse for the destination.
- Step 5. Map the fields with Auto Map or by hand.
- Step 6. Click Export and select Yes to see the success and fail count.
Can I add Excel contacts to an existing PST file?
Yes. Select the PST option, choose Existing PST under Apply Setting and browse to your file. PCVITA software adds the Excel contacts to that PST without creating a new one.
Can the converter send Excel contacts straight to my Outlook profile?
Yes. Choose MS Outlook Profile under Apply Setting. Outlook must be configured on the machine for this option. Contacts land in the Contacts folder of the profile.
Is there a limit on the number of Excel contacts?
No. Full edition sets no contact count limit, so a long sheet converts in one batch. Free demo stops at 10 contacts per file.
Do I need Microsoft Excel installed to convert the sheet?
No. PCVITA Excel contacts converter reads the file without Microsoft Excel on the machine. Add the XLSX, XLS or CSV file and the preview opens.
Can I leave out Excel columns and reuse my mapping?
Yes. Manual mapping lets you include or exclude columns before you click Add. Save the mapping and load it when the next sheet has the same columns. Auto Map matches the columns for you instead.
Can I import contacts that have no email address?
Yes. Tick the empty email checkbox before you export. Contacts with a name and phone number but no email address then convert with the rest.
Demo and price What the demo covers and what a licence costs
What does the free demo of the Excel contacts converter do?
Demo edition converts the first 10 contacts of every file. Demo edition loads your files, previews the contacts, maps the fields and exports in all six formats. Full edition removes the 10 contact limit.
What does the full edition cost?
$39. One licence converts unlimited contacts and comes with a 30 day money back guarantee. Your activation details arrive by email within 15 minutes of payment confirmation.
Does the Mac edition have the same demo limit?
Yes. Free demo stops at 10 contacts per file on both Windows and Mac. Mac edition is a separate download, version 3.2, linked in the Specifications table.
Compatibility and formats Excel, Windows and Outlook versions, output formats and Mac
Which Excel file types does the converter accept?
Ten types. PCVITA software loads XLSX, XLS, CSV, XLA, XLAM, XLSB, XLSM, XLT, XLTX and XLTM files. Add several files in one go with the Add File(s) option.
Which Windows versions can I install the converter on?
Windows 10, 8.1, 8 and 7, plus Windows Server 2008, 2012 R2 and 2016. PCVITA software needs Microsoft .NET Framework 4.5 or above, 100 MB free disk space and 4 GB RAM recommended. Launch it with Run as Administrator.
Which Outlook versions receive the Excel contacts?
Outlook 2019, 2016, 2013 and lower versions. PCVITA software exports Excel contacts to those releases. MS Outlook Profile works once Outlook is configured.
Which output formats can I choose besides PST?
Five formats. They are vCard, CSV, PDF, TXT and HTML. vCard comes in versions 2.1, 3.0 and 4.0. Version 4.0 is the one iCloud supports. CSV comes as Standard CSV or Google CSV for an import into a Google account.
Is there a Mac edition of the converter?
Yes. Mac edition 3.2 works on Mac OS X 10.8 to 10.15 with Java JDK 1.8.0 and JRE 8. Download it separately from the Windows version.
Question not answered here? Ask on Live Chat or write to us from the Contact Us page.
Excel to Outlook Contacts Converter Reviews
Ratings collected on pcvita.com and what customers wrote after moving their contacts.
When I tried to Export Excel to Outlook Address Book manually, it was not easy at all. Moreover, many of the Excel contacts did not get transferred. Then my friend suggested me to use this Excel data file to Outlook PST converter application. This tool migrated each and every contact of that Excel file in Outlook profile, and that too in a very short time. I am grateful to its developers.
I have seen a lot of tools until now and when I came around the Excel Converter tool, I found out that there is not even a single tool that is as easy-to-understand as this one. This software has a good amount of features for its users to make the conversion process easy. It is can immediately convert all the contacts to Outlook PST format without losing any data.
I had around 20,000 or more contacts stored in an XLS file which I had to move to my Outlook Contacts List. Now, I tried almost every solution for this but not even one helped me out. Then I found Excel to Outlook Address Book converter which helped me perform this task without going through any troubles. Thanks a lot to this tool for helping me do my work quickly.
GearDownload: 100% clean badge, no spyware, adware or viruses found in PCVITA software.
DownloadAtoZ: 5 star award badge for PCVITA software. See every badge on the PCVITA awards page.
Key Takeaways on Excel Contact Imports
The short version of this page.
- Files and versions. PCVITA software loads ten Excel file types and saves contacts for Outlook 2019, 2016, 2013 and lower versions.
- Three PST routes. Create a new PST, add to an existing PST or send contacts to a configured Outlook profile.
- Mapping. Auto Map or hand mapping puts every column in the right field. Saved mappings serve the next sheet.
- Six formats. One sheet saves as PST, HTML, TXT, PDF, CSV or vCard.
- Demo and price. Free demo stops at 10 contacts per file. Full edition costs $39 with 30 days money back.
Import Your Excel Contacts to Outlook With a Free Demo
Download the demo, preview your sheet, map the fields and test the first 10 contacts of a file.
Safe & Secure · 30 Days Money Back*
