When working with data like ZIP codes, account numbers, or IDs, it's common to run into issues with leading zeros being removed during import. To ensure these values are preserved, you’ll want to prepare your spreadsheet using the steps below.

How It Works

Excel and other spreadsheet tools often interpret numeric data in ways that drop leading zeros. For instance, a ZIP code like “01234” may automatically be converted to “1234” if not properly formatted. To prevent this, you should treat the data as text before importing.

Step-by-Step Instructions

1. Open your spreadsheet in Excel (or another compatible spreadsheet tool).
2. Select the relevant column(s) and change the format to Text:
   • Right-click the column > Format Cells > Text.
3. Manually re-enter values if the zeros have already been removed, or copy-paste them from an original source with the correct formatting.
4. Save the file as a CSV (Comma-Separated Values) format.
5. Import the CSV into your Delivra account as you normally would.
6. Map the column to a Text field during the import step (e.g., Text1_ or another available text field).
7. Verify your import by checking a few contact records to confirm the leading zeros were retained.

Tips for Success

• Avoid formatting the column as "Number"—this will strip the zeros.
• If working with long numeric codes (like 16-digit IDs), text formatting also helps avoid scientific notation.
• Consider renaming the column header to something like “ZIP_Code_Text” to indicate special handling.