Inventory Spreadsheet Template for Google Sheets: Guide

Yes. You can make an inventory spreadsheet template in Google Sheets by creating columns for each item’s identifier, description, quantity, reorder level, and cost, then adding formulas for stock value and reorder alerts. Open Google Sheets in a web browser, start a blank spreadsheet or adapt a suitable template, and use the setup below as a practical starting point.

What an inventory spreadsheet should track

An inventory sheet is a shared record of what you have, where it is, and when you may need to replenish it. The right columns depend on the work: a shop may need selling prices and suppliers, while a small office may mainly need quantities and storage locations. Start with the information you will actually maintain; a long list of unused fields makes updates harder.

A useful general-purpose layout is:

SKU: A unique stock-keeping code for each item. A consistent code helps distinguish similar products.
Item name and category: A plain-language description and a broad group, such as office supplies or beverages.
Location: The shelf, room, bin, or site where the item is stored.
Quantity on hand: The current count, in a clearly understood unit such as each, box, or kilogram.
Reorder level: The quantity at or below which someone should review whether to buy more.
Unit cost and inventory value: Cost information and a calculated estimate of the value represented by the counted stock.
Supplier and last-counted date: Details that help with purchasing and show how recently the figure was checked.

For example, a row might describe SKU MUG-01, ceramic mug, kitchenware, shelf A3, 8 on hand, reorder level 10, and unit cost $3.50. Naming units matters: recording “4” without saying whether it means four individual items or four cartons can create a costly misunderstanding.

How to create the template in Google Sheets

Go to sheets.google.com in a browser and choose a blank spreadsheet, or open a relevant starting point from the Google Sheets template gallery if one is available to you. Gallery choices can vary; you do not need a special inventory template to build a useful tracker. Rename the spreadsheet and its first sheet tab so collaborators can identify it.

Put the column names in row 1. For a simple tracker, use SKU, Item, Category, Location, Qty on hand, Reorder level, Unit cost, Inventory value, Supplier, Last counted, and Status.
Enter one item per row, beginning in row 2. Keep each field in its own column rather than placing several details in one cell.
Use one consistent format for identifiers, dates, units, and currency. For example, use a date format for the last-counted column and currency formatting for unit cost and inventory value.
Make the header easy to keep in view by choosing View > Freeze > 1 row. This is useful when scrolling through a long list.
Turn on filters with Data > Create a filter. The filter controls let a user display a category, location, or low-stock subset without deleting other rows.

Use a unique SKU where practical, and do not rely on row position as an item’s identity. Sorting or inserting rows changes positions. A stable identifier makes it easier to reconcile counts and spot duplicate records.

Formulas for stock value and reorder status

Formulas can reduce repeated arithmetic, but they are only as dependable as the quantities and costs entered. The examples below assume the column layout listed above, with headers in row 1 and inventory records beginning in row 2. Enter each formula in the indicated cell on row 2, then copy it down for other item rows.

With quantity on hand in E2 and unit cost in G2, enter this in H2 to calculate the row’s inventory value while leaving the result blank if either input is missing: =IF(OR(E2="",G2=""),"",E2*G2). For the example of 8 mugs at $3.50 each, the result is $28.00. This is a simple quantity-times-cost estimate, not necessarily an accounting valuation method.

With the SKU in A2, quantity in E2, and reorder level in F2, enter this in K2 to flag items at or below their reorder level: =IF(A2="","",IF(E2<=F2,"Reorder","In stock")). If the row is the mug example, 8 is less than or equal to 10, so the displayed status is Reorder. If stock rises to 12, the status becomes In stock. The label is a prompt for review, not an automatically placed order.

With inventory values in H2:H100 and only the mug example populated, enter this in a summary cell to total the listed values: =SUM(H2:H100). The result is $28.00 when that is the only numeric value in the range. Expand the range if your list grows beyond row 100, or choose a suitably generous range at the outset.

In Google Sheets, formulas generally use commas between function arguments in the examples above. Spreadsheet locale settings can affect number, date, and formula conventions, so a file configured for a different locale may display values differently. Check the sheet’s settings and test formulas with a small sample before relying on a copied template.

Dropdowns, formatting, and low-stock alerts

Consistent entries make filtering and summaries more useful. For a category or location column, use Data > Data validation to create a dropdown list of approved choices. This can prevent variations such as “Warehouse,” “warehouse,” and “WH” from being treated as separate locations. The available validation options can depend on the selected range and interface updates, so review the rule shown in the side panel.

To make low stock easier to notice, select the relevant quantity or status cells and choose Format > Conditional formatting. You can apply a color rule to a status that equals Reorder, or create a numeric rule for quantities at or below the reorder threshold. Conditional formatting changes how cells look; it does not change the underlying quantity or notify a supplier by itself. Keep a written explanation of color meanings if several people use the sheet.

Filters help answer practical questions such as “Which items at the north site are below their reorder levels?” They do not create a separate, automatically synchronized inventory system. A filtered row remains part of the same sheet, and users should be careful not to overwrite a formula while editing nearby cells.

A reliable routine for updating counts

