OA Desktop Apps Guide Miscellaneous Microsoft Office Customization Error Accelerator Merge Documents Spawn Microsoft 'Trust Center' Error Manage Your Office Accelerator Billing Information Download the Latest Version How to Export Contacts from Gmail Exporting Contacts From Other Sources Login Recovery Accelerator Outlook Sync VSTO Error Fix Accelerator Multiple Instance Auto-Login Web Proxy Fix Accelerator & WebRoot Secure Anywhere Responsive Emails for Mobile Devices Installing the Accelerator Menu into WordPerfect Adding All Contacts to the My Phone Book Folder Find Contacts with Same Company (Phone Book)Remote Session Importing Data to Accelerator From an Excel Spreadsheet Touch Screen Mode How to Manually Add the CIT Tool Bar to Windows 8 Startup Office Accelerator Firewall Information Accelerator Email Editor Buttons Not Responding Copying Accelerator Macro Suite Documents to Another PC AOL and Yahoo Policies Rocket Office Accelerator API OA External Web Site Form Capture Terms and Conditions

Importing Data to Accelerator From an Excel Spreadsheet

The Office Accelerator Import Utility provides the tools necessary to import Excel spreadsheets. For instructions on how to use this utility, please follow the directions below.

Importing data can sometimes be a tricky process. If you're having trouble with an import, we can help. Please email us for assistance at support@oamobile.com or contact support at 310-793-0879.

Open the spreadsheet in Microsoft Excel that you would like to import to Accelerator.
The first row of your spreadsheet should contain the header information that describes the content within each column. This information is used to map the fields from the Excel spreadsheet to the equivalent fields in Office Accelerator.

If your spreadsheet does not have a row containing header information, you can add one by right clicking the first row in the spreadsheet and selecting |Insert|Entire Row|. Doing so will add an empty row above your data columns where you can add header descriptions to each column of data.
From your Excel spreadsheet, select |File|Save As|, then click the browse button.
Select a destination folder for the file, give it a name, and change the 'Save As Type' to |Tab Delimited|, then click the |Save| button.

Don't forget the directory where you saved your file, you'll need to browse for the file below.
If you're prompted with the following message, click |Yes| then close Excel.
From the Office Accelerator phone book, select the |Tools| menu and click the |Import Contacts| option.
To select the Excel file you saved, click the |Browse| button and navigate to the location of the file on your hard drive. Highlight the file and click the |Open| button. Click the |Next| button to continue.
The |Import Fields| dialog box provides a list of your import file fields on the left side, and a list of Office Accelerator fields on the right. Begin by selecting your 'file type' from the drop down list, then map the fields on the right side to those on the left.

Checking the box entitled 'Do not import the first record in the file' will skip the header record. This is usually desirable as importing the header record will create a contact with only header record information.

You can save time on your next import by saving your import mappings. Click the |Save| button and enter a descriptive name for your mappings, then click |OK|.
Use the |Import Preview| screen to verify the mappings in your import file are correctly mapped to your Accelerator fields. Click the |Next| button to continue.
Review the summary screen, then click the |Start Import| button.
Click |Yes| to begin the import.