Excel Importing Too Many Rows

  • Resolved bgerlach

    (@bgerlachllc)


    7 years, 3 months ago

    I have tried to import a small spreadsheet (35 rows and 6 columns), but it is importing a total of 974 rows.

    I know I can hide or delete the 939 empty rows, but another person is going to overwriting this table on a weekly basis and that isn’t efficient considering their workload.

    • This topic was modified 7 years, 3 months ago by bgerlach.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 3 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    The direct Excel import is still experimental and unfortunately has problems like this sometimes. I therefore recommend to save the table to a CSV file in Excel and then import that. The CSV import is much better.

    Regards,
    Tobias

    Thread Starter bgerlach

    (@bgerlachllc)

    7 years, 2 months ago

    This happens whether I use a CSV or Excel file.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 2 months ago

    Hi,

    ok, could you then please check the content of the CSV file in a text editor? If it contains the empty rows there as well, the problem is that Excel somehow saves the extra empty lines in the CSV file. Unfortunately, there’s nothing that TablePress can then do about this, as it has to import the content from the CSV file as it is (as it can’t just assume that you don’t want certain lines).

    One idea could be to copy the content part of the Excel file into a new Excel file. Sometimes, this makes Excel only save the actual content to a CSV file then.

    Regards,
    Tobias

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

The topic ‘Excel Importing Too Many Rows’ is closed to new replies.