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
First login to the backend of your Xenforo forum, click on the “Users” tab and click into “Email Users.”
Select “Only generate a list of email addresses” and scroll down and click on “Continue.”
You will then have to copy the email addresses to your clipboard. Right click and copy.
Now launch Microsoft Excel and paste the contents into column A.
We now need to separate the columns. So select column A and in the “Data” tab click on “Text to Columns.”
Select “Delimited” and click “Next.”
Make sure “Tab” and “Space” are selected and then click “Finish”
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.
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.