How to Make a CSV file for your mailing list

First lets look at WHAT it is, and Why would we want to make one?

CSV means Comma Separated Value, so that means; a 'value' that is separated by commas. It is usually made in XL or a txt file.

A 'value' is explained, in context below.

CSV files are the most common kind of format used by most software programs for importing data. This means that if we want to put several hundred names and addresses (values) into a "bulk mailing program" we can usually use a CSV file.

The CSV file would have to have all the names and addresses in it, and then we could go to our software program and use the 'import' function to upload all the names and addresses (values), with one click instead of spending hours entering each one by hand.

But, how do we get the names and addresses into the CSV file in the first place? It depends where they come from, if we are simply extracting the names and addresses (Values) from one program to another we can often choose to 'export' to a file in CSV format. If we have a list of 'values' that is, say, in Microsoft word, or some other kind of document, we would first need to copy and paste them into an XL document.

Once all the 'values' we want to use, are pasted into the XL document, WITH EACH VALUE IN A SEPARATE COLUMN. We can then save the XL document as a CSV file, and then upload it into our software. Easy!

Before we continue please note: It is often necessary to have these values in our CSV file in a particular order for example; some software, will require Column 'A' to have the 'Name' and column 'B' might have to be the 'eMail' or vise versa and etc…. So it's a good idea to check first.

Some software allows us to choose where each 'value' will be loaded to, so in this case, the initial order in our CSV file won't matter, because in the upload process we may be prompted to select which 'fields to place which 'values' into.

Now, how to turn a XL document into a CSV file!
1. In your XL document with the info you wish to upload. Go to "file/save as" then select the option "as file type" and scroll down to "CSV (Comma Delimited)
2. Then name it "WHATEVERYOUWANT" and click save.
3. Now you will get a window asking a lot of questions.
4. Answer "OK" or "YES", then you'll get about two or three more windows one after the other. Answer each one "OK" or "YES", until it is done then close the workbook. You'll get more windows again. just answer "OK" and "YES" until it closes
5. Go to your software and find the import function, browse for your file and upload it!
6. Then check your "mailing List" to see the results!
Your CSV file will look like this a, if you saved it correctly!

If it doesn't work for you, make sure it is in this format.

You may find that you need to play around with this a bit, but as long as you finish with an XL document in CSV format, you should be able to upload to just about any program. Of course this isn't limited to email lists you can use this format for a range of different applications.



Top 6 Email Marketing Services

We have provided below a list of the 6 best email marketing companies on the web that small businesses can use to create the best email marketing compaigns and newsletters. The top email marketing services listed below provides some of the best email marketing tools such as quality templates, autoresponders and more. The 6 best email marketing services are:

1. GetResponse

2. ConstantContact
Emails for Small Business with Constant Contact
3. Aweber

4. Campaigner

5. Benchmark

6. Mailigen

 

Articles - News
 


Free Email Marketing Tips

On this website has been provided lots of email marketing tips. Here you will find current tips on all aspect of email marketing . The articles provided here has also been submitted to Ezinearticles.com . Reading these articles you will learn why you should do email marketing, how to do email marketing effectively, you will learn how to start your own opt in list, how to create an effective email marketing campaign, how to use autoresponders effectively, how to get better email open rates and lots more. Click any of the link below to start reading the article.

