This is so frustrating. I have Excel 2010 where we are editing CSV data. But when I save this CSV from Excel, Unity cannot read it as Text Asset! But if I then just load with NotePad+ and save it – then Unity can read as Text Asset.
I even took the CSV file saved from Excel and used Windows Explorer to Ctrl+C then Ctrl+V (copy/paste in place) – and it created a copy just fine – and Unity could read the COPIED file just fine. But not the original file.
We use SVN, it shows zero differences in the file for check-in. Yet somehow Unity seems to care how the file was last saved – Text Editor (works fine), but Excel 2010 fails entirely.
This is not acceptable. It’s like Unity is going out-of-its-way to do something that is very pointlessly frustrating, and even seems impossible.
Why would/should Unity care which program saved it? And why then would a Windows Explorer Copy/Paste then create a file that Unity can read just fine?