ADIF to Excel to ADIF Converter
Here is my
first project I want to present:
ADIF to Excel to ADIF Converter V1.05 ->
ADIF to Excel to ADIF Converter V1.05 ->
versions please see below
I could not find a comparable tool on the web, I developed 2
little VBA scripts.
Converting ADIF Logbook to Excel
2) Converting Excel to
To convert an existing
ADIF file to Excel
is straight forward.
1) Sometimes only some ADIF Tags are
needed. For this purpose you can select and/or add a preferred
sequence of ADIF-fields below the frame in the textbox in order to
sort the ADIF Tags. Klick the checkbox if you want to skip the unwanted ADIF tags.
2) Press Arrow "To Excel" and
select your source file-> A new tab in the workbook with your
logbook is generated.
To convert an Excel
to ADIF requires a bit more
1) Sometimes the QSOs are already in Excel. Press
"Make New Sheet" in order to get a new empty sheet. Copy
your QSOs starting row 2. In row 1 put the corresponding ADIF
Tags. If some columns shouldn't be converted to ADIF, delete the
heading ADIF Tag or replace it by "nil".
Press Arrow "To ADIF" to convert last Log (always last
tab in workbook).
!) An existing File will be replaced by the
new Log without asking.
generally a pure text format. You have got 2 possibilities to
proceed with numbers and dates:
In case the date is still in Excel
format like "January 1, 2020" it can be converted to
ADIF text format befor converting I.e. "20200101". Best
is the text function =Text(A2;"JJJJMMDD") (A2 represents
the actual date column).
The Date and Time fields however
generate occasionally some trouble.
In order to ease using this tool
with already existing excel logs, I implemented in this version a
converting routine. I tried to teach Excel many conversion
possibilities. However you need to make sure that the columns are
in the correct format. The "General" format is not
always a good choice.
1) Either you have "Text"
format. Then everything is converted as it is
2) Date entries
can be in proper ADIF text format or in Excel date and are then
3) Time in Text or in proper time format
Numbers either as numbers or text
6) Use the filter function in order to exclude rows from conversion into ADIF format.
6) Text starting with a
number (i.e. call 9A1XXX) needs to be in text format. Therefore
the column "Call" for example is always best in text
In case of problem keep experimenting with column
formats. If you should have a spreadsheet that is not convertible
you could let me know. I will try to learn about the obstacles and
try to improve the tool or find some workaround. Please mail to:
tool works together with any logbook that is able to export and
import ADIF logs.
However I'm using Logger32 by K4CY since
2005. ( http://www.logger32.net/ )
A really great logbook
program. Unfortunately it has an important disadvantage: there is
no bulk editing function, i.e. I can'’t mark several entries
and modify them in one go. This is necessary from time to time for
example after a contest when I need to update QSL_sent and
I export my logbook out of Logger32 to
2. Convert it to Excel
3. Edit the entries
4. Convert back to ADIF
5. Import to Logger32
might look quite complicated, however still better than editing
100+ entries manually.
Probably there are more Logger32
users out there who liked to have an bulk-editing feature as well
and drop a feature request in Bob'’s Forum (Author von
then I wish you much fun and success with this little tool.
would be happy to get some feedback from you. Thanks to user
feedback first bugs could be eliminated.
Please mail to:
This means you
can use it free of charge. I cannot take any responsibility for
any type of damage caused by this tool. .
If you have found it
useful, and/or you think I have done a fair job, I would be happy
to get a Postcard or QSL- card. Please send via Bureau or
license: GNU GPL
code is free. If you want to use the code in your project it
should be free as well.
VY73 de Harald, DL1HW
Below you can find a
previous stable version of the converter purely based on Text
formats in case you should run into troubles with the converting
ADIF to Excel to ADIF
Converter V0.99b 20131120 -> adif2xls2adif_v0.99b.xls
to Excel to ADIF Converter V0.99b 20131120 ->
20091028 V0.96b bugfix
20100430 V0.97 New
Features: Easy file select, mask columns to export by
20110204 V0.97b Extended maximum ADIF field
length from 255 to 32,767 characters
V0.98 Maximum number of entries extended from 32.767 to
65535, progress indicator added.
20110319 V0.98b Alternative
version in new Excel format .XLSM with 1.000.000+ possible
20110326 V0.98c Bugfix of adif2xls2adif_v0.98.xls
20110326 V0.98d Bugfix
of adif2xls2adif_v0.98b.xlsm (Empty export)
Added function to create a new empty Excel sheet (Make New
20140106 V1.00beta Added function for converting Date
and Time formats to ADIF
20140806 V1.02beta minor changes and
some additional explanations how to use
minor bugfix - presetting of the rows with radio button
20160105 V1.03 removed beta as
for a long time no more bugs have been reported
20181111 V1.04 Added a control box to transfer only selected ADIF fiels
20190619 V1.05 Added filter functionality to exclude rows from conversion
2009-05-04 13:01:37 by DL1HW
Updated 2019-06-19 12:52:18 by