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:

It it 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.
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. 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!
I’m giving this away free — but I have a favor to request of you. To help spread the word about The Boat Galley, please “share” this website/article with others.
At the bottom of this post, you can:
- Recommend it on Facebook
- Tweet on Twitter
- Pin It with Pinterest
Or you can go old school and just e-mail a link to friends . . .
No, you don’t have to — I’m not checking up on you. But cruisers are all about helping each other out — that’s what we do. Lots of people helped Dave and I when we began cruising and this web site is my way of paying it forward. If you could help me let others know about this site, I’d appreciate it.
By the way, if you heard about this spreadsheet and came directly here for it, I’d like to welcome you to The Boat Galley! While you’re here, why don’t you take a look at some of the other articles?
Be sure to actually SAVE these files to your computer or thumb drive — an easy way to do this is to RIGHT click on the link, then click on “Save Link As” and put it in the appropriate place.
Download the Provisioning Spreadsheet (.xls)
Download the Provisioning Spreadsheet Instructions (PDF)
And if you want to get more from The Boat Galley, you can join the Facebook page (click “Like” below) or sign up for the newsletter.

The one comprehensive galley reference needed aboard every boat







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.
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
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
Perfect!! Thanks
Using it to provision for our trip to the Queen Charlotte Sound islands. It is a great tool! Recommend it!
now we need a spreadsheet with what clothing and equipment we need on the boat
I think you can manipulate this one to do that. I haven’t tried but the cells may not be locked.
I can also use this for my End of The World supplies list.
Thanks