[Dx4win] Conversion program

[Larry Benko]

Steve,

This is a piece of cake to do.  I do it several times a year after going 
out mobile and making a few thousand contacts.  The procedure contains a 
few parts.

1.) Figure out how to take your Excel spreadsheet and export it to a 
text file that is column aligned.  I usually save as a CSV text file and 
then load the CSV file into a text editor such as UltraEdit where I tell 
it that every comma is a new column spaced every 25 spaces.  Now you 
have a column aligned text file with (for example), the call sign in 
column 1, the date in column 26, the time in column 51, etc.  You also 
have 1 QSO per line.

2.) Now you go into DX4Win and create a new import filter which looks 
for the ADIF field <CALLSIGN> starting in column 1 and the <DATE> field 
starting in column 26 etc.  Name and save your import filter.

3.) Now use your newly created filter to import your Excel text data to 
a blank DX4Win log.  You will probably have some mistakes in the date 
and time formats and maybe a few other things.  Fix them and redo.

4.) Once you have a good DX4Win log from the Excel data you can merge 
this log with you real log.

73,
Larry, W0QE

Stephan Busono wrote:
> Fellow DX4Win users
> for those computer expert out there, is there a utility program that can
> convert an XLS (regular (exel) type spreadsheet )log to an ADIF so I can
> import it to DX4Win.
> Thanks for the help/input
> 73, Steve, W2FB
> _______________________________________________
> Dx4win mailing list
> Dx4win at mailman.qth.net
> http://mailman.qth.net/mailman/listinfo/dx4win
>
>