A template is only useful if its records reflect reality. Decide who updates it, when counts happen, and how stock movements are recorded. For a small supply closet, a periodic physical count may be enough. A busy stockroom may need a more frequent routine and a separate record of receipts, sales, transfers, and damaged goods.

Before counting, agree on the unit and location for each item. Separate open cartons from sealed cartons if they are counted differently.
Count the physical stock, then compare the result with the sheet. Investigate discrepancies rather than silently changing a number when the cause matters.
Record the count date and, if useful, the person responsible. These details make stale figures easier to identify.
Update quantities after receiving, using, selling, or transferring items. If changes are frequent, record the movement and date instead of relying only on occasional balance edits.
Review reorder levels periodically. A threshold that made sense before a change in delivery time or demand may no longer be suitable.

For instance, if a sheet says there are 20 printer cartridges but a physical count finds 17, possible causes include unrecorded use, a receiving error, or a mistaken earlier count. Recording the verified balance may fix the immediate figure, but checking the cause can prevent the same discrepancy from recurring.

Choosing a template and adapting it

Before adopting a downloaded or shared template, inspect its columns, formulas, and any hidden sheets. Confirm that formulas reference the intended columns and that sample data has been removed or clearly marked. A visually polished template can still be a poor fit if its units, workflow, or stock definitions do not match yours.

Consider these questions when choosing or adapting one:

Does it identify each item uniquely, and can the same product be stored in more than one location?
Can users enter new items without breaking formulas or formatting?
Are cost and quantity fields clearly distinguished from selling price and available-to-promise stock?
Does the template make it possible to find low stock, old counts, and items by category or location?
Can the people who need to edit it access the file, and is there a clear owner for corrections?

Be cautious about adding elaborate calculations before the basic process works. A reorder threshold is not the same thing as a forecast, and the simple value formula above does not account for returns, discounts, freight, or accounting rules. If the sheet informs formal financial reporting or purchasing commitments, confirm the method and source data with the appropriate professional or process owner.

Google Sheets compared with Excel and dedicated inventory tools

Google Sheets is a spreadsheet application that runs in a web browser and supports sharing and simultaneous collaboration. That can suit a small team that needs a straightforward shared list. Microsoft Excel can also handle inventory tables and formulas; it is often a better fit when an organization already works in Microsoft 365 or depends on Excel-specific workflows. The precise collaboration, storage, and administration features depend on the services and account settings in use.

Neither spreadsheet automatically provides the controls of a dedicated inventory management system. A spreadsheet generally needs people to maintain its records and formulas, while specialized systems may offer purpose-built functions such as transaction histories, barcode workflows, permissions, or connections to sales channels, depending on the product and plan. Those capabilities should be checked before choosing a system rather than assumed from its label.

A spreadsheet may be enough for a modest, low-complexity stock list. Consider a more specialized tool when multiple people make frequent stock changes, several locations need synchronized balances, traceability is important, or manual reconciliation is consuming too much time. Moving systems also takes planning: clean item identifiers and consistent units make later migration easier.

Sharing, privacy, and backup considerations

Inventory data can reveal purchasing patterns, supplier relationships, or the contents of a workplace. Share the spreadsheet only with people who need access, and review permissions rather than assuming that a link should be open to anyone. Google Sheets sharing controls allow an owner to grant different levels of access, but the available organization-wide options can depend on account administration settings.

Protect formula cells from accidental edits where appropriate, and explain which cells people should change. Protection helps reduce mistakes but should not be treated as a substitute for access control or a secure record system. Avoid putting passwords, payment-card information, or other sensitive data into a general stock tracker.

For important records, establish a backup and recovery practice that fits the organization’s needs. Version history can help review or restore earlier changes, but users should understand who owns the file and what happens if that account is unavailable. Keep a separate copy or follow the organization’s approved storage policy when the inventory is business-critical.

Frequently Asked Questions

Does Google Sheets have a free inventory template?
Google Sheets has a template gallery, but the templates available can vary, and there may not be a built-in inventory template that matches your needs. You can create one from a blank sheet using item, quantity, location, and reorder columns, or adapt a suitable template after checking its formulas and fields.

How do I make a low-stock alert in Google Sheets?
Add a reorder-level column and a status formula that compares the current quantity with that threshold. You can also use Format > Conditional formatting to highlight low-stock rows. This creates an on-sheet visual flag, not an email alert or automatic purchase order.

Can multiple people update an inventory spreadsheet at once?
Google Sheets supports collaborative editing when a file is shared with the relevant users. Give each person only the access they need, agree on which fields they may edit, and use protected ranges for formulas if accidental changes are a concern.

Is Google Sheets enough for a small business inventory?
It can be adequate for a simple list with manageable update frequency and limited workflow requirements. If you need detailed movement histories, barcode processes, multiple synchronized locations, or stronger operational controls, compare dedicated inventory tools and verify their specific features.

How often should I count inventory?
There is no single frequency that suits every item or organization. Set a schedule based on how quickly stock changes, how costly an error would be, and how much time counting requires. Record count dates and investigate material differences between the sheet and physical stock.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.