ADIF to Excel to ADIF Converter

Here is my first project I want to present:

ADIF to Excel to ADIF Converter V1.03 -> adif2xls2adif_v1.03.xls
ADIF to Excel to ADIF Converter V1.03 -> adif2xls2adif_v1.03.xlsm

Previous versions please see below



As I could not find a comparable tool on the web, I developed 2 little VBA scripts.

Features:
1) Converting ADIF Logbook to Excel

2) Converting Excel to ADIF Format

How to use:
Convert to Excel
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.
2) Press Arrow "To Excel" and select your source file-> A new tab in the workbook with your logbook is generated.

Convert to ADIF
To convert an
Excel to ADIF requires a bit more attention.
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".

2) 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.

ADIF is generally a pure text format. You have got 2 possibilities to proceed with numbers and dates:
First: 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.
Second: 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 converted
3) Time in Text or in proper time format
4) Numbers either as numbers or text
5) 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 format.

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:
adif2me.hw14#9ox.net (#->at)



Background:
This 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 QSLSDATE.

1.      I export my logbook out of Logger32 to ADIF

2.      Convert it to Excel

3.      Edit the entries

4.      Convert back to ADIF

5.      Import to Logger32

This 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 Logger32) http://groups.yahoo.com/group/hamlogger/

Up to then I wish you much fun and success with this little tool.
I would be happy to get some feedback from you. Thanks to user feedback first bugs could be eliminated.
Please mail to:
adif2me.hw14#9ox.net (#->at)

Users License: Card-Ware
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 direct.
See www.qrz.com.

Developers' license: GNU GPL
The code is free. If you want to use the code in your project it should be free as well.


VY73 de Harald, DL1HW


Previous Versions:
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 one.

ADIF to Excel to ADIF Converter V0.99b 20131120 -> adif2xls2adif_v0.99b.xls
ADIF to Excel to ADIF Converter V0.99b 20131120 -> adif2xls2adif_v0.99b.xlsm


Version history:
20090501 V0.95
20090823 V0.96 bugfix
20091028 V0.96b bugfix
20100430 V0.97 New Features: Easy file select, mask columns to export by "nil"
20110204 V0.97b Extended maximum ADIF field length from 255 to 32,767 characters

20110319 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 entries.
20110326 V0.98c Bugfix of adif2xls2adif_v0.98.xls (Empty export)

20110326 V0.98d Bugfix of adif2xls2adif_v0.98b.xlsm (Empty export)
20131120 V0.99b Added function to create a new empty Excel sheet (Make New Sheet)
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
20150303 V1.03beta minor bugfix - presetting of the rows with radio button fixed

20160105 V1.03 removed beta as for a long time no more bugs have been reported



Statistiken



Created 2009-05-04 13:01:37 by DL1HW
Updated 2016-01-05 15:28:18 by DL1HW