Can't open csv file.

Can't open csv file.

#22396
Closed (works as designed) Opened

This is private information you're getting now. Please delete the file after you solve the problem. Ok?

I am trying to get this credit card data into Quickbooks 2011 for mac so I don't have to retype all these characters...

I get the red text failure line when your system tries to convert it - it fails rather instantly.

I tried it on Safari and on Mozilla/Firefox.

CSV*** Thu, 14 Jun 2018 - 13:49

I have update some scripts, can you please try again

CSV*** Sun, 14 Oct 2018 - 00:33

I had another look into this. 

The problem is that the CSV has multiple lines on the Memo field. That is giving the detection of the columns a hard time. I tried to use Excel to fix it as suggested here https://csvconverter.biz/blog/how-fix-csv-file-not-being-converted

But even Excel is not able to put the Memo into a single column

The only way of making the conversion work is to edit it in Excel and manually fix the multi-line issue