ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Rev --
Chnges from 2022 version B2 -Corrected problem that time was not always 4 digits [added column S as 4 digit time on inout sheet and substituted input column S for time in concatenated output]. Fixed SM4XAS call typo.
2
3/13/2023
note:
THIS EXCEL FILE MUST BE OPENED IN EXCEL. DOWNLOAD file and open in Excel - Not Google Sheets
3
This workbook automates making a comma separated values (CSV) file from the online 2019 NRR Logger
4
Then you may create an ADIF file using one of the available converters. Instructions for using the SM4XAS converter are included below
5
All you need do is cut and paste once and optionally select some frequencies.
6
7
How it works (Go directly to the INPUT tab if you're not interested)
8
NRR logger cells are copied and pasted into the INPUT sheet of this workbook
9
The cells are concatenated into CSV formatted QSO lines and
10
the date is converted to yyyymmdd from yymmdd format
11
a CW mode field is added to each QSO line
12
a field with one fixed frequency per band is added to each QSO line. The user may optionally enter the one-per-band frequencies
13
a comment field with the miscellaneous data not included in the other fields is added
14
15
The order of the CSV output fields is
16
QSO Date
17
QSO [End or Start] Time
18
Frequency
19
Operator
20
Callsign
21
Name
22
Band
23
Mode
24
QTH
25
RST Sent
26
RST Rcvd
27
Comment
28
29
SM4XAS's online CSV to ADIF Converter is recommended for making a ADIF (.adi) file. It may be found at
30
https://sm4xas.se/csv2adif/
31
32
Instructions for using SM4XAS's converter
33
Make sure that Comma is selected as the Field Divider at the bottom of the converters first page.
34
Select the order and fields that will be converted to ADIF format.
35
Starting with Field 1, select the following field labels in the order listed down to Field 12
36
1-QSO Date
37
2-QSO [End or Start] Time
38
3-Frequency
39
4-Operator
40
5-Callsign
41
6-Name
42
7-Band
43
8-Mode
44
9-QTH
45
10-RST Sent
46
11-RST Rcvd
47
12-Comment
48
Click on Goto Step 2 - Input CSV Data
49
In the Excel workbook OUTPUT sheet, COPY the CSV data and PASTE it into the input window of the Converter
50
Click on Goto Step 3 - Verify Data & Save
51
Click on Save ADIF File if it looks good
52
53
Import the ADIF file to your logger and/or upload it to LoTW, Club Log or other online sites as desired.
54
If the ADIF is rejected, look for and fix the error in the CSV data in a text editor or the input window and convert again.
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100