Every time the database is exported to a CSV the Path identifier in cell A1 is preceded by the following characters ï»¿Path. Weird characters has to be deleted in order to get a successful import from CSV.
That’s the UTF-8 Byte Order Marker. Excel, which I presume you’re using to open it, has horrible UTF-8 support, from what I read online.
But, the problem is still on our side- we require the BOM for UTF-8, when the general convention is that it should be optional. But still, it’s allowed, and most text editors won’t mind it.
I’m using Open Office Spreadsheet. Switching to Unicode UTF-8 solved the problem. Thanks