• Skip to content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer
  • Start Here
  • Articles
    • Preparing to Cruise
    • Buying a Boat & Gear
      • Buying a Boat
      • Boat Gear
      • Galley Gear
      • Personal Gear
      • Tools
      • Emergency Gear
      • Non-Electric Alternatives
      • Books & DVDs
    • Cruising & Chartering
      • Chartering
      • Skills for Cruising
      • Cruising Stories
      • Cruising Lifestyle
      • International Cruising
      • Home Sweet Boat
      • Underway
      • Dinghy
      • Bahamas
      • Dogs & Cats
    • Living on a Boat
      • Home Sweet Boat
      • Organizing & Storing Stuff
      • Laundry
      • Batteries & Charging
      • Cleaning Inside & Out
      • Composting Toilet
      • Bugs
      • Trash
    • Food & Cooking
      • Galley Gear
      • Cooking on a Boat
      • Provisioning
      • Food Storage
      • Using a Boat Refrigerator
      • No Refrigerator? Read Here
      • No Oven? Bake on the Stove
      • Boat-Friendly Recipes
      • Cooking Tips
      • Dishwashing
    • Boat Work
      • Easy Boat Improvements
      • Projects – Repairs & Upgrades
      • Boat Maintenance
      • DIY Tips
      • Tools
      • Batteries & Charging
      • In the Boatyard
    • Problems & Concerns
      • Encouragement
      • Emergency Gear
      • Fire Aboard
      • Health
      • Hot Weather
      • Bugs
      • Galley Safety
      • Hurricane Prep
  • Podcasts
  • Cookbook
  • Store Food w/o Fridge book
  • Links
  • Newsletter

The Boat Galley

cooking & food • gear • boat life • DIY tips & projects • and more!

cooking & food • gear • boat life • DIY tips & projects • and more!
  • Preparing to Cruise
  • Buying a Boat
  • Cruising Stories
  • Food & Cooking
  • Boat Work
  • Checklists & Downloads
Downloadable .xls inventory and provisioning spreadsheet for cruisers and anyone else wanting groceries for a week or more

Downloadable Provisioning Spreadsheet

November 28, 2010 by Carolyn Shearlock

So, you’re heading out on your boat and you know it’s going to be a few weeks or more before you’ll hit another grocery store.  You want to make sure you have all the food you’ll want, but not too much of one thing.  And you already have some food on board, and you don’t want to duplicate it when you go to the supermarket.  What’s a sailor to do?

That’s exactly the situation this provisioning spreadsheet is designed for!

Although I call this a provisioning spreadsheet, it’s really a combination inventory and provisioning spreadsheet.  It is NOT intended to be a recommendation of what you need on any particular trip — that is up to you, what you like to eat, how many people are on board, and how long you’ll be gone.

This spreadsheet will allow you to decide what foods you want, how many units of each you use in an average week, let you inventory how many you already have on hand, and then it will calculate how many you need to buy.  Here’s a quick glance — you can download it at the bottom of this article:
Downloadable .xls inventory and provisioning spreadsheet for cruisers and anyone else wanting groceries for a week or more

It is set up so that you can sort it to print only the items you need, and have those items sorted by category — for example, all the “Baking” items you need will be grouped together so that when you’re in the baking aisle of the store, you’ll know ALL the things to put in the basket.  This makes shopping much more efficient. Don’t worry, I explain how to use these features in the instructions.

This is an Excel .xls spreadsheet — if you have some other spreadsheet program that will read an .xls file, this should also work, but no guarantees.

WHAT YOU GET: The formulas are already in the spreadsheet, and there is also a detailed instruction sheet in PDF format — be sure to download both.  You don’t need to be a spreadsheet wizard to use this!

Share502
Pin631
Email
Shares 1.1K

Filed Under: Food & Cooking Tagged With: Checklists & Downloads, Provisioning

Reader Interactions

