How to Export Email Addresses from Xenforo without DB Access

Export Emails from Xenforo

This is a short tutorial on how to quickly export email addresses from Xenforo (forum) without having to have database access. There are a number of reasons below why you might want to do this:

  • Run Facebook ads against your Xenforo member list by creating creating a custom audience
  • Run remarketing ads against your Xenforo member list by using the new CRM Data Onboarding feature in a 3rd party retargeting tool such as AdRoll
  • Maybe you are migrating your forum and you need to import your email list into another email marketing platform such as MailChimp or Aweber

Maybe you have a new product your launching, why not target your already existing forum members?

Step 1

First login to the backend of your Xenforo forum, click on the “Users” tab and click into “Email Users.”

xenforo email users

Step 2

Select “Only generate a list of email addresses” and scroll down and click on “Continue.”

only generate email addresses

Step 3

You will then have to copy the email addresses to your clipboard. Right click and copy.

copy emails

Step 4

Now launch Microsoft Excel and paste the contents into column A.

paste into excel

Step 5

We now need to separate the columns. So select column A and in the “Data” tab click on “Text to Columns.”

convert text to columns

Step 6

Select “Delimited” and click “Next.”


Step 7

Make sure “Tab” and “Space” are selected and then click “Finish”

delimiters tab space

Step 8

You now have a 3 column email list. You can now save this as a CSV file and then import into a custom Facebook audience or into AdRoll’s CRM retargeting.

3 column email list

As always feel free to leave your comments below! If you have a Xenforo forum make sure to also check out my tutorial on how to properly insert the Facebook Conversion Pixel into your Xenforo install.

Get More Stuff Like This

Marketing, WordPress, Blogging Tips, SEO and Reviews, once a week.

Thank you for subscribing.

Something went wrong.

Leave a Comment