Title: CSV header & data not aligned properly
Last modified: November 23, 2022

---

# CSV header & data not aligned properly

 *  Resolved [basilj](https://wordpress.org/support/users/basilj/)
 * (@basilj)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/csv-header-data-not-aligned-properly/)
 * Hi
    On exporting the form as CSV the header and data are not in the same column.
   Blank values are being overwritten by the next value in the row.
 *  The data is pushed correctly to google sheets but the problem is not all from
   submissions are being pushed.
 * Sometime on submission the from also shows the error “A error occurred while 
   processing the form, Please try again”
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fcsv-header-data-not-aligned-properly%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Support [Nithin – WPMU DEV Support](https://wordpress.org/support/users/wpmudevsupport11/)
 * (@wpmudevsupport11)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/csv-header-data-not-aligned-properly/#post-16231044)
 * Hi [@basilj](https://wordpress.org/support/users/basilj/),
 * > On exporting the form as CSV the header and data are not in the same column.
   > Blank values are being overwritten by the next value in the row.
 * I’m afraid, this is a known bug and our Forminator team is already working on
   a fix regarding this. At the moment, there isn’t an exact ETA but hoping it would
   be soon.
 * > Sometime on submission the from also shows the error “A error occurred while
   > processing the form, Please try again”
 * Are there any steps to replicate the issue? Like you notice the error when filling
   out any specific fields?
 * Possible to share the form export so that we could give a closer look at regarding
   its settings?
 * Please check the following doc on how to export a form:
    [https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#import-export](https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#import-export)
 * If you are concerned about any sensitive information in the form, then you can
   duplicate your form, remove any sensitive information, and then export it.
 * You can share the export file via Google Drive, Dropbox or any cloud services
   in the next reply.
 * Looking forward to your response.
 * Kind Regards,
    Nithin
 *  [ctdev2023](https://wordpress.org/support/users/ctdev2023/)
 * (@ctdev2023)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/csv-header-data-not-aligned-properly/#post-16232217)
 * Hi
 * I’ve also experienced the issue of the CSV columns not lining up with the data.
 * I know why, if a field on the form is not filled in the, this causes the alignment
   issue
 * So if you fill in the fields Name and Phone, leaving the Email blank, below is
   what the CSV data will be. Because you don’t fill in the email, the data shifts
   along to the left
 *     ```
       Name  - Email         - Phone
       John  - 123654789654
       ```
   
    -  This reply was modified 3 years, 6 months ago by [ctdev2023](https://wordpress.org/support/users/ctdev2023/).
    -  This reply was modified 3 years, 6 months ago by [ctdev2023](https://wordpress.org/support/users/ctdev2023/).
    -  This reply was modified 3 years, 6 months ago by [ctdev2023](https://wordpress.org/support/users/ctdev2023/).
    -  This reply was modified 3 years, 6 months ago by [ctdev2023](https://wordpress.org/support/users/ctdev2023/).
 *  Plugin Support [Nithin – WPMU DEV Support](https://wordpress.org/support/users/wpmudevsupport11/)
 * (@wpmudevsupport11)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/csv-header-data-not-aligned-properly/#post-16234041)
 * Hi [@ctdev2023](https://wordpress.org/support/users/ctdev2023/),
 * Regarding the CSV export not lining up the data is due to a bug, as stated in
   the previous reply, which our team is already working on.
 * I also see you mention that you are getting “error occurred while processing 
   the”, which is a different issue.
 * If you think it’s something you could replicate always while submitting the form
   then please do provide the steps to replicate and also the form export as mentioned
   in my previous reply.
 * If your concern is only about CSV export, then I can confirm it’s already being
   looked at. But at the moment, I’m afraid there isn’t an exact ETA regarding the
   status of the fix.
 * Kind Regards,
    Nithin
 *  [ctdev2023](https://wordpress.org/support/users/ctdev2023/)
 * (@ctdev2023)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/csv-header-data-not-aligned-properly/#post-16237444)
 * Hi Nithin
 * I think you meant this message for [@basilj](https://wordpress.org/support/users/basilj/)
 * Clive
 *  Plugin Support [Nebu John – WPMU DEV Support](https://wordpress.org/support/users/wpmudevsupport14/)
 * (@wpmudevsupport14)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/csv-header-data-not-aligned-properly/#post-16239305)
 * Hi [@ctdev2023](https://wordpress.org/support/users/ctdev2023/) ,
 * Sorry, it seems Nithin thought your response was from basil. Yeah, the response
   was for basil.
 * Kind Regards,
    Nebu John
 *  Plugin Support [Nithin – WPMU DEV Support](https://wordpress.org/support/users/wpmudevsupport11/)
 * (@wpmudevsupport11)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/csv-header-data-not-aligned-properly/#post-16334377)
 * Hi all,
 * The issue noticed with CSV export is already fixed in v 1.22.1. Please update
   the plugin to the latest version and let us know if you need any further assistance
   regarding the issue noticed.
 * I’ll mark this thread as resolved for now. Please feel free to re-open the thread
   if you need further assistance.
 * Best Regards
   Nithin

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

The topic ‘CSV header & data not aligned properly’ is closed to new replies.

 * ![](https://ps.w.org/forminator/assets/icon-256x256.gif?rev=3443182)
 * [Forminator Forms – Contact Form, Payment Form & Custom Form Builder](https://wordpress.org/plugins/forminator/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/forminator/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/forminator/)
 * [Active Topics](https://wordpress.org/support/plugin/forminator/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/forminator/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/forminator/reviews/)

 * 6 replies
 * 4 participants
 * Last reply from: [Nithin – WPMU DEV Support](https://wordpress.org/support/users/wpmudevsupport11/)
 * Last activity: [3 years, 5 months ago](https://wordpress.org/support/topic/csv-header-data-not-aligned-properly/#post-16334377)
 * Status: resolved