Comments

  1. Edward Turner says

    December 1, 2010 at 5:51 pm

    been cooking for most of my life (40 yrs). learned some great tips in your site – thanks and keep living life to it’s fullest.

    Reply
  2. Steve Bryant says

    November 13, 2011 at 8:31 am

    First, I thank you for your blogging ability.

    I am looking at your provisioning spread sheet and I wonder what the “A” thru “D” entries are in columbs “I” thru “L” of row 5? I can read: “Enter amount(s) of item that are already on board” but why would you need B, C, & D entry positions? I will as this same question on your FB page. Thank you again!
    Steve

    Reply
    • Carolyn Shearlock says

      November 13, 2011 at 9:35 am

      Steve —

      Many times on a boat, you don’t store all of an item in one spot. For example, I had some flour in a locker right next to a galley counter, some under one settee, some under another and still more under the floor (some spaces were small, but also by splitting it up, if some got ruined it wouldn’t be my whole stock). This way, you can enter amounts each place that you find a particular item . . . or if it’s just in one place, just use one column!

      Hope that clears it up!

      -Carolyn

      Reply
  3. Michelle Beatty on Facebook says

    May 14, 2013 at 6:37 am

    Perfect!! Thanks

    Reply
  4. Marta Crichlow on Facebook says

    May 14, 2013 at 11:22 am

    Using it to provision for our trip to the Queen Charlotte Sound islands. It is a great tool! Recommend it!

    Reply
  5. c says

    May 15, 2013 at 3:59 pm

    now we need a spreadsheet with what clothing and equipment we need on the boat 🙂

    Reply
    • Danny Covington says

      May 27, 2013 at 7:14 am

      I think you can manipulate this one to do that. I haven’t tried but the cells may not be locked.

      Reply
  6. Danny Covington says

    May 27, 2013 at 7:13 am

    I can also use this for my End of The World supplies list.
    Thanks

    Reply
  7. Ellen Barrios says

    January 15, 2014 at 5:41 pm

    Wow, what a fantastic resource! Not sure if my retirement will find me living aboard a boat, an RV or on land, but the vast amount information I have found in your blogs has been quite helpful in planning for my multiple scenarios.

    I’m new to this site and found myself dreaming again–something that I gave up years ago! Thank you so much for sharing your wisdom and thank you to your readers who share theirs as well! Keep it coming!!

    Reply
  8. Diane Hallaways says

    February 6, 2014 at 1:23 pm

    I’ve used it on my cruising boat and now on the superyacht where I’m chef. Thank you.

    Reply
  9. Lenka Novoa says

    February 6, 2014 at 3:25 pm

    It’s a good template too, thanks

    Reply
  10. Ginny Teatro says

    February 6, 2014 at 4:09 pm

    Thanks for sharing!

    Reply
  11. Mary Brandt says

    March 10, 2015 at 4:25 pm

    Thank you for your template.

    Reply
  12. Karissa Coffey says

    February 10, 2016 at 9:07 pm

    Thank you for sharing all your tips! I love following your journey.

    Reply
  13. JP Pedro says

    February 10, 2016 at 9:19 pm

    Very usefull

    Reply
  14. Trevor says

    July 1, 2016 at 10:59 pm

    Thanks
    down in Oz we call some of the items different names but great checklist!

    Reply
  15. Pamela Dakin Harwood says

    May 11, 2017 at 1:31 am

    You and I eat very differently, however, I started with your spreadsheet and simply added and subtracted items to fit our needs. I like how you have laid yours out, alphabetized within categories — easy to check to see what is needed.

    Reply
    • The Boat Galley says

      May 11, 2017 at 1:42 am

      We don’t eat the way we did when I originally posted that spreadsheet — I change it some every time we provision for a trip 🙂 . . . but the whole idea is really to change it for what you want, and how much you eat, not specific items!!

      Reply
    • Pamela Dakin Harwood says

      May 11, 2017 at 1:46 am

      For those of us who have yet to embark, it is a great starting point. While we are in this rental until the boat splashes later this summer, I am using the utensils, and cooking implements that we will have on the boat, and cooking what we will be eating once we leave the dirt. Interesting to notice the changes in what I thought were essential ingredients and implements, but I continue to simplify, simplify, simplify. Of ANY website or blog, Hugh and I agree TBG has been the most useful!

      Reply
    • The Boat Galley says

      May 11, 2017 at 11:32 am

      Thanks so much!

      Reply
  16. Karen Matthews says

    May 11, 2017 at 3:30 am

    Great. about to set off on a 4 week trip around Indonisia, this will be a great help Thanks

    Reply
  17. Deb MacConnell says

    May 11, 2017 at 1:09 pm

    I use the app Out Of Milk, very easy
    Love this app.

    Reply
  18. Anonymous says

    March 8, 2018 at 9:12 pm

    Bridge Kellie Gorrow D’Urso you were just talking about this.

    Reply
    • Anonymous says

      March 8, 2018 at 9:17 pm

      YES!

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Welcome

