After you have exported your Airtable data to CSV and opened the file in Excel, you may encounter corrupted or unreadable characters depending on the language in which language the data was entered. To configure your data properly for any language, you can change the input formatting option to “Unicode (UTF-8)”.
To do this in Excel:
- Go to the Data tab, then select "From Text"
- Locate your Airtable CSV file and select "Get Data"
- Then under "File Origin", you can choose "Unicode (UTF-8)"