Resource Center

Browse the topics below to find out more

How to Create a CSV file

If you have an existing list of contacts in an excel spreadsheet, you can bulk import them into BulkMail. To do this, you need to save your excel spreadsheet as a CSV or ‘comma separated value’ file. When a CSV file is saved it separates the columns with a comma. This means that if you have a field such as address, it is important to make sure that there are no commas present in the column. If commas do appear in a column, it will break the column in the wrong place resulting in data not being imported correctly.

This is a quick guide on how to save your mailing list as a .CSV file.

  1. The first thing to do is open the file in your Excel program and click on the file menu.
  2. Choose the “Save as” option in this menu

how to create a csv file 01

  1. Then click on the “Save as type” option that is just under where you select the name of the file.  In this drop box will be the CSV format.

how to create a csv file 02

  1. Once you have selected that, click save.  The program will then bring up the following warnings:

how to create a csv file 03

  1. Click Yes to this warning. The file will then save.
{snippet back_overview} || Contacts

Sign up for a free trial!

Want to try out BulkMail.
The Free Account gives you 100 FREE CREDITS to test drive the application
(Limited to 20 email addresses).

Signup Our signup process

Important: Read our Anti-Spam Policy to ensure that you are complying with our send policies before you purchase credits.

About Us

It's never been easier to build your own newsletter or select and customise a free template with BulkMail email service.

Try out the best bulk email software today, create your email campaign and send bulk email.

Contact Us

Click here to send us a message.

Office hours: Mon-Thur 9h00 - 16h00 / Fri 9h00 - 13h00

Office: +27 (0)21 913 7872

21A Thor Circle
Cape Town, 7460