CSV export display issues in Microsoft Excel

Microsoft Excel does open CSV files; however, it can cause some layout issues. Other software, such as LibreOffice or Google Sheets, displays CSV correctly.

If you prefer to use Excel, you can resolve the formatting using either of the methods below.

Method 1: Use Text to Columns functionality

1. Open the CSV file in Excel Highlight column A (click the letter 'A' at the top of the column).

2. Click on the Data tab.

3. Click on Text to Columns.

4. Select Delimited and click Next.

5. Tick the box for the correct delimiter (usually Comma or Semicolon) until the data preview separates into neat columns.

6. Click Finish.

Method 2: Import from Text/CSV

1. Open Excel
2. Click "Blank workbook"

1. Click on the "Data" tab
2. Click on "From Text/CSV"
3. Select the CSV file you have downloaded from the portal
4. Click load