OttaPen

Resources · Tutorials

Importing contacts in bulk without breaking your list

June 24, 2026 · 5 min read

Tutorial cover — spreadsheet

Field mapping, deduplication and the CSV formatting rules that keep an import clean.

Format the file

Use UTF-8 encoding and keep one recipient per row. Merge cells and multi-line addresses in a single column are the two most common import failures.

Map the fields

Map every column explicitly rather than accepting automatic detection — automatic mapping tends to guess wrong on second address lines.

Run a test batch

Send ten cards to internal addresses first. It costs almost nothing and catches everything.

Get started

Send oneand see.

A single card costs less than lunch and settles the argument faster than any case study.