How to import csv file in PHP?

Question

I am very new to web development. In fact, I am just starting to learn.

Can somebody please give a complete but very simple example on how to import CSV file in PHP? I tried the one I got from the internet but I'm very confused because it's complicated for me. I am using the WAMP server with PHP 5.3.5, Apache 2.2.17, and MySQL 5.5.8. Please help.

I tried to paste the code but it's messy. Honestly, I am also very new to StackOverflow.

Can you amend your question to include as much of the error as you're comfortable with? It is much easier to troubleshoot that way. — Tieson T., Apr 28 '11 at 03:12
See example on the doc page for [fgetcsv()](http://php.net/fgetcsv). Hope that helps. — Wiseguy, Apr 28 '11 at 03:14

score 73 · Accepted Answer · answered Apr 28 '11 at 03:14

73

From the PHP manual:

<?php
$row = 1;
if (($handle = fopen("test.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $num = count($data);
        echo "<p> $num fields in line $row: <br /></p>\n";
        $row++;
        for ($c=0; $c < $num; $c++) {
            echo $data[$c] . "<br />\n";
        }
    }
    fclose($handle);
}
?>

answered Apr 28 '11 at 03:14

coreyward

77,547
20
137
166

1

Simple. Precise. Thank you. – test Apr 08 '13 at 04:36
Thank you! Very simple to use! How do I ammend this to save the items in the csv into an array? – heinkasner Jun 12 '14 at 13:03

score 17 · Answer 2 · answered Mar 25 '15 at 16:06

17

I know that this has been asked more than three years ago. But the answer accepted is not extremely useful.

The following code is more useful.

<?php
$File = 'loginevents.csv';

$arrResult  = array();
$handle     = fopen($File, "r");
if(empty($handle) === false) {
    while(($data = fgetcsv($handle, 1000, ",")) !== FALSE){
        $arrResult[] = $data;
    }
    fclose($handle);
}
print_r($arrResult);
?>

answered Mar 25 '15 at 16:06

Alex

1,223
1
19
31

1

In what way is it not useful? Seems to me like it works. – greggles Sep 30 '15 at 14:22
1

I meant that a working example as provided is always more useful than just a point in the right direction. If available of course and correctly written. – Alex Sep 30 '15 at 14:46

score 15 · Answer 3 · answered Jun 19 '16 at 14:17

15

The simplest way I know ( str_getcsv ), it will import a CSV file into an array.

$csv = array_map('str_getcsv', file('data.csv'));

answered Jun 19 '16 at 14:17

Danijel

12,408
5
38
54

As noted in the linked comment, "that does not produce the desired results, if fields contain linebreaks." – Chandler Swift Feb 24 '21 at 00:02

score 6 · Answer 4 · answered Apr 28 '11 at 03:13

6

PHP > 5.3 use fgetcsv() or str_getcsv(). Couldn't be simpler.

answered Apr 28 '11 at 03:13

Jason McCreary

71,546
23
135
174

7

Could be waaaaaaaaaay easier. Why not a function that takes a CSV string/filename and returns an array or exception? Jeepers why do i have to loop and parse. What is this, the 90s – Jonathan Jan 10 '17 at 02:51
1

@Jonathan Streaming is far more efficient than loading an entire 40GB CSV file into memory before operating on it. – coreyward Jun 19 '19 at 15:13

score 2 · Answer 5 · answered Jul 22 '17 at 16:32

Here is the version to extract the specific columns by name (modified from @coreyward):

$row = 0;
$headers = [];
$filepath = "input.csv";
if (($handle = fopen($filepath, "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        if (++$row == 1) {
          $headers = array_flip($data); // Get the column names from the header.
          continue;
        } else {
          $col1 = $data[$headers['Col1Name']]; // Read row by the column name.
          $col2 = $data[$headers['Col2Name']];
          print "Row $row: $col1, $col2\n";
        }
    }
    fclose($handle);
}

score 1 · Answer 6 · answered Oct 31 '15 at 09:41

1

If you use composer, you can try CsvFileLoader

answered Oct 31 '15 at 09:41

luchaninov

6,792
6
60
75

score 1 · Answer 7 · answered Feb 11 '16 at 08:11

$row = 1;
    $arrResult  = array();
    if (($handle = fopen("ifsc_code.csv", "r")) !== FALSE) {
        while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
            $num = count($data);
            DB::table('banks')->insert(
                array('bank_name' => $data[1], 'ifsc' => $data[2], 'micr' => $data[3], 'branch_name' => $data[4],'address' => $data[5], 'contact' => $data[6], 'city' => $data[7],'district' => $data[8],'state' => $data[9])
            );
        }
        fclose($handle);
    }

score 0 · Answer 8 · edited Feb 07 '13 at 06:37

   $filename=mktime().'_'.$_FILES['import']['name'];

      $path='common/csv/'.$filename;

    if(move_uploaded_file($_FILES['import']['tmp_name'],$path))
{

if(mysql_query("load data local infile '".$path."' INTO TABLE tbl_customer FIELDS TERMINATED BY ',' enclosed by '\"' LINES TERMINATED BY '\n' IGNORE 1 LINES (`location`, `maildropdate`,`contact_number`,`first_name`,`mname`,`lastname`,`suffix`,`address`,`city`,`state`,`zip`)"))

    {
      echo "imported successfully";

}

echo "<br>"."Uploaded Successfully".$path;

}

look here for futher info

How to import csv file in PHP?

8 Answers8

Linked