Title: Extra Columns when uploading
Last modified: June 30, 2017

---

# Extra Columns when uploading

 *  Resolved [lonestarwebgroup](https://wordpress.org/support/users/lonestarwebgroup/)
 * (@lonestarwebgroup)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/extra-columns-when-uploading/)
 * When I upload a larger than average table (5000+ rows), it adds an extra column(
   sometimes 2) at the end of the table.
 * I know I can use the table manipulation section to delete these columns, but 
   it times out before all of the rows load and i can get to the bottom to click
   the button on the column I would like to delete.
 * If I was able to select the column from the TOP of the table, the problem would
   be solved. Is this a possibility? Or do you have another suggestion?
    -  This topic was modified 8 years, 11 months ago by [lonestarwebgroup](https://wordpress.org/support/users/lonestarwebgroup/).

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

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/extra-columns-when-uploading/#post-9278448)
 * Hi,
 * thanks for your question, and sorry for the trouble.
 * What input format are you using here? I have seen this happen with XLSX and XLS
   before (as those for some reason sometimes let TablePress think that there’s 
   data in that extra column).
    Can you maybe try with a CSV file after saving the
   table to a CSV file in Excel? This should usually not result in extra columns
   being added.
 * Regards,
    Tobias
 *  Thread Starter [lonestarwebgroup](https://wordpress.org/support/users/lonestarwebgroup/)
 * (@lonestarwebgroup)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/extra-columns-when-uploading/#post-9278457)
 * Thanks for the speedy response!
 * I have uploaded it as a CSV just now and it still added one extra column. :/
 * Any other ideas?
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/extra-columns-when-uploading/#post-9278515)
 * Hi,
 * in that case, it might be worth checking if that column really is completely 
   empty.
    Can you maybe select all cells in that column in Excel and delete the
   contents and reset the formatting? Or can you maybe select all content cells 
   and copy/paste them into a new Excel file. After that, the saved CSV file should
   not contain the extra column and should import without one.
 * Regards,
    Tobias

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

The topic ‘Extra Columns when uploading’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [8 years, 11 months ago](https://wordpress.org/support/topic/extra-columns-when-uploading/#post-9278515)
 * Status: resolved