Using Excel and Cabrillo Files to Merge Logs
In some circumstances, it might be easier to combine logs outside N1MM Logger+ by importing the Cabrillo files into a spreadsheet program like Excel. As with the ADIF method, this works best if the contest types are identical, or at least use the same Cabrillo format (i.e. similar contest exchanges, same columns).

Create a Cabrillo file from each log: >File >Generate Cabrillo file. Assign a unique name to each log file to distinguish it from others when importing
Copy all exported Cabrillo log files to the computer that will create the merged log
Combine the QSO records from each Cabrillo log into a single text file using a text editor (like Notepad). Open each Cabrillo file, and copy only the QSO records – leave out the header information in the beginning and END-OF-LOG statement at the end. Paste this QSO information into a new text document (a .TXT file) with the QSOs from every log.
Launch Excel in the merge computer, and import the combined .TXT file into a spreadsheet. In Excel: >File >Open, set file type for TXT, and select the merged QSO log file. In the Excel text import wizard, declare the original data type as fixed width. In the Data Preview dialog window, adjust the field delimiters as necessary to begin each Excel column at the beginning of a log field. Press [Finish]. Examine the QSO columns in the spreadsheet to ensure that your import was successful
Select the entire spreadsheet using your mouse or [Ctrl]A, then sort the spreadsheet by date and time: >Data >Sort, column D (date), and column E (time)
Export the sorted log data to a space-delimited file: >File >Save as >FORMATTED TEXT (Space Delimited) .PRN
Using an editor, copy/paste the Cabrillo header information and END-OF-LOG statement from one of the original Cabrillo logs into the sorted data file. Rename this file as a .LOG file type and submit it to the contest sponsor.