Title: Import CSV File
Last modified: August 22, 2016

---

# Import CSV File

 *  [sathyaki](https://wordpress.org/support/users/sathyaki/)
 * (@sathyaki)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/import-csv-file-1/)
 * Hi Iam trying to import CSV file which has the heading row in upper case like,
   FIRST_NAME, CITY etc.. when i import this its giving null values for the field
   in the participant_database_fields table i found that name Colum containing lower
   case, When convert csv file heading rowto lower case its working fine. Can you
   help me to import csv fles which can import either case coulmns ?
    what change
   i need to make ?
 * [https://wordpress.org/plugins/participants-database/](https://wordpress.org/plugins/participants-database/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [xnau webdesign](https://wordpress.org/support/users/xnau/)
 * (@xnau)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/import-csv-file-1/#post-5748808)
 * Generally, MySQL field names are case-insensitive, so I suspect what you’re really
   seeing is a spelling change.
 * If you want to change the case of your header row, it will be much easier to 
   change the case of your CSV file before you import it. You can do this either
   using a plain text editor or import the CSV into a spreadsheet app. Don’t try
   to use a word processor.

Viewing 1 replies (of 1 total)

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

 * ![](https://ps.w.org/participants-database/assets/icon-256x256.jpg?rev=1389807)
 * [Participants Database](https://wordpress.org/plugins/participants-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/participants-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/participants-database/)
 * [Active Topics](https://wordpress.org/support/plugin/participants-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/participants-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/participants-database/reviews/)

## Tags

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

 * 1 reply
 * 2 participants
 * Last reply from: [xnau webdesign](https://wordpress.org/support/users/xnau/)
 * Last activity: [11 years, 3 months ago](https://wordpress.org/support/topic/import-csv-file-1/#post-5748808)
 * Status: not resolved