If the CSV file of your exported member list or audit log looks distorted, there are a few ways to fix it:
- Check the file in a different program: Try opening the file in Excel or a text editor.
- Check the encoding: Make sure you’re using the right encoding format. CSV files are output in UTF-8, which can cause distortion in Excel.
For Windows users
Try opening the file with Notepad:
- Right-click the CSV file and select Open with > Notepad.
- Once in Notepad, select File > Save as.
- Change the encoding to “UTF-8 with BOM.”
- Select “Save.”
- Open the file in Excel.
For Mac users
Try opening the file with TextEdit:
- Right-click the CSV file and select Open with > TextEdit.
- Use Command + Shift + S to duplicate the file.
- Use Command + S to open the save screen.
- Add “.csv” to the end of the file name.
- For plain text encoding, elect “Japanese (Shift JIS).”
- Select “Save.”
- Open the file in Excel.