Creating a Custom Memberships Report

Go to Memberships > Reports

You can select Options and select relevant to the report information you require such as Email or even Custom Fields.

Results can be exported as a CSV and even print as a PDF.