Title: Problems Importing .CSV file into table Last modified: August 21, 2016 --- # Problems Importing .CSV file into table * [martong](https://wordpress.org/support/users/martong/) * (@martong) * [12 years, 11 months ago](https://wordpress.org/support/topic/problems-importing-csv-file-into-table/) * Whenever I try to import data from a CSV file it seems to identify the fields correctly and determine the number of rows in the file correctly, I match up the appropriate fields, tell it to import and it always says starting a 1: 0 of (n) entries imported and no data is added. I have cleared out the Table so it is empty….. Anyone got this working???? * [http://wordpress.org/extend/plugins/db-toolkit/](http://wordpress.org/extend/plugins/db-toolkit/) Viewing 11 replies - 1 through 11 (of 11 total) * Plugin Author [David Cramer](https://wordpress.org/support/users/desertsnowman/) * (@desertsnowman) * [12 years, 10 months ago](https://wordpress.org/support/topic/problems-importing-csv-file-into-table/#post-3945925) * See if you can change the format. switch between windows format or mac/linux. it may be a problem with line endings. * [the-beholder](https://wordpress.org/support/users/the-beholder/) * (@the-beholder) * [12 years, 9 months ago](https://wordpress.org/support/topic/problems-importing-csv-file-into-table/#post-3945965) * I too am running into issues…I’ve tried Mac, Win, DOS, Unicode…nothing seems to work. * Thread Starter [martong](https://wordpress.org/support/users/martong/) * (@martong) * [12 years, 9 months ago](https://wordpress.org/support/topic/problems-importing-csv-file-into-table/#post-3945966) * I gave up, just used PHPMyAdmin to import the data into the table I created under DB Toolkit. * Also tried the different formats using DostoUninx/UnixtoDos, no change for me. * [araun](https://wordpress.org/support/users/araun/) * (@araun) * [12 years, 8 months ago](https://wordpress.org/support/topic/problems-importing-csv-file-into-table/#post-3945970) * I’m really glad I found this powerfull plugin, but have problems with the CSV import too. It’s essential for the website I’m working on that users can import CSV-files to the tables. Any suggestions for a solution? * [Rickyx](https://wordpress.org/support/users/inlate/) * (@inlate) * [12 years, 8 months ago](https://wordpress.org/support/topic/problems-importing-csv-file-into-table/#post-3945974) * I confirm the issue. Changing encoding or line endings are not solving the problem. There is some solution or workaround? * Thanks, Rickyx * [araun](https://wordpress.org/support/users/araun/) * (@araun) * [12 years, 8 months ago](https://wordpress.org/support/topic/problems-importing-csv-file-into-table/#post-3945975) * If anyone has a suggestion of some other way to let users import CSV-files to database tables, I would be very thankful. Like, really thankful. Maybe offer my firstborn son or my collection of pokemon cards.. * [Gary](https://wordpress.org/support/users/gdmbiggar/) * (@gdmbiggar) * [12 years, 7 months ago](https://wordpress.org/support/topic/problems-importing-csv-file-into-table/#post-3945977) * I have other DB problems, but I would suggest that you add a couple of test records and then export them to see how they get formatted. Then be sure that your csv file is formatted exactly the same way. Should work. * [araun](https://wordpress.org/support/users/araun/) * (@araun) * [12 years, 7 months ago](https://wordpress.org/support/topic/problems-importing-csv-file-into-table/#post-3945978) * Gary, I have tried that, but it is still stuck at “0: 0 of X entries imported.”. Does it work for you? * [Gary](https://wordpress.org/support/users/gdmbiggar/) * (@gdmbiggar) * [12 years, 7 months ago](https://wordpress.org/support/topic/problems-importing-csv-file-into-table/#post-3945983) * sorry for the late post. I did a csv export using this plugin and found that he does not use commas for the delimiter. The fields were delimited by **_semicolons_**. Did you try that? * [araun](https://wordpress.org/support/users/araun/) * (@araun) * [12 years, 7 months ago](https://wordpress.org/support/topic/problems-importing-csv-file-into-table/#post-3945984) * Yes, it doesn’t change anything :/ There’s automatically added an ID-field when importing, could that be the issue? I’ve tried various options like leaving it blank, making a new column for ID and choosing one of the existing columns as ID, but maybe there’s something I haven’t thought of? * [gwythaint](https://wordpress.org/support/users/gwythaint/) * (@gwythaint) * [12 years, 5 months ago](https://wordpress.org/support/topic/problems-importing-csv-file-into-table/#post-3945985) * The semicolon delimiter fields could be changed to commas with this two line changes in this version of data_form/class.php * [https://github.com/gwythaint/DB-Toolkit/blob/4365e8e63ade93be65b940899ddf171aa91a4eaa/data_form/class.php](https://github.com/gwythaint/DB-Toolkit/blob/4365e8e63ade93be65b940899ddf171aa91a4eaa/data_form/class.php) Viewing 11 replies - 1 through 11 (of 11 total) The topic ‘Problems Importing .CSV file into table’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/db-toolkit_f3f3f3.svg) * [DB Toolkit](https://wordpress.org/plugins/db-toolkit/) * [Frequently Asked Questions](https://wordpress.org/plugins/db-toolkit/#faq) * [Support Threads](https://wordpress.org/support/plugin/db-toolkit/) * [Active Topics](https://wordpress.org/support/plugin/db-toolkit/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/db-toolkit/unresolved/) * [Reviews](https://wordpress.org/support/plugin/db-toolkit/reviews/) * 11 replies * 7 participants * Last reply from: [gwythaint](https://wordpress.org/support/users/gwythaint/) * Last activity: [12 years, 5 months ago](https://wordpress.org/support/topic/problems-importing-csv-file-into-table/#post-3945985) * Status: not resolved