Convert CSV to JSON in PHP
Today we will show you how to convert CSV to JSON in PHP. Sometimes we need to implement functionality like read data from CSV and upload it in a database at that time you have to convert CSV to JSON.
Convert a CSV to JSON with PHP, CSV to JSON conversion using PHP, Convert a CSV file into JSON using PHP, php convert csv to array, php convert file to json, php csv, wordpress csv to json, php csv import, php stream csv, csv to nested json.
Checkout more articles on PHP
To Convert csv data to json, first we need to read the CSV file. Assume that we have CSV file named products.csv and that contains below data:
1 2 3 | Product Name,SKU,Price MI,MI123,18990 OPPO,Oppo123,27860 |
Let’s start to read data from CSV and convert it into JSON.
1 2 3 4 5 6 7 8 9 10 11 12 13 | <?php $fileName = "../files/products.csv"; $file = fopen($fileName, "r"); $productData = array(); while (($data = fgetcsv($file, 0, ",")) !== FALSE) { $productData[] = $data; } echo json_encode($productData); ?> // Output: [["Product Name","SKU","Price"],["MI","MI123","18990"],["OPPO","Oppo123","27860"]] |
How It Works:
Using the fopen function, we have opened the csv file and set the second parameter r to read the file.
Using the fgetcsv function, we iterated the rows of the CSV file and added the data into the $productData array.
At last, when the loop is completed, we convert the $productData array into json using the json_encode function.
If you want to ignore the header of CSV i.e, Product Name,SKU,Price then you can do it like this.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | <?php $fileName = "../files/products.csv"; $file = fopen($fileName, "r"); $row=0; $productData = array(); while (($data = fgetcsv($file, 0, ",")) !== FALSE) { if($row > 0){ $productData[] = $data; } $row++; } echo json_encode($productData); ?> // Output: [["MI","MI123","18990"],["OPPO","Oppo123","27860"]] |
That’s it for today.
Thank you for reading. Happy Coding!
