Export Magento 1.x categories to csv

magento-export-categories-csv.php

<?php
require_once 'app/Mage.php';
Mage::app();
$allCategories = Mage::getModel ( 'catalog/category' );
$categoryTree = $allCategories->getTreeModel();
$categoryTree->load();
$categoryIds = $categoryTree->getCollection()->getAllIds ();
if ($categoryIds) {
        $outputFile = "var/export/categories.csv";
        $write = fopen($outputFile, 'w');
        foreach ( $categoryIds as $categoryId ) {
                $category = $allCategories->load($categoryId);
                $url_key = Mage::helper('catalog/category')->getCategoryUrlPath($allCategories->getUrlPath(), true);
                $path = $category->getPath();
                $data = array(
                        $categoryId,
                        $allCategories->load($categoryId)->getName(),
                        $path,
                        $url_key,
                );
                fputcsv($write, $data);
        }
}
fclose($write);
?>
~