ENF Discovery has a great add-in for Excel that can help you parse out fields in Concordance .dat load files. Concordance load files use pilcrows (¶) and thorns (þ) to separate out different metadata fields. The pilcrow designates a column; thorn a quotation mark; and ® a new line.
It can be tricky to separate the fields in the .dat file into separate columns in an Excel workbook. DAT-daddy does the work for you. It installs as an add-in for Excel. A new tab will be created in the menu. DAT-daddy lets you customize the delimiters.
The numerous fields of the .dat file are effortlessly separated into new columns.