Formatting Field Collection data with Views Data Export (CSV)
The solution is to implement a views_pre_render hook in a custom module.

function mymodule_views_pre_render(&amp;$view) {
    if ($view-&gt;name == 'myview') {
        foreach ($view-&gt;result as $key =&gt; $row) {
            $line = array();
            foreach ($view-&gt;result[$key]-&gt;field_field_fruit_collection as $n =&gt; $collection) {
                $item = current($collection['rendered']['entity']['field_collection_item']);
                $line[] = $item['field_fruit'][0]['#markup'] .  ' (' . $item['field_color'][0]['#markup'] . ')';
                unset($view-&gt;result[$key]-&gt;field_field_fruit_collection[$n]);
            }
            $view-&gt;result[$key]-&gt;field_field_fruit_collection[0]['rendered']['#markup'] = implode(', ', $line);
        }
    }
}


In this example, the collection field is field_fruit_collection which is made up of two fields: field_fruit and field_color. The contents of the exported collection field will look like :

"Apple (red), Banana (yellow), Kiwi (green)"