BuddyPress.org

I suggest you install phpMyAdmin on your server (or use equivalent) – http://www.phpmyadmin.net/home_page/index.php. Then, assuming there’s at least one profile with all profile data completed, export that data/table as a CSV-formatted file.

You can then load this into Excel and can use it as a base how to build the file.

Be very careful about certain characters in your text – ‘ ” and TRUE/FALSE boolean values spring to mind. If this is beyond your current understanding, a quick Google for “mysql special characters tutorial” or similar is a good idea.