Unable to import invoices CSV, get error about emply lines

[WDUK]

Hi,

I’m new here and am just trialling QF but cannot upload my CSV of invoices.

There are 86 rows in the Excel file but I keep getting an error that tells me subsequent rows have missing data. Which is because they are empty anyway.

Any way round this?

Thank you

[WDUK]

I forgot to say that I did try a forum search before posting

[rhc]

Hi,
Could you try to open your csv file in Excel or openoffice or similar, delete the empty rows and try uploading again

[WDUK]

Thank you but I’d already tried that and it didn’t work.

[ian_roberts]

Sometimes what Excel thinks is the “last” cell on the sheet can be beyond what looks like the last cell with data in it, for example if subsequent rows still have some custom formatting applied. This article suggests a way to clear up any cases like this so that the “last” row is the one you expect.

[WDUK]

Thank you very much for your help but I need something to work easily. I’ve chosen Zoho Books after trialling both