I did some stuff like this a few years ago - It's not directly from xls to adif, but rather csv to adif, so should be able to work with excel or really any spreadsheet. Details are here:

http://www.kg5cci.com/2016/12/logging-everything-to-lotw.html

It's just a basic perl script, but pretty flexible and I built it around satellite contacts specifically.

-Dave, KG5CCI

On Mon, Aug 24, 2020 at 9:10 AM Roy Dean via AMSAT-BB [email protected] wrote:

So I have 4 pages of contacts I need to log, and I'm dreading it. I figured I may as well do myself a favor and write a spreadsheet that spits out an ADIF file so that I don't have to create the ADIF with TQSL (which I despise). I don't use any other logging software, either - just pen and legal pad (actually it's engineering paper this time).

Before I embark on this journey of frustration, has anybody already created a satellite friendly excel (or better - libre office) file that converts multiple contacts into a single ADIF? Otherwise I'll share mine when I'm eventually done (I have found a bunch that are non-satellite friendly).

--Roy K3RLD _______________________________________________ Sent via [email protected]. AMSAT-NA makes this open forum available to all interested persons worldwide without requiring membership. Opinions expressed are solely those of the author, and do not reflect the official views of AMSAT-NA. Not an AMSAT-NA member? Join now to support the amateur satellite program! Subscription settings: https://www.amsat.org/mailman/listinfo/amsat-bb

Roy, For me the fastest way from pencil and paper to ADIF is Fast Log Entry. You can see it here: https://www.df3cb.com/fle/

If your heart is set on a spreadsheet step that is another story.

73, Joe kk0sd

-----Original Message----- From: AMSAT-BB [email protected] On Behalf Of Roy Dean via AMSAT-BB Sent: Monday, August 24, 2020 9:09 AM To: [email protected] Subject: [amsat-bb] Excel to ADIF

So I have 4 pages of contacts I need to log, and I'm dreading it. I figured I may as well do myself a favor and write a spreadsheet that spits out an ADIF file so that I don't have to create the ADIF with TQSL (which I despise). I don't use any other logging software, either - just pen and legal pad (actually it's engineering paper this time).

Before I embark on this journey of frustration, has anybody already created a satellite friendly excel (or better - libre office) file that converts multiple contacts into a single ADIF? Otherwise I'll share mine when I'm eventually done (I have found a bunch that are non-satellite friendly).

--Roy K3RLD _______________________________________________ Sent via [email protected]. AMSAT-NA makes this open forum available to all interested persons worldwide without requiring membership. Opinions expressed are solely those of the author, and do not reflect the official views of AMSAT-NA. Not an AMSAT-NA member? Join now to support the amateur satellite program! Subscription settings: https://www.amsat.org/mailman/listinfo/amsat-bb