Extra Columns when uploading

  • Resolved lonestarwebgroup

    (@lonestarwebgroup)


    7 years, 8 months ago

    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?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    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

    (@lonestarwebgroup)

    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

    (@tobiasbg)

    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.