Home > Ninjodo > People, Customers & Contacts > Export a Mailing/SMS/Address List From Ninjodo

Export a Mailing/SMS/Address List From Ninjodo

By following the steps below you can export a Mailing, SMS or Address list of your Ninjodo contacts to a spreadsheet, so you can import them into a program like MailChimp, AWeber, or iContact to do bulk emailing- or for any other needs, you may have. 

 

STEP 1

Go to "People" from the top left menu --> https://go.ninjodo.com/person

 

STEP 2

Click on "Actions" at the top right of the page

STEP 3

Choose "Export Mailing List - SMS List or Address List" from the dropdown list

STEP 4 

Select the contacts you wish to export

STEP 5

Click the "Download Now" button

You will then see a successful message at the top of the page and your csv file will be downloaded. 

Keep in mind your browsers downloading protocol to save/locate/open file (Eg. saving files to a default folder such as "Downloads" or giving you the option to save to a specific folder, etc).

 

FOR EXCEL USERS

When you open the file using Excel, if the data looks disordered, here's how to fix it.

STEP 1

Highlight the first column of the spreadsheet or simply click on the letter "A" to highlight the whole column. Then click on "Data" tab on the menu bar. Next, click on "Text to Columns".

 

STEP 2

A dialog box will appear. "Delimited" is chosen by default so you can simply click on "Next >".

 

STEP 3

On the next screen, uncheck "Tab" and make sure "Semicolon" is checked. Then click on "Next >".

 

STEP 4

On the next screen, under "Data preview", click on the date column as shown below (it will be highlighted black when you click on it). Then, click on "Text" on the column data format. Click "Finish"

 

STEP 5

The data will be separated into their own columns. Just expand the width by dragging the header. 

IMPORTANT: You need to save the file in a different format to prevent data loss. There will be a notification on the excel screen in a yellow bar. Click on "Save as" or if you do not see the notification, simply click on "File" on the menu bar and then click "Save as".

 

STEP 6

It is best to save the file as an "Excel Workbook (*.xlsx)". You can choose to either delete the previous CSV file or rename it if you will still need it for reference.

 

 

FOR LIBREOFFICE CALC USERS

When you open the file, the delimiter screen will appear. You simply need to click on "OK" and it will open the file with separated columns.

 

PRO TIP

You can use "Advanced Search" options to filter your contacts