Below I've compiled the lists of spells the Bard and Ranger have either lost or gained for each spell level. I've only included spells from the phb as those are the only spells included in the Playtest. If I've marked a spell with an asterisk (*) that spell has been added to the class' spell list in Tasha's Cauldron of Everything. Since these expanded spell lists remain optional I've decided to include them but mark them separately. Therefore a "lost" spell with an asterisk means you only lose it if you were using the expanded spell lists, while a marked spell that's been gained means you would've had it with Tasha's expanded spell lists anyway, but now it would be a base addition to the list instead of an optional expansion.
Spells included in the Bard's "Songs of Restoration" feature are not included since this feature's very purpose is to add those spells to your list despite them missing otherwise. All five of them would've been considered lost otherwise (with an asterisk in case of Mass Healing Word). That said, you do get each of this spells a level later than normal access to their spell levels, so keep that in mind. Now without further ado, let's start with the Bard.

Bard cantrips:

1st level Bard spells:

 2nd level Bard spells:

3rd level Bard spells:

4th level Bard spells:

 5th level Bard spells:

6th level Bard spells:

7th level Bard spells:

8th level Bard spells:

9th level Bard spells:

And now for Rangers. For their cantrips I'll quickly mention that they can no longer pick Produce Flame, but in return cantrips are a base feature of the class now, so this seems a small price to pay.
Also useful to note is that with the changes to ritual casting, rangers can also use rituals now, which can impact the value certain ritual spells would have.

1st level Ranger spells:

2nd level Ranger spells:

3rd level Ranger spells:

4th level Ranger spells:

5th level Ranger spells:

 May these lists prove useful in your assessments of the changes. Feel free to use the thread to discuss the impact you foresee these changes will have on their respective classes. 
And if you find any spells I've missed, do let me know. 

Ranger definitely got more out of play test, Bard is sort of re-balanced, slightly nerfed over all and seems it got slightly less spells because of it, at least early on. Faerie Fire is definitely a big one but then they now at least get haste and fly, so that is a thing. I can imagine some bards will use magic initiate to pickup either faerie fire or bless given how good they are for 1st level.

I guess we need to wait for the priest class but the way Bard is building up, it seems like sort of a "half" healer, some access to basic heal spells and the reactive healing of inspiration (which is cool). no resurrection type spells tho, so you're gunna need a priest class or a ranger for that. Magical secrets comes in at level 10 tho, and now magical secrets lets you change the spells on a long rest, so bard has far more customization with that feature.

While on paper it seems like Ranger's got alot. There's a distinct reliance on spell slots for features that use to be free.

Utility options, movement options, hints at skills use changes(animal handling, ect), nature's veil, Hunter's mark is a combat must. Costs add up, some adventurers have "balanced" long rests but not all.