Import from CSV

  • Resolved skirridsystems

    (@skirridsystems)


    6 years, 2 months ago

    Hi Tobias,
    This is not really a new topic as it’s been reported before, but here goes. When a table is exported from Excel as CSV, sometimes Excel includes hundreds of empty columns and rows. I had one of my users report this to me. He sent me his Excel sheet and when I did the export, the same thing happened. The only work around I could find was to select all columns to the right and delete them. Clearly it’s Excel being stupid, but I wondered whether TablePress could clean up files on import by deleting empty rows and columns. Or at least rows at the bottom and columns on the right. Is that something that could be achieved easily?
    Thanks,
    Simon

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 years, 2 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    Yes, this is an annoying problem in Excel and I have no idea why they do it like that.

    I could probably add something to “clean up” the imported tables, by deleting empty rows/columns, but I’d rather not do that, simply because it would be “guess work”. TablePress simply can not know whether this might be intentional or not (very often, it’s not, but we can’t be sure).

    Regards,
    Tobias

Viewing 1 replies (of 1 total)

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