Description. Similar to fgets () except that fgetcsv () parses the line it reads for fields in CSV format and returns an array containing the fields read. The locale settings are taken into account by this function. If LC_CTYPE is e.g. en_US.UTF-8, files in one-byte encodings may be read wrongly by this function. I'm trying to upload a TAB Delimited .csv to PHP, and it spews out special characters between each word. It seems to work fine when uploading a real, "comma" delimited .csv file, but with "tab" delimited it spews out all theses unreadable characters between each word? Why is is messing up so much when I insert a tab delimited CSV, I can't I would go back to the person that the contract is for and get an example of the data format they desire, rather than an inaccurate description. If they continue to require ".CSV tab delimited", you could provide the data twice as .CSV and Text (Tab Delimited) and say that you read the contract as ".CSV (and) tab delimited", since the original Locate and select your file, then click "Import". 4. Step 1 of wizard - choose "Delimited" and click "Next>". 5. Step 2 of wizard - choose "Tab" as the delimiter and click "Next>". 6. Step 3 of wizard - set column types as required (if necessary) and click "Finish". 7. confirm where you want the data in the worksheet. PHP & Software Architecture Projects for $0 - $5. I just need to import a text file with phpmyadmin that use tab delimited in a database. look the structure of my table in the attachment and try to insert all data in my table and send me the .sq csv_to_multi_array.php This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Go to File > Open. In the Files of type: drop-down menu, choose Text Files (*.prn; *.txt; *.csv) Select the file and click Open. Excel 2007: Select the Data tab. In the Get External Data group, select From Text. Once the Import Text File dialog box appears, choose the file and click Open. In the Text Import Wizard - Step 1 of 3 dialog, choose before converting it into CSV file, relace these commas into another character (the one in the original text didn't exist). For example: "\u0022. Step 1: Step 2: Step 3: Please have a try, I hope it can help you. Best Regards, Community Support Team _ Lin Tu. Load a Tab Delimited File into Neo4j Neo4j is a popular graph database which provides an easy way to import text files using the Cypher query language and a LOAD CSV clause. LOAD CSV by default expects files to be delimited by commas. In order to specify another field delimiter, add FIELDTERMINATOR to the LOAD CSV clause. For example: