|
Formatting Guidelines
While we can convert almost any data format, we can process your list faster and more economically if you provide your file(s) in Excel, Comma Delimited, Tab Delimited or Fixed Length Fields.
Below are some examples of efficient file layouts.
Spreadsheets:
If your data is in a spreadsheet, please be sure each type of data has a unique field such as:
Name |
Title |
Company |
Address |
Address1 |
Address2 |
City |
State |
Zip |
Ann Smith |
President |
ABC Graphics |
123 Main St |
Suite 456 |
|
Chicago |
IL |
60606 |
Jim Jones |
Manager |
DEF Logistics |
852 Second Ave |
Room 7 |
Graystone Bldg |
Chicago |
IL |
60606 |
If your spreadsheet has a layout similar to the one below, please be sure that each record has the same number of fields, leaving a blank datafield where there is no data for that specific record, otherwise conversion becomes a more time consuming and costly process.
NAME
TITLE
COMPANY
ADDRESS_1
ADDRESS_2
CITY
STATE
ZIP
Databases: (MSWorks or MSAccess)
MSWorks: SAVE AS: text and commas
MSAccess: EXPORT ... Save as Excel
|
