...

New customer addresses can also be created while updating existing customer addresses. To do this, enter the customer address details to the end of the template.

 Due to the limitations of Excel, when users enter hyphens or forward slashes into a text field, Excel may interpret the value as a date. For example, the value “2-3” may be converted to the text representation date value, which displays as ”43864”. Similarly, when users enter leading zeros into a field, the leading zero may be removed. Users can now use the escape characters of “^^” to preface any values with hyphens, forward slashes or leading zeros. During the file import process, NorthScope will recognize the escape characters, automatically remove them and insert the value immediately following the escape characters.

Step 3: Saving the Template File

...