How can I retain a leading zero in my CSV file?

How can I retain a leading zero in my CSV file?

DESCRIPTION

Retaining leading zeros in an excel file can be tricky.  We suggest you format this data as a custom text field, instead of numeric in your spreadsheet.


HOW-TO

  1. Open your spreadsheet as Excel format
  2. Save the cells as Text Format so that the leading zero sticks
  3. Save the file as a CSV format
  4. Import the CSV into your account
  5. Map the column in question to an available Text field (example, Text1_)
  6. Check Contact records to verify 0 was retained

    • Related Articles

    • Should I remove duplicates from my CSV file before import?

      This article will take you through removing duplicates from your CSV file BEFORE you import contacts to your account. This process is not necessary in most cases as Delivra will overwrite duplicate addresses on import. See more here. How-To Open the ...

    • How do I save my Outlook distribution list as a CSV file?

      DESCRIPTION: This article details how to save your Microsoft Outlook distribution list as a CSV file to import to Delivra. HOW-TO: Open one of the distribution lists. Save as "text only". Open your newly saved .txt file and copy the info into a new ...

    • How do I setup default mapping for imported CSV files?

      The Import Files and Field Mappings feature allows you to set rules for how your contact’s data files are imported into your account. Setting up an Import File will simplify your upload process if you plan to use the same CSV file format to add or ...

    • Import your contact lists

      Preparing your file Before we cover the process, let's talk about file preparation. The following are a few tips for a smooth import experience. Utilize a spreadsheet application to easily view and edit your data file. Organize each point of data ...

    • I imported my CSV into the wrong account, what can I do?

      DESCRIPTION This article is meant for multi-account users who mistakenly imported a CSV of new or updated contacts into the wrong account. If you find you've mistakenly imported a CSV file into the wrong list, please contact Delivra Support ...