When using the download function, you will receive a CSV document. This document can then be opened in a spreadsheet program such as Microsoft Excel. In Excel, you can select the entire column A and then, via the ‘Data’ tab, use the function ‘Text to columns’. In the window that opens, select ‘Delimited’ and then click ‘next’. In the following window, select ‘comma’ as the only delimiter. Then click on ‘Finish’. Once you have done this, all your data will be divided into columns.
You can change your permissions via 'customise preferences'.