Title: Columns do not match
Last modified: September 1, 2016

---

# Columns do not match

 *  [andr2](https://wordpress.org/support/users/andr2/)
 * (@andr2)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/columns-do-not-match/)
 * Trying to import CSV with 3 simple text fields without success.
    The error is
   below …
 * * Columns do not match.
    * The number of columns in the database for this table
   does not match the number of columns attempting to be imported from the .csv 
   file. * Please verify the number of columns attempting to be imported in the “
   Select Input File” exactly matches the number of columns displayed in the “Table
   Preview”.
 * I’ve tried several delimeters “,”, “;” and space. All the data is in “”. I
 * Please, advise what is wrong?
 * [https://wordpress.org/plugins/wp-csv-to-database/](https://wordpress.org/plugins/wp-csv-to-database/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Support [mbrsolution](https://wordpress.org/support/users/mbrsolution/)
 * (@mbrsolution)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/columns-do-not-match/#post-7540721)
 * Hi, the error is letting you know that there is an incompatibility between the
   column structure of the CSV file and your database. Have you tried to import 
   just one field as a test?
 *  Thread Starter [andr2](https://wordpress.org/support/users/andr2/)
 * (@andr2)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/columns-do-not-match/#post-7540762)
 * I found a problem. The plugin doesn’t work if the name of the field is numeric(
   ex. “1”, “2”). Please, check (MySQL supports such fields).
 * Also I tried the plugin with the table which has about 54 fields – the preview
   doesn’t work.
 *  Plugin Support [mbrsolution](https://wordpress.org/support/users/mbrsolution/)
 * (@mbrsolution)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/columns-do-not-match/#post-7540772)
 * Thank you for reporting back. The plugin developers will investigate further 
   your issue.
 * Regards

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Columns do not match’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-csv-to-database_f1b072.svg)
 * [WP CSV to Database - Insert CSV file content into WordPress database](https://wordpress.org/plugins/wp-csv-to-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-csv-to-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-csv-to-database/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-csv-to-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-csv-to-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-csv-to-database/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [mbrsolution](https://wordpress.org/support/users/mbrsolution/)
 * Last activity: [9 years, 11 months ago](https://wordpress.org/support/topic/columns-do-not-match/#post-7540772)
 * Status: not resolved