How to collect user email adresses (elegantly)

Does anyone know how to export the user email adresses? Maybe an sql data request or is there an internal system function i can use. Inside the user admin section the email adresses are partly shortened. I had tried to copy paste the information into an excel data sheet. That was not elegant ;). 

Run the following query in your phpmyadmin then save the result in a spreadsheet :

SELECT `Email` FROM `Profiles`;

Thank you very much. Worked perfectly. Is this the list of still active users, or are in this list also the emails from users who have already deleted themselves?

The query retrieves all Profiles regardless of Status. To extract only active members, use query below :

SELECT `Email` FROM `Profiles` WHERE `Status` = 'Active';