How to Make a Map of Your Visited Stations!

[@everylaststation]

Updated spreadsheet will be uploaded later this week with Leven & Cameron Bridge on it. Along with a few corrections

[@actuallyneon]

Will it have station codes aswell? :p

[@Trainspotting_Mayhem]

Might just be me, but just in case, I think Hayes and Harlington is in the wrong place and is where Hayes (Kent) is meant to be

[@everylaststation]

@@Trainspotting_Mayhem Corrected 👍

[@everylaststation]

@@actuallyneon I've not done it as I don't feel the need for it.

[@rooneydonal21]

Can you update Northern Ireland too. like Yorkgate is now York Street, Londonderry waterside is now Derry~Londonderry, Belfast Central is now Lanyon place and Great Victoria Street is now closed

[@JayDoranTO]

Just started to do this. At first I tried to do it from memory from back when I was making a bunch of rail trips in the late 1980's. But fortunately this time that I'm back in the UK (moved away in 1997 to N.America) I've managed to find all the little log books that I made! Lots of records from 1989 to 1992! Time really get to work on this spreadsheet!

[@tommarshall1660]

Well Nick that was very interesting, but as I am 77 years old I am now completely confused but in complete awe of your skill on the PC. Keep up the good work, holidays will be here soon.....

[@thisis_mudchute]

2:23 yay, nick's very real stations spreadhseets

[@sambrookes4497]

You can import the second spreadsheet into the same layer so you don’t have to do everything twice

[@nigelkthomas9501]

Best video yet! Thank you so much, Nick! This is just what I’ve been looking for.

[@Sim0nTrains]

Very interesting video Nick, Thanks for this

[@MRTransportVideos]

Really useful - I downlaoded the database then, after looking at it, made a couple of augmentations to suit my needs. Because I've travelled a fair bit without getting off at every stop, I added a 'Via' option, added a 'Stations Via' entry to the Totals and, in order to give an easier way to see the totals, added a %age calculation: I also added Heritage Lines (because I've travelled on a few), giving a total of 2,879 stations - it looks nice, thanks Nick.

[@stephenhersee]

This would be even better if you made the spreadsheets for each line / train operator, and then used those to make each layer in my maps. It's probably more management, but I imagine it looks a a lot better to view than just 1-2000 and 2000+ on a Google map

[@kareemsstuff5007]

On everylaststations's excel file, filter the TOC you want and only import that data.

[@SimplyBurgerYT]

Thank you so much Nick! This is super helpful

[@ArthurTK26]

Great video, never knew about most of these things, will try it all out soon!

[@mik99D]

Good spreadsheet use. Well done Nick. I may use some items for something else.

[@trainspotter586]

Keep up the great work nick badley

[@ElijahsTransport]

Great video! Now that you've done this can you please show us how you make your animations for when you move in your videos?

[@JBFlytography]

Nick are planning on visiting Leven & Cameron Bridge when it opens?

[@grassytramtracks]

I've been to a fair number of stations just by travelling to different places for whatever reason. I've been to (got on or off or changed): Avoncliff, Bath Spa, Bond Street, Bradford-on-Avon, Branksome, Brighton, Bristol Parkway, Bristol Temple Meads, Brockenhurst, Cambridge, Cardiff Central, Carmarthen, Chetnole, Clapham Junction, Clifton Down, Crewe, Custom House, Didcot Parkway, East Dulwich, Edinburgh, Filton Abbey Wood, Fratton, Freshford, Frome, Guildford, Haslemere, Heathrow Terminal 5, Imperial Wharf, Llandeilo, London Bridge, London Liverpool Street, London Paddington, London St Pancras, London Victoria, London Waterloo, Nailsea & Backwell, Newport (South Wales), Oxford, Peckham Rye, Plymouth, Port Talbot Parkway, Portsmouth Harbour, Reading, Redruth, Romsey, Ryde Esplanade, Shanklin, Southampton Airport Parkway, Southampton Central, Stansted Airport, Sugarloaf, Swindon, Taunton, Tottenham Court Road, Warminster, Westbury, Weston-Super-Mare and Willesden Junction.

[@matthillmedia]

Thank you Nick, very useful. I shall definitely be doing this.

[@lapiswake6583]

Just did this for my totals. And I discovered that I hadn't marked off that I'd dome Stratford, for some reason. Teesside Airport isn't listed. Which, on one hand it's had its service suspended since 2022, but on the other, it isn't officially closed. Doing this makes me realise how much I still have to do in the South East, which I should be able to do on day trips...

[@everylaststation]

Teesside Airport station is closed. Officially or not, you can't board a train there, or even gain access to the platforms. Only included stations on the spreadsheet that you can actually visit. (Except Altnabrek which will be removed from the spreadsheet in due course.)

[@Djengland2010]

Your the best KZbinr ever never forget that

[@Nooticus]

Very very clear tutorial!

[@paulharvey9149]

