How to Create a File to Import your Subscribers List to Doppler
To import a Subscribers List you need a spreadsheet application because that’s where we create the List to upload to Doppler. Don’t worry if you don’t have one!
First of all, here you can download it for free. When creating a New Document, keep in mind that the first cells on each column will be the ones who name each field. So, in this case, our fields will be: email, firstname, lastname and position:
Doppler Tip: When writing the main field, remember to put email first, don’t use all capitals or leave spaces after typing.
Another important aspect to keep in mind is that the information you enter in each of the Custom Fields mustn’t exceed 400 characters, which is the maximum amount allowed.
Once you are done, delete all the other document sheets, leaving just the one you used to create the List.
Now will be the time for you to save the file. Basically, there are four ways to do it so Doppler can recognize it:
- As an Excel .xls or xlsx file.
- As a .csv Comma Separated Values file.
- As a .zip file.
- As a .txt file.
To convert a .xls file to a .csv, go to File – Save As and choose .csv, as shown on the picture below.
After saving you’ll see a pop-up window: choose “Yes” and there you go! Your file will be saved.
Now, to make a .txt List, please open your NotePad. Use the first row to name each field and, from the second row on, add each Subscribers information.
You’ll have to separate each field with a comma, without leaving any spaces, like this:
How do I upload my List?
Go to the app, click Lists – Create List and pick a name that would help you easily identify your Subscribers. You’ll see you have three ways to create a List: choose Import Subscribers, click Browse, select the file (.ZIP or .CSV) and hit Upload.
Make sure your file has been correctly uploaded in the file mapping, hit Import and you are done! Your List will be uploaded! If you need any help creating your Campaign, don’t miss this post!
Doppler Tip: Remember that you can tag your list so you can find your Subscriber more easily.
Have a great Campaign!