If you’re a MacBook user and you’ve updated your operating system to the latest release, you may be having trouble opening CSV files in programs like Excel. Is all the content appearing in the first column instead of displaying across multiple columns? A change in the latest IOS release has impacted the way CSV delimiters are recognised. As a ResRequest user, this could affect your work process. Why? Most of the ResRequest reports that you export from the system export in a CSV file format and this information will no longer display correctly when imported into Excel. You can easily resolve this issue by changing the ‘Language and Region’ settings of your Mac.
What is a CSV delimiter?
A delimiter is a sequence of one or more characters used to specify the boundary between separate regions. The comma character is a field delimiter in a comma-separated values (CSV) file.
Follow these simple steps to change your ‘Language and Region’ settings. Be aware that the settings vary depending on what version you are using of either Mac OS or Excel (Office).