Excel basically has a two-dimensional display of the data: columns and rows. EDI data is hierarchical and nested which does not allow a true two-dimensional representation.
HIPAAsuite tries to accommodate this using multiple values. For example, REF and DTP segments are translated into multi-line cells. In this way the spreadsheet displays multiple Benefits that a record might contain. For each Benefit, an Excel spreadsheet displays only one COB record and only one Provider.
Multi-line cells in Excel
Note: The record separator in Excel is ASCII 10 or Linefeed.