[UK-CONTEST] Excel to Cabrillo (text) file - help pse?

[Gavin Taylor GM0GAV]

Hi Nigel,

I did a similar thing some time ago to help somebody get started with
Dxbase. It started out in a nasty G4TYF log format.

I used excel to manipupate it into the correct format, then exported to a
csv file. From there used Asc2ADIF http://kh2d.net/software/asc2adif.cfm to
convert it to an adif. That will then go straight into TQSL for upload.

If you run into problems send me a sample log and I will take a look.

73 Gavin
GM0GAV

----- Original Message ----- 
From: "Don Field" <g3xtt at lineone.net>
To: "UK Contest Reflector" <uk-contest at contesting.com>
Sent: Tuesday, March 01, 2005 1:50 PM
Subject: Re: [UK-CONTEST] Excel to Cabrillo (text) file - help pse?


> Trivial Nigel - Paste-special (unformatted text) into Ultraedit or
> equivalent, and you can then manipulate the columns to your heart's
content.
> I do it all the time when people send Excel logs for the IOTA contest.
>
> 73 Don G3XTT
>
> ----- Original Message -----
> From: "Nigel G3TXF" <nigel at G3TXF.com>
> To: "Chris Tran ZL1CT" <zl1ct at gm7v.com>
> Cc: "UK Contest Reflector" <uk-contest at contesting.com>
> Sent: Tuesday, March 01, 2005 10:18 AM
> Subject: [UK-CONTEST] Excel to Cabrillo (text) file - help pse?
>
>
> > Hullo Chris,
> >
> > Could you (or anyone else on the UK Contest Reflector) pse help me to
> export
> > an Excel file into a "Cabrillo compatible text-file"?
> >
> > I have been trying to do this with Word's Mail-Merge, but Mail-Merge
gives
> > you separate file for each line entry, and what I need is all the
entries
> > from the log in one flat text file.
> >
> > I realise that this is easy enough for those that know how - but I
don't!
> >
> > I have all my DX-Trip Logs in Access and now want to up-load them to
LoTW.
> > Exporting from Access in Excel is no problem, but getting from Excel
into
> a
> > Cabrillo-style flat text file is where I need help!
> >
> > 73 - Nigel G3TXF
> >
> > ----- Original Message -----
> > From: "Chris Tran ZL1CT" <zl1ct at gm7v.com>
> > To: "Tom Wylie" <t.wylie at ntlworld.com>; <uk-contest at contesting.com>
> > Sent: Tuesday, March 01, 2005 4:52 AM
> > Subject: Re: [UK-CONTEST] Easy question
> >
> >
> > > Hi Tom
> > >
> > > I have not actually done this, but one procedure would be :-
> > > 1. Export the Excel spreadsheet data to a Cabrillo compatible
text-file
> > > 2. Use WT4I tools to check this file, then save as a Cabrillo log-file
> > > 3. Import the Cabrillo log-file into logging software (Writelog cannot
> > > import Cabrillo)
> > > 4. Export as a .adi file
> > >
> > > There must be an easier way to do this..... ?
> > >
> > > 73
> > > Chris
> > > ZL1CT
> > >
> > > ----- Original Message -----
> > > From: "Tom Wylie" <t.wylie at ntlworld.com>
> > > To: <uk-contest at contesting.com>
> > > Sent: Tuesday, March 01, 2005 10:56 AM
> > > Subject: [UK-CONTEST] Easy question
> > >
> > >
> > >> How can I convert from an Excel file to an ADIF?
> > >>
> > >> tom
> > >> gm4fdm
> > >>
> > >> _______________________________________________
> > >> UK-Contest mailing list
> > >> UK-Contest at contesting.com
> > >> http://lists.contesting.com/mailman/listinfo/uk-contest
> > >
> > > _______________________________________________
> > > UK-Contest mailing list
> > > UK-Contest at contesting.com
> > > http://lists.contesting.com/mailman/listinfo/uk-contest
> > >
> > >
> >
> >
> > _______________________________________________
> > UK-Contest mailing list
> > UK-Contest at contesting.com
> > http://lists.contesting.com/mailman/listinfo/uk-contest
> >
>
>
> _______________________________________________
> UK-Contest mailing list
> UK-Contest at contesting.com
> http://lists.contesting.com/mailman/listinfo/uk-contest
>
> -- 
> This email has been verified as Virus free
> Virus Protection and more available at http://www.plus.net