---
title: "How to import csv file in php?"  
description: "How to import csv file in php?"  
author: "Pravesh Singh"  
published: 2012-03-12  
updated: 2012-06-14  
canonical: https://www.mindstick.com/forum/393/how-to-import-csv-file-in-php  
category: "php"  
tags: ["php"]  
reading_time: 1 minute  

---

# How to import csv file in php?

Hello Guys,\
I want to [import csv](https://www.mindstick.com/forum/397/how-to-import-csv-file-data-in-sql-server-table) [file](https://www.mindstick.com/articles/59/encrypting-and-decrypting-files-using-c-sharp) in [php](https://www.mindstick.com/articles/12149/php-constant-and-php-variables) but I don't have and idea because I'm naive [user](https://www.mindstick.com/articles/13001/multi-statement-table-valued-user-defined-function-in-sql-server) for php. So please help me and paste [your code](https://www.mindstick.com/forum/157976/how-can-you-use-jquery-s-testing-framework-such-as-qunit-to-write-unit-tests-for-your-code) snippets too.\
\

## Replies

### Reply by Vaidotas Dazzas

\
\
Using this [CSV](https://www.mindstick.com/blog/257/write-data-in-excel-csv-and-xml-file-using-c-sharp) Import script You can import data into MYSQL then echo in php.

### Reply by Anonymous User

Hi Pravesh,\
To [import](https://www.mindstick.com/blog/294/how-to-import-or-export-sql-server-table-data-in-ms-excel-sheet-using-c-sharp-code) [csv file](https://www.mindstick.com/forum/159298/write-a-node-js-script-to-read-data-from-a-csv-file-and-store-it-in-a-mongodb-database) data, you can use array to store data of file line by line. Check this [code](https://yourviews.mindstick.com/view/85458/alan-turing-the-mastermind-behind-cracking-the-enigma-code-during-world-war-ii) snippets...\

```
<?php $arrResult = array();$arrLines = file('MyCSVFile.csv');foreach($arrLines as $line) {$arrResult[] = explode( ',', $line);}?>
```

\
It might be helpful for you.


---

Original Source: https://www.mindstick.com/forum/393/how-to-import-csv-file-in-php

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.