Lintilla (×3)?

Ah, yes, unearthing the shoe stratum! Well remembered.

City of Gold and Shadows by Ellis Peters is all about an archaeological dig (Romans on the Welsh borders)

The Amelia Peabody series is sort of archaeological soap opera, in that there's a lot of stuff concerning the logistics and relationships. It's been long enough since I read them that I'm not sure how integral the actual archaeology is.

Currently re-reading Alastair Reynolds' Revelation Space. Does weird alien stuff count as magical? I suppose it's not unearthing if it's not on Earth ;)

Hmmm, I think I did read that once, but a long time ago and it didn't stick in my head.

Since my (not really well articulated) initial point was to try to avoid the trope that the only way archaeology can possibly be interesting in fiction is to have it conclude 'OMG all our ancient cultures' myths and religions were true after all!' (not to mention the bits about having to shoot lots of people and dodge rolling boulders), I think archaeology on alien planets is perhaps not disqualified for this exercise but probably ought to fall into a separate category.

('But wait,' you object, 'your own example of Nightfall is set on an alien planet!' Well, yes, but it's not alien to the characters – they're doing archaeology on their own home planet and investigating their own civilisational history, regardless of whether that planet and civilisation is also that of the readers.)

I can't remember what the Revelation Space archaeologist(s) found out, but I think that if they were to dig up massively powerful and still working (or fixable) SF tech from a departed alien civilisation, that's definitely out of scope for much the same reason as digging up the Ark of the Covenant, because that too would push the idea that archaeology that only finds out information is too boring to bother with. (The IPX digs in Babylon 5 are also disqualified on this basis, come to think of it.)

The Engines of God (Jack McDevitt) certainly falls into the category of plot-relevant archaeology on remote planets. What they are digging up - or in some cases finding lying around in space - are inert objects constructed by a departed civilizations, rather than the high tech detritus of Revelation Space, and interpretation becomes critical as the plot progresses.

Hm. Have you read the Anthony Price cold war books? I've often recommended them as having non-stupid plots and non-stupid characters. The main character, David Audley is a historian rather than an archaeologist, but I think there are one or more other characters who are an archaeologist, and the plots often involve excavating something.

And sometimes the historical mystery is relevant and sometimes its fabircated, but it's always "knowing about what happened" rather than "following ancient secret instructions..." :)

No, I haven't read those, so thanks! Perhaps I should attempt to borrow one from you.

I don't know if you'd like them, but I think it's worth trying. The first is Labyrinth Maker, I'm happy to lend you any time.

Wikipedia has everything.

Frankly, most of those are utterly obscure to me. But for your stipulation that their archaeology has to be part of the plot, Jean-Luc Picard stands out!

I haven't done the 'middle-click every link' exercise to check, but I wonder if some of them might become more obvious if the name of the fictional work was listed as well as the name of the character. I couldn't tell you off the top of my head what the Nightfall archaeologists' names were (though I suppose, given the Nightfall culture's distinctive personal-name system, they'd probably at least be easily recognised in a list of that nature).

Here's one: Echoes of an Alien Sky by James P. Hogan (http://www.baenebooks.com/p-121-echoes-of-an-alien-sky.aspx).

What about the Doomsday Book, by Connie Willis? It won a hugo, so it's pretty famous, and the protagonists are on the border between historians and archeologists - I think described as historians, but definitely excavating graves and old buildings etc. It's timetravel, so maybe that breaks your No Magic criteria, but it's not Magic in that the stuff they find out is Definitely Just As History Was, it's just Magic in the way they find it out...

Oh, good example. Come to think of it there must be other time-travel stories which fulfil the spirit of "finding out about the past" even if there's 'magic' involved. Asimov's Ugly Little Boy. And surely I can think of others though I can't right now.

ETA: And I guess there's the reverse, like Da Vinci Code, where what's uncovered may or may not be magic, but is a matter of "ancient secrets which we need to re-learn"...

Cowl (Neal Asher) arguably includes some very-distant-past paleontology by means of time travel, although that's incidental to the plot really.

I haven't read it – perhaps another one to go on my list!

I read it as part of my 'read books by people I will hear at Worldcon' project, and I enjoyed it, but it didn't rock my socks.

Pretty much anything by David Gibbins would fit the bill. It's a bit Dan-Brownish with various revelations of what REALLY happened back in the past, but it doesn't involve magic / the supernatural at all.

Also, Robert Harris' 'Fatherland' involves archaeological discovery within the alternate-history Nazis-won-WW2 premise, so that plausibly counts.

Ah, that one I've read, so yes, I should have thought of it!

Agatha Christie had a keen interest in archaeology and travelled widely with her archaeologist husband. Murder in Mesopotamia is set on a dig, and the principal character is an archaeologist. It's moderately well known, I suppose; it's been done with David Suchet and all.

Do you count the Jurassic Park lot? They were technically palaeontologists rather than archaeologists I think. If we do count palaeontologists then Ross Geller in Friends definitely made it very clear how boring it was.