Has anyone successfully imported XML data from QRZ into Excel? I'd like to set up Excel so I can enter a call sign and get little operator data back into my spreadsheet. Anyone willing to give me some pointers how to do this?
Google "xml to excel macro". There are lots of options depending on what "exactly" you are aiming to do. And you can get very specific if you're familiar with VBA (<- that's kind of like a programming language within Excel).
This is how scraped my QRZ log in 2023 with Microsoft Edge into Excel by hand. I'm familiar with HTML and how to inspect the source - been doing it for years with other things. Display your log. Go to the first page, line, right click and "Inspect". On the right-hand side of the browser is now an inspection tool for the page source - in the Element tab, it ought to be highlighting the source line for that first line in the log. Now the trick is you want to find the start of the log table - that is a few lines above, mine says ---> <table id="lbtab" class="styledTable activeLogbookTable"> <--- Highlight that, right click, copy, copy OuterHTML - Switch to Excel, and Paste. Go back to QRZ, go to page two, line one, and do another Right click Inspect. and repeat. When you paste into excel, delete the header on page two and subsequent pages.
