Title: CSV export has mismatch between headers and data
Last modified: February 24, 2021

---

# CSV export has mismatch between headers and data

 *  Resolved [ascdev](https://wordpress.org/support/users/ascdev/)
 * (@ascdev)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/csv-export-has-mismatch-between-headers-and-data/)
 * When I export user data, the CSV file is invalid because there is a single mismatch
   between header columns and data columns.
    All the headers and data upto column
   ~76 is correct – the header matches the data. But after this column, there is
   1 extra column in the header that does not appear in the data. Most strange. 
   A simple workaround is to manually edit the CSV file and delete the extra header
   field (it typically has not data associated with in anyway).

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

 *  Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/)
 * (@carazo)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/csv-export-has-mismatch-between-headers-and-data/#post-14107271)
 * [@ascdev](https://wordpress.org/support/users/ascdev/),
 * I have never seen this case.
 * Are you using LibreOffice Calc to open the file? Or Microsoft Excel?
 * Microsoft Excel has problems sometimes with CSV and create this kind of problems.
 *  Thread Starter [ascdev](https://wordpress.org/support/users/ascdev/)
 * (@ascdev)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/csv-export-has-mismatch-between-headers-and-data/#post-14122197)
 * OK, problem sorted.
 * The issue was caused by residual data in the database from a deleted plugin.
   
   All the redundant data now deleted and the problem has gone away.
 * For interest, the CSV file being generated contained an additional copy of “display_name”
   field in the middle of the old plugin fields. There were no corresponding fields
   in the data rows.
    I assume having duplicate column names was the issue.
 *  Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/)
 * (@carazo)
 * [5 years, 4 months ago](https://wordpress.org/support/topic/csv-export-has-mismatch-between-headers-and-data/#post-14122615)
 * [@ascdev](https://wordpress.org/support/users/ascdev/),
 * Yes, we have to fix it… this is not usual, but it can appear.
 * Thanks for your research in next release we will include 😉 to avoid this kind
   of problems.

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

The topic ‘CSV export has mismatch between headers and data’ is closed to new replies.

 * ![](https://ps.w.org/import-users-from-csv-with-meta/assets/icon-256x256.png?
   rev=1174343)
 * [Import and export users and customers](https://wordpress.org/plugins/import-users-from-csv-with-meta/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/import-users-from-csv-with-meta/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/)
 * [Active Topics](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Javier Carazo](https://wordpress.org/support/users/carazo/)
 * Last activity: [5 years, 4 months ago](https://wordpress.org/support/topic/csv-export-has-mismatch-between-headers-and-data/#post-14122615)
 * Status: resolved