If you Have Product Name and get product details for import product csv use this. Create php file and put code

require_once '../app/Mage.php';
$row = 1;
echo '<table>';
if (($handle = fopen("Yourcsvname.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $num = count($data);
        //echo "<p> $num fields in line $row: <br /></p>\n";
        for ($c=0; $c < $num; $c++) {
            echo '<tr>';
                                                echo '<td>'.$data[$c]. "</td>";
                                                $product_collection = Mage::getResourceModel('catalog/product_collection')
                                                foreach ($product_collection as $product) {
                                                                echo '<td>'.$product->getSku() . "</td>";
                                                echo '</tr>';
echo '</table>';

  After this same location put your CSV File. In csv File your product Name must be compulsory and save this. You Get your csv product all Details.