How to Calculate & Track Your Business Mileage Automatically with Google Sheets

How to set up a Google Spreadsheet to automatically calculate and keep track of your business mileage, ready for your year-end expense claim.

⭐ My Referral Links ⭐
🏎️ Schedule a FREE test drive or order Tesla Products: geni.us/SoN-TESLA
💡 Split £100 with me when you switch to 🐙 Octopus Energy: geni.us/SoN-OctopusEnergy
🧋 Get £10 off at Huel: geni.us/SoN-Huel
🎸 Buy musical instruments, audio & PA gear from Thomann: geni.us/SoN-Thomann
🌍 My KIT profile: kit.co/paulfp
(Commissions/credits are earned from these links, which helps support me and the channel.)

The Spreadsheet formula uses Google Maps' API to plot the driving route between the two locations and then extracts the distance driven. Copy & Paste this into the appropriate cell inside Google Sheets:

=importxml("maps.googleapis.com/maps/api/directions/xml?ori…; & C2 & "&destination=" & D2 & "&sensor=false&alternatives=false&key=" & API_KEY!$A$1,"//leg/distance/value")
[Change C2 and D2 to whichever cells have your start/end points in, and ensure you have a sheet called API_KEY with your API key in cell A1.]

The formula to turn the result of the above into miles is:
=ROUNDUP(CONVERT(E2, "m", "mi"), 1)
[Change E2 to whichever cell it should be referencing.]

⭐🤩 If this video has helped you, a Super Thanks would be very much appreciated! 😘😉

► Support on PATREON: patreon.com/SwitchedOnNetwork
► Browse our MERCH: teespring.com/stores/switchedonnetwork
► Explore our GEAR: kit.co/paulfp

Check out our Amazon Influencer shops!
► UK: amazon.co.uk/shop/switchedonnetwork
► USA: amazon.com/shop/switchedonnetwork

### Let's connect... ###
# Twitter - twitter.com/SwitchedOnNet
# Facebook - facebook.com/SwitchedOnNetwork/
# Instagram - instagram.com/switchedonnetwork/
# Tumblr - switchedonnetwork.tumblr.com
# Pinterest - pinterest.co.uk/switchedonnetwork/

Visit our website at switchedonnetwork.com/ and enable push notifications so you never miss a new video or post.

Switched On Network is hosted by Paul Freeman-Powell
► Follow Paul on Twitter: twitter.com/paulfp
► Follow Paul on Facebook: facebook.com/paulfp

We sometimes use free sound effects in our videos from freesfx.co.uk

Stock video clips are (usually) from VideoBlocks, now called Storyblocks Video. You can get a free trial at videoblocks.go2cloud.org/SHFJ

DISCLOSURE: As an Amazon Associate we earn from qualifying purchases.

Copyright © Innobella Media Limited 2018. All Rights Reserved.
innobellamedia.uk/