Fascinating. I don't promise to do it though - it'd take me weeks, as I'd have to keep checking back, I suspect!

[@TimEaston]

Thank you for this explaner video I have just created my own map.

[@mrowl-the-dsm1304]

Wow, Very Useful Nick, your additional vocation in life, Teaching Excel and Google My Maps, Thanks very much :-)

[@RichardOldroyd]

OMG I need this in my life being a map nerd.

[@Steggs]

I think this is a sign I need to transfer the list of stations I've been to from my notepad app on my phone to this 😅

[@Olivers-trains]

I've done something similar with a similar spead sheet and all the stations incl heriatage on maps

[@JessicaRainbow]

Really interesting. It would be good to be able to add the colour the rail lines onto it too

[@tramographyMCR]

You can, but it might have to be done manually

[@AndyTrainRock]

thanks for this tutorial nick! can you do how to create the graphics (the one with the route like liverpool - chester) please?

[@Thornaby37]

I still do this the old fashioned way, with the rail atlas by S K Baker

[@tomedy_official]

Good with the west Highland line, it will take you months

[@NameReveal-yy7qb]

thanks nice video could you please do exploring the scotrail express line

[@mario_master1]

question douse this include heritige lines. if not could you add them???

[@JellyBeanUrbex]

Nice video! Can you do All the Stations on the Tyne and Wear Metro please!

[@everylaststation]

I have a link on the downloads page for the Tyne & Wear metro. Click on "Metro Stop Visiting Logs"

[@AlexFrew-kv2vg]

Would you ever consider visiting stations in Northern Ireland as well as Ireland. Asking for a friend. Never forget your awesome.

[@jackthetrainspotter9727]

The closest I’ve got is a hand drawn map of the rail lines I’ve been on. However, I’ve been on every passenger rail line in Britain bar 4 😃

[@ChrisWilliams-u9e]

how do you add new stations when then open

[@QuantumPulsar]

This is a great idea! But I don't have many visited stations so my map is mostly red 😭

[@Lewisjma21]

Do Chesterfield to Nottingham to Derby to chesterfield (all EMR)

[@walkingtheboogie]

I am surprised 2,000 rows of data are seen as a lot by Google Maps. It's nothing compared to the amount of data Google holds. I'm also surprised that one can only upload 2,000 rows at a time. If it was 200,000 rows of data, that would be something else. Very interesting video, and I say this as someone who is a professional cartographer and now works at maintaining address and street gazetteers for a couple of local authorities.

[@mrpasta6961]

can you make one for belgium pls

[@muru6027]

Do you count stations you have actually gotten off at or just been through without getting off?

[@InkItOut]

The definition of "visiting a station" we use is to board or alight a train at the station, and this can't be getting of the train and back on the same one unless it's a different headcode.

[@holdingpointaviation]

can someone please do this for airports

[@paultidd9332]

Can you do this in an Apple world? I never really trust Google with my data!

[@SeanMidlandstransporthub]

Yet you literally are commenting this on a Google account with your name and face 🤣🤣

[@raantaaro]

bro said sporlding (sorry i giggled)

[@trainlover16]

Does this include stations your train has stopped at or only stations you've alighted at?

[@NickBadley]

Depends on what definition of "Visit" you use! I personally do board and/or alight at a station. You could even make 2 maps, one for stopped and one for boarded/alighted!

[@trainlover16]

@@NickBadley I’m just gonna do all the ones I’ve stopped at.

[@boozytortoise]

I've always wondered this too. Geoff visited every station..but went by definition of train stopped at due to time restraints. But I know a lot don't count that as having visited them

[@LynseyMcKee-dd7wg]

Hav u benn to hairmyres station😊

[@JoshHodginsTrains]

Cheers

[@Jamesandluckytv_123]

Go to Oban 😀😊

[@aviationtrainsfc1]

I like oban i have been twice

[@EagleLord27]

I did this on a mac

[@RohanEllis-hallett]

Nick have you been to Cambridge and Cambridge north and be ready for Cambridge south to open as the newest station in the uk

[@IowaTrainGay]

Is there something like this for USA/CAN stations? This looks so cool!

[@andyt2510]

Seems a lot easier than what I did - all stations as normal, then up to 4 people can have their own tally, of either passed through, boarded or alighted at the station, or only passed by on a Rail replacement bus. That isn't hard, what took the time was the second sheet which has the map of the UK! All cells sized and coloured in manually, with stations linked by red lines and includes closed stations, closed lines in grey, proposed and under construction stations and lines in purple and heritage lines and stations in green, though open stations are on the map by their 3 letter code, though a note will tell you what they are. London is very crowded though! Other tabs have the countries Metro systems. I'm glad I'm not the only one who has a spreadsheet to keep track though!

[@thisis_mudchute]

having never been to the north (i really want to gonbut its too expensive) my map (which i wil make soon) will look bery embarassing

[@PaulF0ley]

What if I don’t know where I am?