I have an Excel spreadsheet consisting of one header row and three data rows.  Every time I do an import, it processes 24 rows.  How do I stop this?

Hi Sara,

It sounds like you've got some ghost rows in your data file. If you open it and highlight rows 5 to 25, right click, then delete you should be good to go.

Thanks,

John

Hi,

 

I also have this problem - 66 rows. I've tried 'deleting' the blank rows and have even created a brand new profile to use, but I'm always stuck on 66 rows no matter what!

 

Is there another fix for this?

 

Katie 

The best way to fix this is to select only your data and copy it to a new Excel workbook and save that.