Product: ImportOmatic
Description: This solution discusses how to parse data into separate columns
Environment: All
Version: All

Answer: 


To Resolve, open Excel and click on the File > Open option. Browse to the exceptions file and select Open. The Text Wizard prompt will open. Then follow the below.
  1. Make sure that Delimited is selected and then click Next.
  2. On the next page, make sure that Comma or Tab or both Comma and Tab are selected, depending on your data file delimiters.
  3. Select Text in the next prompt.
  4. Click the Finish button to open it correctly.