I have saved chart data / echo profile as a csv file. How can I import it properly in Excel?
Opening a saved csv file in Excel is showing strange values and dates in columns.
Reason / solution:
The export file uses a full stop ‘.’ as decimal separator. Depending on the local settings in Excel a comma ‘,’ is expected as separator. A proper import is possible following these steps.
Don’t double click on the file, open Excel and select File, Open. This will start the import wizard. Select next to go to step 2. Here you have to select Semicolon as delimiter.
Click Next to go to step 3. Select Advanced and change the Decimal and Thousands separator.
If you have further questions, please contact ourtechnical support
- You have a technical question / problem: Ask the Technical Support
- You want to discuss in our forum and exchange experiences with other users
- You want to create CAx data for one or more products
- You would like to send us feedback on this Entry