VERIFIED SOLUTION i
Data corruption while converting Sagent Weblink exported '.csv' data into '.xlsx' format
After exporting data from Sagent Weblink, data gets corrupted while converting data from CSV to XLSX format. This could occur for alphanumeric data.
This could happen if the data is not converted from CSV to Excel format using text option in the 'Text import wizard' of Microsoft Excel.
UPDATED: August 10, 2018
Use following steps to convert CSV to Excel format:
- Open Microsoft Excel.
- Select 'Data' > 'From Text'. This opens the 'Text Import Wizard'.
- Click on Next, then select the delimiter as 'comma' (or as applicable).
- Click on Next.
- In the 'Data Preview' section, select the affected column (which has alphanumeric data or which has the error).
- Now select 'Text' in the 'Column data format' option.
- Click on 'Finish'
Product Feature: Weblink Client
- No Downloads