Then I can upload back into my UTF-8 MySQL database, if required. Click on Trust Center in the options panel, then click on Trust Center Settings. Open in BBEdit and change the format to UTF-8 (generally ‘No BOM’). Follow these steps to get rid of cannot create file or unable to open any attachments in Outlook error: Open Microsoft Word. Select “Save as UTF-16 Unicode Text (.txt)” Apple has released El Capitan and if you are thinking about running the latest version of Office 2016 for OS X, you need to be aware of performance issues. There is no step 3 (as the ad used to say).įor the reverse process I cannot do the normal “Save as tab delimited text” as the Greek letters will be replaced by underscores.
Launch Excel 2016 and import the text file (as delimited text - I use the pipes from the MySQL tables as delimiters). Set the BBEdit text document as Unicode (UTF-8, with BOM)† using the selection options at the bottom of the page. Having read the answer from the following allows me to preserve the UTF-8: After making an SQL query I often paste from my Mac terminal into the BBEdit text editor, do some minor clean up, and then import into Excel for distribution and presentation. I work with a UTF-8 MySQL database which contains one field with UTF-8 text because of Greek symbols. I have been using Word 2016 for Mac since it was in beta, and it's never had this level of instability. 1 minute after launching no matter the context, no matter the activity. However I am posting it in case anyone else finds it useful or is able to adapt it to their problem. I use primarily Word 2016 for Mac and not the other apps in the Office suite, but Word 2016 for Mac is unusable-it crashes after ca.
#Excel for mac 2016 crashing license#
Hence it may not be of general applicability. Works on: Mac License type: Lifetime Devices: 1 Unlock insights and tell the story in your data See your data in new, intuitive ways Powerful charts, graphs, and keyboard shortcuts turn columns of. This is a workaround for my own particular UTF-8 problem, refers to tab-separated values rather than CSV, and also involves proprietary software*.