How to Import Addresses From CSV Into Mailbook

Mailbook

If your addresses are already sitting in a spreadsheet, copying them manually into an address book is usually wasted effort. CSV import is the faster way to move an existing list into Mailbook so you can keep using those contacts later.

A CSV import is not just about saving time once. It is about turning an old spreadsheet into a contact list you can actually keep using. That matters if you want your address data to stay useful for future announcements, holiday mail, or personal correspondence.

These details are ready

[Recipient name]

[Street and house number]

[POSTAL CODE] [City]

Netherlands

The preview below shows what you can do after contacts are ready. The CSV step happens before this, inside your address-book flow.

So your letter looks

[Recipient name]

[Street and house number]

[POSTAL CODE] [City]

Netherlands

Dear [name], I wanted to get in touch and make sure your address is ready for future mailings as well. Kind regards, [Your name]
Open Mailbook

When this is useful

  • • When you already have addresses in Excel, Google Sheets, or Numbers.
  • • When you are moving from a one-off spreadsheet into a reusable address book.
  • • When you want to prepare a contact list before a mailing or announcement.
  • • When typing contacts manually would take too long.

Before you continue

  • • CSV import works best when every column is clear and every address row is complete.
  • • Clean up duplicate rows, broken header names, and empty contact records before you upload.
  • • If you are moving from a spreadsheet, keep country, postal code, and house number details as separate fields where possible.
  • • Review imported contacts once they are in Mailbook so you can catch formatting issues early.

How it works

1Prepare your spreadsheet with clear column headers and complete contact rows.

2Upload the CSV into Mailbook and let the address book import your contacts.

3Review the imported contacts so you can catch duplicates or formatting issues.

4Use the saved contacts later for letters, postcards, or future address requests.

Frequently asked questions

Why import addresses from CSV into Mailbook?

CSV is useful when your addresses already live in a spreadsheet and you want to turn them into reusable contacts instead of copying them one by one.

What should a good CSV file include?

Use clear headers and complete address rows. That usually means name, street details, postal code, city, and country where relevant.

Should I still review contacts after importing?

Yes. It is smart to review imported contacts afterwards, because spreadsheet formatting can still create small issues in names or address fields.

When should I use CSV import instead of a shareable link?

CSV import is usually the best option when you already have a list. A shareable link is better when you still need other people to submit their own details.

Ready to continue?

Open Mailbook to collect, import, and manage your contacts first. From there, you can start a letter or postcard whenever you are ready.