Title: Export Query to csv – fputcsv
Last modified: August 22, 2016

---

# Export Query to csv – fputcsv

 *  Resolved [nepf](https://wordpress.org/support/users/nepf/)
 * (@nepf)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/export-query-to-csv-fputcsv/)
 * I whould like to export a query with the_title() and some get_post_meta() to 
   a csv-file.
    I think fputcsv() is the rigth PHP-function, but i have no idea 
   how to put this into the loop. Has anyone helpful hints for me? Thank you.

Viewing 1 replies (of 1 total)

 *  Thread Starter [nepf](https://wordpress.org/support/users/nepf/)
 * (@nepf)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/export-query-to-csv-fputcsv/#post-5481484)
 * solved it by my own.
    Maybe it’s helpfull for someone
 *     ```
       <?php $fh = fopen( 'wp-content/uploads/export.csv', 'w'); ?>
       <?php $person = array(); ?>
   
       	<?php while ( have_posts() ) : the_post(); ?>
       		<?php
       			$name = get_post_meta($post->ID, 'nepf_name', true);
       			$adress = get_post_meta($post->ID, 'nepf_adress', true);
       			$hobby = get_post_meta($post->ID, 'nepf_hobby', true);
   
       			$person[] = array($name, $adress, $hobby);
       		?>
       	<?php endwhile; ?>
   
       <?php
       foreach($person AS $dataset) { fputcsv($fh, $dataset, ';'); }
       fclose($fh);
       ?>
       ```
   

Viewing 1 replies (of 1 total)

The topic ‘Export Query to csv – fputcsv’ is closed to new replies.

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [export](https://wordpress.org/support/topic-tag/export/)

 * In: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/)
 * 1 reply
 * 1 participant
 * Last reply from: [nepf](https://wordpress.org/support/users/nepf/)
 * Last activity: [11 years, 8 months ago](https://wordpress.org/support/topic/export-query-to-csv-fputcsv/#post-5481484)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics