function get_simple_membership_members_data() {

	global $wpdb; // Instantiate global $wpdb object (we'll need it later to access our WordPress database).

	$swpm_members_tbl = 'swpm_members_tbl'; // Define Simple Membership's main table.

	$file_name = 'file'; // Set the file name of your Excel or CSV file.

	// Execute SQL -- SELECT -- query members data from Simple Membership's main table -- swpm_members_tbl; it'll return a PHP object. Adjust this SQL according to your needs.
	$wp_swpm_members = $wpdb->get_results("SELECT member_id, user_name, first_name, last_name, member_since, membership_level, account_state, email, phone, company_name FROM $wpdb->prefix$swpm_members_tbl ORDER BY member_id DESC LIMIT 10", ARRAY_A );

	if( count($wp_swpm_members) > 0 ) {
	  foreach( $wp_swpm_members as $wp_swpm_member ) {

	  	// Prepare members data.
		  $member_id = $wp_swpm_member['member_id'];
		  $user_name = $wp_swpm_member['user_name'];
		  $first_name = $wp_swpm_member['first_name'];
		  $last_name = $wp_swpm_member['last_name'];
		  $member_since = $wp_swpm_member['member_since'];
		  $membership_level = $wp_swpm_member['membership_level'];
		  $account_state = $wp_swpm_member['account_state'];
		  $email = $wp_swpm_member['email'];
		  $phone = $wp_swpm_member['phone'];
		  $company_name = $wp_swpm_member['company_name'];

		  $result_arr = array();

		  // Push members data to array -- $result_arr.
		  array_push($result_arr, $member_id, $user_name, $first_name, $last_name, $member_since, $membership_level, $account_state, $email, $phone, $company_name);

		  // Members data imploded with "\t" (tab); this will be the data we'll print when we export to Excel file.
		  $result_implode_tab = implode("\t", $result_arr);
		  $xls_output .= $result_implode_tab . "\n";

		  // Members data imploded with ", " (comma); and this one we'll print when we're exporting to CSV file).
		  $result_implode_comma = implode(", ", $result_arr);
		  $csv_output .= $result_implode_comma . "\n";
		}
	}

	$file_name = $file_name . "_" . date( "Y-m-d_H-i", time() ); // Append date and time to your file name.

	// Comment these 6 lines of code if you want to export file as CSV instead of Excel.
	header( "Content-type: application/xls" ); // Set the content type for Excel files.
	header( "Content-Disposition: attachment; filename = " . $file_name. ".xls" ); // Set the content-disposition for Excel files.
	header( "Pragma: no-cache" );
	header( "Expires: 0" );
	print $xls_output; // Lastly, print the ouput.
	exit;

	// Uncomment these 5 lines of code if you want to export file as CSV instead of Excel.
	// header( "Content-type: application/vnd.ms-excel" );
	// header( "Content-disposition: csv" . date("Y-m-d" ) . ".csv" );
	// header( "Content-disposition: filename = " . $file_name. ".csv" );
	// print $csv_output;
	// exit;
}
add_action('wp_ajax_swpm_members_excel_csv', 'get_simple_membership_members_data');
// The Excel/CSV file (containing members data) will be downloaded to your computer automatically when you access the following URL in your browser: http://your-domain/wp-admin/admin-ajax.php?action=swpm_members_excel_csv.

function get_simple_membership_members_data_and_meta_data () { 

	global $wpdb; // Instantiate global $wpdb object (we'll need it later to access our WordPress database).

	$swpm_members_tbl = 'swpm_members_tbl'; // Define Simple Membership's main table.
	$swpm_form_builder_custom = 'swpm_form_builder_custom'; // Define Simple Membership's - Form Builder Addon table

	$file_name = 'file'; // Set the file name of your Excel or CSV file.

	// Execute SQL -- SELECT -- query members data from Simple Membership's main table -- swpm_members_tbl; it'll return a PHP object. Adjust this SQL according to your needs.
	$wp_swpm_members = $wpdb->get_results("SELECT member_id, user_name, first_name, last_name, member_since, membership_level, account_state, email, phone, company_name FROM $wpdb->prefix$swpm_members_tbl ORDER BY member_id DESC LIMIT 10", ARRAY_A );

	if( count($wp_swpm_members) > 0 ) {
	  foreach( $wp_swpm_members as $wp_swpm_member ) {

	  	// Prepare members data.
		  $member_id = $wp_swpm_member['member_id'];
		  $user_name = $wp_swpm_member['user_name'];
		  $first_name = $wp_swpm_member['first_name'];
		  $last_name = $wp_swpm_member['last_name'];
		  $member_since = $wp_swpm_member['member_since'];
		  $membership_level = $wp_swpm_member['membership_level'];
		  $account_state = $wp_swpm_member['account_state'];
		  $email = $wp_swpm_member['email'];
		  $phone = $wp_swpm_member['phone'];
		  $company_name = $wp_swpm_member['company_name'];

		  $result_arr = array();

		  // Push members data to array -- $result_arr.
		  array_push($result_arr, $member_id, $user_name, $first_name, $last_name, $member_since, $membership_level, $account_state, $email, $phone, $company_name);

		  // Execute another SQL -- SELECT -- now we're querying member meta data from Simple Membership - Form Builder Addon table -- swpm_form_builder_custom; PHP object will be returned.
		  $wp_swpm_member_meta = $wpdb->get_results( "SELECT field_id, user_id, value FROM $wpdb->prefix$swpm_form_builder_custom WHERE user_id = $member_id" );

		  foreach ($wp_swpm_member_meta as $obj_wp_swpm_member_meta) {
		  	$custom_field = ( !empty($obj_wp_swpm_member_meta->value) ) ? $obj_wp_swpm_member_meta->value : 'n/a';

		  	// Also push member's meta data to array -- $result_arr.
				array_push($result_arr, $custom_field);
		  }

		  // Members data imploded with "\t" (tab); this will be the data we'll print when we export to Excel file.
		  $result_implode_tab = implode("\t", $result_arr);
		  $xls_output .= $result_implode_tab . "\n";

		  // Members data imploded with ", " (comma); and this one we'll print when we're exporting to CSV file).
		  $result_implode_comma = implode(", ", $result_arr);
		  $csv_output .= $result_implode_comma . "\n";
		}
	}

	$file_name = $file_name . "_" . date( "Y-m-d_H-i", time() ); // Append date and time to your file name.

	// Comment these 6 lines of code if you want to export file as CSV instead of Excel.
	header( "Content-type: application/xls" ); // Set the content type for Excel files.
	header( "Content-Disposition: attachment; filename = " . $file_name. ".xls" ); // Set the content-disposition for Excel files.
	header( "Pragma: no-cache" );
	header( "Expires: 0" );
	print $xls_output; // Lastly, print the output.
	exit;

	// Uncomment these 5 lines of code if you want to export file as CSV instead of Excel.
	// header( "Content-type: application/vnd.ms-excel" );
	// header( "Content-disposition: csv" . date("Y-m-d" ) . ".csv" );
	// header( "Content-disposition: filename = " . $file_name. ".csv" );
	// print $csv_output;
	// exit;
}
add_action('wp_ajax_swpm_members_w_meta_excel_csv', 'get_simple_membership_members_data_and_meta_data');
// The Excel/CSV file (containing members data and meta data) will be downloaded to your computer automatically when you access the following URL in your browser: http://your-domain/wp-admin/admin-ajax.php?action=wp_ajax_swpm_members_excel_csv.