Forum Discussion
CSV Downloads Not Working
Since yesterday (September 18, 2017), my financial report downloads (CSV files) have not worked properly. Opening the downloaded file results in all the data appearing in a single cell (A1), in "mum...
Yes, that's not an Excel issue, it looks like the routine which export csv file doesn't perform HTML/XML decoding.
If take beginning of your file
Category%2CSymbol%2CDescription%2CAccount%2CQuantity%2CValue%2CMarket
the HTML entity for "%" is "%", if substitute it the string will be like
Category%2CSymbol%2CDescription%2CAccount%2CQuantity%2CValue%2CMarket
and %2C is the HEX code for the comma. Finally it shall be
Category,Symbol,Description,Account,Quantity,Value,Market
So, if the report is decoded correctly you'll have no problems with Excel.