8 Advantages Of Using An Email Marketing Software
Using Advertising in Email Marketing
All about Email Marketing
Can You Really Use Articles To Build Your List?
AutoResponders Explained
How To Use Autoresponders To Increase Your Sales
How Do Autoresponders Work?
The Significance and Benefits of Email Marketing
3 Quick And Easy Ways To Build A Profitable Opt In List
Don't Make This Idiotic Mistake-Build Your List
Building a Power List of Subscribers to Earn Money Online Over and Over Again
How Your Business Can Benefit from Email Marketing
Is Email Marketing Right For Your Business?
Can You Really Use Articles To Build Your List?
Combining Email Marketing with Other Types of Marketing
How To Create Compelling E-mail Offers That Sell Like Crazy
The Right Content for Your Email Marketing
Copywriting in Your Email Campaign
Costly Email Mistakes
Creating Email Lists for Marketing Campaigns
4 Crucial Things You Need To Do To Build your List
How to Make a CSV file for your mailing list.
How Deliverability is damaged ?
Designing for Different Types of Email Audiences
Advertise, Do not Spam
How To Build A List Of Eager Subscribers
Top 5 Tips For Effective Email Marketing
Effective Email Marketing
How I Use Email Automatic Responders
The Biggest Email Brand Killers
Email Marketing Basics
Organizing Your Email Marketing Campaign
Email Marketing With E-Newsletters
When Email Marketing Does Not Work
When Email Marketing Is Not Enough
Is Your Email Marketing Spam?
Email Marketing
Is Your Email Marketing Working?
How to Optimize Email Opt-In Pages
The Importance of Email and Product Development
How To Create 2 Super-Profitable Email Publications
Doubling Promotional Email Revenue and Ecommerce
First Steps You Have to Do When You Email to New Subscribers to Earn Trust & Be Respected
When to End Your Email Marketing Campaign
Engaging the Newsletter Readers
Evaluating Your Email Marketing
How to Expand Your Email Program
Email and Fax Broadcasting
Future of Email Deliverability
Get Going With Email Marketing And Keep More Customers
How To Grab Your Readers Attention With Your Subject
What Is So Great About An Email Follow Up?
Guidelines for Growing the Opt-In List
Getting Help with Your Email Marketing Campaign
How To Build A Huge Opt In List Of Hungry Subscribers
How To Create Compelling E-mail Offers That Sell Like Crazy
How To Market Affiliate Programs With Your Newsletter
How to write an effective email
Does Everyone Ignore Your Newsletter?
The Importance Of An Email List For Your Online Business And How To Create One
Are Autoresponders really that important to internet marketing?
Introduction to Autoresponders
Generating leads with your autoresponder
Understanding List Fatigue and List Churn
Email Marketing Tips - How To Start Your Own Opt In List
The Truth About Mailing List Advertising
Email Marketing Mistakes
Email Marketing Strategies
Marketing via E-mail for Search Engines
Marketing Effectively With Email
Monitor Feedback to Boost Deliverability
Word Of Mouth Marketing Stemming From Email Marketing
Auto Responders:- Do I Need One?
Email Marketing: design tips to improve your open rates.
Opt-In Email and eZine Advertising still more effective than RSS, Blogs, and PPC!
Optimizing Holiday Email Marketing
Building Email List Based on Permission
Permission is Not Optional in Email Marketing
5 Things To Consider When Publishing A Newsletter Reaching Your Target Audience When Email Marketing
The Reaction to Your Email Marketing
Tips on Reducing Number of Email Bounces
Good Reasons To Send Email Cards Instead
Email Marketing For Your Small Business - Selecting The Right Server
Tips for staying in constant contact with your clients - Effective opt-in forms
Strategies for Email Marketing
Designing Strong Direct Mail Letters
How Subject Lines Resembling Spam Hinder Deliverability
Subject Lines: What You Shouldn't Do
How To Get Your Subscribers Begging For More
How to Make the Subscription Process Easier
Subtle Email Marketing
4 ways to achieve online success with email autoresponders
Successful HTML email marketing campaigns and Lotus Notes issues
Testing Emails Effectively
Introducing the Power of Autoresponders
The 3 Things To Avoid When Emailing Your List
The 3 Most Important Things You Must Do to Keep Your Opt-in List
6 Profitable Ways To Use Autoresponders
Tracking your emails with Campaigner.com
4 Ways To Get Your Opt In Subscribers To Trust You Quickly
Understanding Email Marketing
Getting More Out of Unsubscribing Option
7 Ways To Make Money Using Nothing More Than Your List
Design an email newsletter for Viral Marketing
What is email marketing ?
3 Reasons Why You Should Love Unsubscribes
Why do email marketing?
Write Emails Marketing Messages That Capture Your Audience
Tips of Writing Good Subject Lines for Emails
Making the Year End Email Marketing Review

 


Free Web Hosting