Talk to a data advisor+1 (850) 409-6061
Home / U.S. Data Journal / Delivery
U.S. DATA JOURNAL · DELIVERY

Prepare a U.S. data file for CRM import

Protect ZIP codes, identifiers, and field meaning during CSV and spreadsheet imports.

DATA Solutions Editorial · 2 min read

Agree on a data dictionary

Before importing, define what every column contains. Distinguish company name from contact name, business phone from mobile phone, and office location from mailing address. Include allowed values for categorical fields and the meaning of blanks. A small data dictionary prevents two teams from using the same column name for different concepts.

Preserve text-like identifiers

ZIP codes, phone numbers, and record identifiers should not be treated as quantities for calculation. Use text fields where needed so leading zeroes and formatting survive. Keep a separate country field when appropriate. Establish one date format and document its meaning; a valid date can still be misleading if it refers to export rather than collection.

Map columns in a test import

Import a small set into a test area or reviewable batch before loading the full file. Check how the CRM handles blank cells, existing values, special characters, and repeated account names. Confirm whether the import creates new accounts, updates existing ones, or links contacts to accounts. Save the mapping so later batches use the same interpretation.

Reconcile the outcome

Compare source rows with created, updated, skipped, and rejected records. Investigate rejected rows instead of assuming the import completed perfectly. Preserve the delivery file, mapping notes, and import report so changes remain traceable. For a U.S. data request, specify CSV or spreadsheet delivery, required headers, and any CRM-specific constraints before the file is prepared.

PUT THE BRIEF TO WORK

Define your U.S. audience

Tell us the states, industries, and fields you need. Our team reviews availability before responding.

Explore the relevant service

Continue reading

U.S. aged leads and business data answer different questionsU.S. business data: a practical buyer’s guide
Chat on WhatsApp