Web Design Forum: Converting XLS Columns into Email Distribution Lists - Web Design Forum

Jump to content

View New Content

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

Converting XLS Columns into Email Distribution Lists A useful script (hopefully)

#1 TomCash

Dedicated Member

Group: Members
Posts: 192
Joined: 15-March 09
Reputation: 30
Gender:Male
Location:Wolverhampton, England
Experience:Web Guru
Area of Expertise:Web Developer

Posted 22 September 2011 - 12:50 PM

I've recently been working with the marketing team at work and we've been processing hundreds of thousands of emails from excel files generated by our database. The staff here used excel to clean out duplicates, etc, then wanted them back into a neat CSV.

So I wrote a little script for them...

http://xls-to-csv.tomcash.co.uk/

Not only does this columns into CSV but it strips out bad email addresses too!!

Feel free to have a play.

I'm very open to all types of feedback on how to improve it, etc. So please, send over your feedback!

Tom.

#2 rallport

Web Guru

Group: Members
Posts: 3,816
Joined: 03-January 10
Reputation: 266
Gender:Male
Location:England, UK
Experience:Advanced
Area of Expertise:Web Developer

Posted 29 September 2011 - 09:26 PM

Sorry to be a negative one, but is "script" really needed here?

Apart from validating email addresses, this can all be done in MS Excel right out of the box, not sure why you need a "script" to do this.

The webpage you've created is nice though, if a little convoluted for a such a simple task