[Dx4win] Conversion program

[Alan Sewell]

Or you can do it the easy way and use KH2D's ASCII to ADIF Converter.

http://www.kh2d.net/software/asc2adif.cfm

You may have to rearrange the columns in your Excel file to get them in 
the correct order for the converter.  Then just save your Excel file as 
a CSV file.

73,

Alan  N5NA

http://www.tentecwiki.org



Larry Benko wrote:
> 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
>>
>>   
> _______________________________________________
> Dx4win mailing list
> Dx4win at mailman.qth.net
> http://mailman.qth.net/mailman/listinfo/dx4win
>