Listware for Excel:Business Coder:Input Columns

← Listware for Excel Reference

Specify the input columns you want to process by selecting them in the drop-down menus.

The following input columns are available:

Address

Company

Specify the column that contains company and/or organization names.

Address

Specify the column that contains street or PO Box addresses.

Address 2

Specify the column that contains a second address line. If available, this is generally extra addressing information such as an apartment or suite numbers.

If the information is in the "Address" column, it will be found and parsed to this column when you specify that column here.

City

Specify the column that contains cities.

State

Specify the column that contains the US state and/or Canadian province.

ZIP Code

Specify the column that contains the US ZIP code and/or Canadian Postal Code.

Country

Specify the column that contains the country name (US or Canada).

Although Business Coder can often identify an address's country of origin by looking at the address, sometimes address verification can improve if the country is provided.

Phone

Phone

Specify the column that contains phone numbers.

Web Site

URL

The web site URL of the business.

Identifiers

Stock Ticker

The assigned stock exchange abbreviation/symbol for the business.

MAK

Melissa Address Key. A unique key assigned to the address record.