Zoomcrank
Level 1

is a csv file saved as OpenOffice Calc able to be imported into QB online

I have 8 years worth of Invoices that I wish to import into QB (both for value for money reasons and accountancy reasons) and I have arranged them into files not exceeding 100 invoices. I don't have Excel but do have (not boasting here,) OpenOffice Calc on my desktop. I don't wish to own Excel unless it's absolutely unavoidable. Each Invoice has a paragraph or two describing the parts and labour aspect of the job, full name and address and email details and the invoices have been exported to my desktop from the Invoice2Go platform. I have been meticulous on the spreadsheets which I've edited through Zoho Spreadsheets, then downloaded each batch of 100 invoices to my desktop which then gets recognised as the only spreadsheet software I have- an OpenOffice Calc document. Can't say I'm filled with confidence about this, as I get the impression that Open Office is somewhat sub standard. Absolutely everything, despite many adjustments to the spreadsheets, keeps failing on QB...

 

I am wondering why I am the only person on the planet to voice such obvious concerns. I don't see any evidence of similar issues through Google searches.... Any help would be gratefully received. But I'm weirdly suspicious that there actually isn't a resolve to any of this.