Carolyn Shearlock

Hi! I'm Carolyn Shearlock. My husband and I have been cruising over 10 years and 10,000 miles, first on a Tayana 37 monohull and now on a 34' Gemini catamaran. Along the way, we sold pretty much everything we owned (twice!), gained a great boat dog, had a bunch of wonderful times and some adventures . . . and learned a ton about what does and doesn't work!

  • Facebook
  • Instagram
  • Pinterest

Stuff to know about


I’d like to learn about . . .

  • Preparing to Cruise
  • Buying a Boat & Gear
    • Buying a Boat
    • Boat Gear
    • Galley Gear
    • Personal Gear
    • Tools
    • Emergency Gear
    • Non-Electric Alternatives
    • Books & DVDs
  • Cruising & Chartering
    • Chartering
    • Cruising Stories
    • Skills for Cruising
    • Cruising Lifestyle
    • International Cruising
    • Home Sweet Boat
    • Underway
    • Dinghy
    • Bahamas
    • Dogs & Cats
  • Living on a Boat
    • Home Sweet Boat
    • Organizing & Storing Stuff
    • Laundry
    • Batteries & Charging
    • Cleaning Inside & Out
    • Composting Toilet
    • Bugs
    • Trash
  • Provisioning, Food Storage & Cooking
    • Galley Gear
    • Cooking on a Boat
    • Provisioning
    • Food Storage
    • Using a Boat Refrigerator
    • No Refrigerator? Read Here
    • No Oven? Bake on the Stove
    • Boat-Friendly Recipes
    • Cooking Tips
    • Dishwashing
  • Repairs, Maintenance & DIY
    • Easy Boat Improvements
    • Projects – Repairs & Upgrades
    • Boat Maintenance
    • DIY Tips
    • Tools
    • Batteries & Charging
    • In the Boatyard
  • Common Problems & Worries
    • Encouragement
    • Emergency Gear
    • Fire Aboard
    • Health
    • Hot Weather
    • Bugs
    • Galley Safety
    • Hurricane Prep
  • Cookbook
  • Store Food w/o Fridge book
  • Newsletter

Latest Articles & Podcasts

The Courage to Try Something New

The Courage to Try Something New

April 23, 2018 By Carolyn Shearlock

Cruising itself may be new, and it’s made up of all sorts of individual items that are going to be “something new” too. Preparing for the challenge of doing all sorts of new things. [More] The Courage to Try Something New

Using Propane on a Boat

Using Propane on a Boat

April 20, 2018 By Carolyn Shearlock

Do you know how to operate a propane stove? It’s not difficult, but it IS different. Learn the ins and outs before your first time cooking on one! [More] Using Propane on a Boat

Cruising with a Large Dog

Cruising with a Large Dog

April 18, 2018 By Carolyn Shearlock/Pamela Douglas Webster

Wondering how to go cruising with a big dog? What can you do to make it easier? Answers here from Pamela Douglas Webster, who cruises with Honey, a golden retriever. [More] Cruising with a Large Dog

A Day Aboard Totem

A Day Aboard Totem

April 17, 2018 By Nica Waters

Cruising days generally involve life – cooking, eating, adventuring, fixing things. See how one day played out for 9 people on board Totem. [More] A Day Aboard Totem

Affiliate Links

Amazon USAmazon CanadaWest MarineDistant Shores DVDsMantus AnchorsNatures HeadLunatec Gear Scrubrs and AquabotImage Map

Amazon and the Amazon logo are trademarks of Amazon.com, Inc. or its affiliates. Carolyn Shearlock (author of The Boat Galley) is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

Footer

TOP ARTICLES

  • Boat Shopping: An Overview
  • Boat Cooking IS Different
  • What I Needed to Know . . .
  • Dogs on Boats 101
  • Outboard Won’t Start 101
  • DIY Fuel Polishing

RESOURCES

  • Storing Food without Refrigeration ebook
  • The Boat Galley Cookbook
  • Hurricane Prep Checklist
  • Inventory & Provisioning Spreadsheet
  • Bahamas Checklist
  • Before Moving Boat Checklist

Newsletter

Advertising · About · Privacy · Contact · © 2010 - 2018 The Boat Galley/Carolyn Shearlock. All Rights Reserved.