How to Make a CSV file for your mailing list.
Computers & Technology → Email
- Author Bill Boyd
- Published April 29, 2006
- Word count 573
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!
-
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)
-
Then name it "WHATEVERYOUWANT" and click save.
-
Now you will get a window asking a lot of questions.
-
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
-
Go to your software and find the import function, browse for your file and upload it!
-
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.
Bill Boyd; has a degree in business, he has run several successful email campaigns and found the following tool useful, so he became an affiliate: http://www.internetgoldenweb.com/groupmail/index.html
To visit his Internet marketing site go here: http://www.internetgoldenweb.com
Article source: https://articlebiz.comRate article
Article comments
There are no posted comments.
Related articles
- Proton Mail In Vivaldi Email
- Email Deployment
- Squarespace email campaigns vs Mailchimp
- Squarespace email campaigns vs Mailchimp
- Email Extractor from CSV
- How to download Gmail email content into a CSV file.
- Is email marketing legit?
- Mastering Lead Generation in 2024 Techniques to Attract More Customers
- Technology and gadgets
- Navigating the Cybersecurity Landscape: A Comprehensive Guide for Businesses
- Improving Email Deliverability: Best Practices and Tips
- Boost Your Business's Credibility with a Custom Domain Email
- 10 Benefits of Temporary Email and Why You Should be Using
- 10 Crіtісаl Rеаѕоnѕ Whу Yоur Buѕіnеѕѕ Needs Emаіl Mаrkеtіng
- Managing Your In-House Email with MDaemon Messaging Server
- How do I connect with AOL Customer Support? | +1 8885154600
- Optimize and protect your business email workflows
- 5 Quick Tips to Resolve POGO Games Not working and Sign in issue
- How to Earn Money from Email Marketing. Email Marketing for Beginners:
- How to Make Custom Personal Or Business Mail Logos?
- Best Gmail Backup Tool Review
- Powerful business email with MDaemon Messaging Server
- Email Marketing By Spoken Communication
- MDaemon Messaging Server - a business email server for Windows
- How to Reinstall AOL Desktop Gold
- Avaya Users Email List - Avaya Users Mailing Data - B2B Technology Lists
- Autodesk Users Email List - Buy AutoDesk User List - B2B Technology Lists
- Actuate Users Email List - Actuate Users Mailing List - B2B Technology Lists
- Email etiquette nightmares we could all do without
- Microsoft Outlook problems like freezing, corrupt PST, Profile, Add-in, and so forth