We’ve noticed that some of our European customers may encounter issues when opening CSV files exported from Romify. There are two common problems:
- Special Characters Not Displaying Correctly – Characters like ä, ö, and others may not be read properly.
- Comma Separation Not Recognized – Excel may not separate the data into columns as expected with comma-separated files.
To resolve these issues, please follow these steps:
Open CSV file through PQ (Power Query) using the Get Data dropdown
- Navigate to Data tab > Get Data > From file > Get Data from Text/CSV
Use the "Get Data From Text" option
- This option is available in "Tell me" and in the ribbon
- It opens the Text Import Wizard and does not create external links to the workbook
