How to Export Customers to Excel in Magento

Ah hah!

According to the Apache error log:

PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 84 bytes) in /Zend/Db/Statement/Pdo.php on line 290

So apparently Magento needs over 256MB of memory to export customers. OK the store in question has about 20,000 customers but that still sounds like quite a lot. Plus, this even happens when I filter down to a single surname. My guess is it's not about the size of the generated file (which needn't be held in memory all at once anyway) but that Magento is doing something grossly inefficient at the processing stage (surely not!)

I increased PHP's memory_limit to 512M and problem solved.

I hope this helps some poor wretch in future...

Finally i got solution. This is my final code:

<?php
  require_once("app/Mage.php");
  Mage::app();
  Mage::app()->getStore()->setId(Mage_Core_Model_App::ADMIN_STORE_ID);
  $orders = Mage::getModel('sales/order')->getCollection();
  $orders->addAttributeToFilter('grand_total', array('gt' => '0.00'));
  $orders->addAttributeToFilter('status', Mage_Sales_Model_Order::STATE_COMPLETE);
  $fp = fopen('file.csv', 'w');
  foreach($orders as $order) {
     $countryCode = $order->getBillingAddress()->getCountryId();
     $country = Mage::getModel('directory/country')->loadByCode($countryCode);
     $countryName = $country->getName();
     $fields = array($order->getId(), $order->getBillingAddress()->getFirstname(),$order->getBillingAddress()->getLastname(), $order->getBillingAddress()->getEmail(), $order->getBillingAddress()->getCity(),  $order->getBillingAddress()->getTelephone(), $countryName, $order->getStatus());
     fputcsv($fp, $fields);
  }
?>

Please try this, Its working for me