When exporting data from Sporty to a CSV file, you might notice that special characters like macrons do not display correctly when the file is opened directly in Excel. This is due to Excel's default character encoding settings.
To ensure that these characters display correctly in Excel, please follow these steps to import your CSV file:
To import your CSV file:
- Open Excel and start with a blank workbook.
- Go to the Data tab in the Excel ribbon.
- Click Get Data → From Text/CSV.
- Browse to your exported CSV file and click Import.
- Check the preview - if names and special characters look correct, click Load. No further changes are needed.
If characters are not displaying correctly in the preview:
- Click the File Origin dropdown and select 65001: Unicode (UTF-8), then check the preview again.
- Make sure Delimiter is set to Comma.
- Click Load.
Following these steps will ensure that all special characters, including macrons, are displayed correctly in Excel.