- BlogWell - http://blog-well.com -
Exporting your FeedBurner Subscriber List to Excel
Posted By Mad On September 4, 2008 @ 9:08 pm In Resources for Sites | 5 Comments
One of the nice things about FeedBurner [1] is that it allows people to receive your feed updates via e-mail [2].
FeedBurner lets you see the e-mail addresses of your subscribers, and even allows you to download them to your computer, so you can count them, graph them, as is your want. However, it’s not as easy as it should be.
This post is a step by step guide to exporting the e-mail addresses of your subscribers to Microsoft Excel [3] – just remember, don’t abuse the privilege of having access to people’s e-mail addresses. If you spam them, they may unsubscribe.
Select the feed which you want to view the e-mail subscription for.
We will use our “My Feed” feed – the names have been changed to protect the innocent.
Select “See more about your subscribers”.
Within the “Email Subscriptions Services” section select “FeedBurner Email Subscriptions”.
Select “Manage Your Email Subscribers List”
Select “Excel” as the export type. If you don’t have an application which can read Excel XLS files, then you can download the subscriber list as a text file in CSV ( Comma Separated Values [4]) format.
Save the file to your computer now rather than later from within the application used to view the file.
Yep, we use Firefox, as do most of the people who read our blog.
Browse to the folder you wish to save the file to.
Wait for the file to be downloaded – should be quick. If your file is considerably large then congratulations, you must have lots of subscribers.
Open the file downloaded. Either double click the entry, hit Enter, or right click and select Open.
The data can now be viewed and manipulated within Excel.
if you want to sort the data, so that all the Active e-mail subscribers are at the top for example, then make sure you are within any of the data cells, select Data – Sort and then select “Status” as the first column to sort by.
Remember, don’t abuse the privilege of having access to your subscriber’s e-mail addresses.
Article printed from BlogWell: http://blog-well.com
URL to article: http://blog-well.com/2008/09/04/exporting-your-feedburner-subscriber-list-to-excel/
URLs in this post:
[1] FeedBurner: http://feedbruner.com
[2] receive your feed updates via e-mail: http://www.feedburner.com/fb/a/publishers/fbemail
[3] Microsoft Excel: http://office.microsoft.com/excel
[4] Comma Separated Values: http://en.wikipedia.org/wiki/Comma-separated_values
Click here to print.
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 Unported License.