Title: Import CSV
Last modified: September 1, 2016

---

# Import CSV

 *  [michielangello](https://wordpress.org/support/users/michielangello/)
 * (@michielangello)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/import-csv-14/)
 * Hello,
 * I’m trying to import data into my databse through CSV file however I get always
   that message:
 * “The number of importing data does not match the number of the specified column.
   Please specify the column to match the import data again.”
 * Would you have a template of CSV data import?
 * I’ve tried exporting, copy structure and then importing, but it doesn’t work.
 * Thanks in advance and best regards.
 * [https://wordpress.org/plugins/custom-database-tables/](https://wordpress.org/plugins/custom-database-tables/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [ka2](https://wordpress.org/support/users/ka2/)
 * (@ka2)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/import-csv-14/#post-7524506)
 * Thank you for your inquiry.
 * I think maybe such error has occurred by different the number of columns because
   there is contained the comma in the string data that you want to import.
    That
   matter will resolve likely if you make the appropriate escape.
 * For example,
 * Inappropriate CSV file:
 *     ```
       ID,name,gender,age,user_id,profile,created
       ,Firstname Lastname,male,20,1,If in the string data that contains the comma, you should make the appropriate escape.,2016/6/25 0:00
       ```
   
 * Note: The first line of the CSV is the index of the column name
 * Specifies to the setting of “Prepend Indices Line” in the same column name order
   as the first line of the CSV when you import.
 * Then it will occur error after you import.
 * The reason is as follows:
 * The candidate of importing column: 7 columns
    | ID | name | gender | age | user_id
   | profile | created |
 * The actual column of data: 8 columns
    | | Firstname Lastname | male | 20 | 1 
   | If in the string data that contains the comma | you should make the appropriate
   escape. | 2016/6/25 0:00 |
 * Exactly it the number of the column does not match.
 * In order to import correctly at this example, we should change the data of CSV
   in the following.
 * Properly escaped CSV file:
 *     ```
       ID,name,gender,age,user_id,profile,created
       ,Firstname Lastname,male,20,1,"If in the string data that contains the comma, you should make the appropriate escape.",2016/6/25 0:00
       ```
   
 * Please wrap at quote of strings that contains the comma.
 * Thank you,

Viewing 1 replies (of 1 total)

The topic ‘Import CSV’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/custom-database-tables_e4e2e2.svg)
 * [Custom DataBase Tables](https://wordpress.org/plugins/custom-database-tables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/custom-database-tables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/custom-database-tables/)
 * [Active Topics](https://wordpress.org/support/plugin/custom-database-tables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/custom-database-tables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/custom-database-tables/reviews/)

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)

 * 1 reply
 * 2 participants
 * Last reply from: [ka2](https://wordpress.org/support/users/ka2/)
 * Last activity: [9 years, 10 months ago](https://wordpress.org/support/topic/import-csv-14/#post-7524506)
 * Status: not resolved