The CSV file could not be openned. Please report.

The CSV file could not be openned. Please report.

#8925
Active Opened

This file was downloaded from mint.com on 12/20/2015.  I then looked at it in Excel 2011 on a mac running El Capitan.  I edited out records that I didn't want, and saved as .cvs .

Your program has been a boon in the past.  I hope that you can resolve this issue and/or suggest a workaround for the meantime.

Thanks,

Julie

jul*** Sun, 20 Dec 2015 - 18:20

I tried importing the .csv file into Excel (rather than simply opening the csv file in excel) and setting the delimiters, etc.  This did not help.  btw, I'm using a current version of Chrome as my browser.

jul*** Sun, 20 Dec 2015 - 18:33

OK, I went to the legacy site and was able to import.

jul*** Mon, 11 Jan 2016 - 12:27
CSV*** Mon, 11 Jan 2016 - 12:36

I re-saved the CSV via excell and ticked the option that adds quotes to every field

the resultin is something like this

"Date","Description","Original Description","Amount","Transaction Type","Category","Account Name","Labels","Notes"

"11/30/15","AirBnB","2888       Rental     16454",70,"credit","Rental Short-term","Savings 1611",,

 

It imported fine