How to Import a Menu into Square POS (Catalog Import Guide)
Retyping a menu into Square item by item, sizes and modifiers included, eats an afternoon fast. Square's catalog import handles the bulk of it in one upload, but the spreadsheet has its own rules, and a wrong header or a stray token can duplicate half your menu instead of updating it. Here's where the import lives, what the columns actually do, and where it goes wrong.
Where is the menu import option in Square?
- Log into the Square Dashboard from a computer at squareup.com/dashboard, not the Square Point of Sale app on a device.
- Go to Items (sometimes listed as Items & Orders, depending on your account).
- Click Actions near the top right of the item list.
- Select Import. Square offers a spreadsheet template you can download, either blank or pre-filled with your current catalog if you export first.
Exporting your existing catalog before you import is worth doing even for a brand new menu, because it shows you the exact column headers and formatting Square expects for your account.
What do you need to plan before filling in the spreadsheet?
- Item and variation structure. Square groups any rows that share the same Item Name into variations of one item, like sizes. Decide this before you start typing rows, because restructuring afterward means moving data around.
- Categories you want items sorted into, created ahead of time or added directly through the import.
- Modifier sets you plan to reuse across multiple items, like a topping list that applies to every pizza.
- A decision on whether this is a first-time import (no tokens) or an update to an existing catalog (tokens required to avoid duplicates).
Step by step: importing a menu into Square
- Plan your item and variation structure before opening the spreadsheet.
- Set up categories and modifier sets you already know you need.
- Download the import template from Items, Actions, Import.
- Fill in one row per item variation, repeating the Item Name across rows that are variations of the same item.
- Add modifier sets in their columns, listing modifier names and any price changes for each.
- Save the file in the format Square expects, and check price cells for stray currency symbols.
- Upload through Items, Actions, Import.
- Review the changes summary Square shows before you confirm. It lists what's new, what's updated, and what's unchanged.
- Confirm the import, then check that items are enabled for the right locations and appear correctly on the register.
What columns matter most in the Square catalog spreadsheet?
| Column | What it does | Watch for |
|---|---|---|
| Token | Internal ID Square uses to match a row to an existing item. | Leave blank to create a new item. Include an existing token to update that exact item instead of duplicating it. |
| Item Name | Groups variation rows together. | Rows sharing the same Item Name become size or variant options under one item. |
| Variation Name | Labels the specific size or version, like Small or Large. | Required once an item has more than one variation. |
| SKU | Optional, used for tracking and barcode scanning. | Keep it unique per variation. |
| Price | The sell price for that variation. | Plain decimal, no dollar sign. |
| Category | Where the item sorts on the register. | Matches or creates a category by exact name. |
| Modifier Set columns | One column per modifier set, listing the individual modifiers and any price add-on inside the cell. | Keep the modifier set name identical across every item that uses it, or Square treats it as a second, separate set. |
| Enabled Locations | Controls which of your locations can sell the item. | An item that imports fine but isn't enabled for a location simply won't show up there at the register. |
Common errors when importing a Square catalog
- Leaving Token blank on an item you meant to update. Square creates a brand new item instead of updating the old one, and now the catalog has two versions of the same burger.
- Forgetting to repeat the Item Name across variation rows. Each size ends up as its own separate item instead of nesting under one.
- Price typed with a dollar sign. Fails the row or imports as an unreadable value.
- Modifier set name spelled slightly differently across items. "Toppings" on one row and "Pizza Toppings" on another creates two sets instead of one shared list.
- Items not enabled for the right location. Common with multi-location accounts, the import succeeds but the item is invisible at the register until location settings are fixed.
- Category and reporting category confusion. Square distinguishes the two in some account setups, and mixing them up puts items in the wrong place on the register or in reports.
- Oversized files. Very large catalogs are safer split into a few smaller batches, checked one at a time.
- Wrong file format. Square's importer expects a specific file type, and a CSV saved with the wrong encoding can scramble special characters like accented letters.
How do you confirm the import actually landed correctly?
After confirming, open the live item list and check ten to fifteen items across different categories, including at least one item with variations and one with a modifier set. Then pull those same items up on the actual register or the Square Point of Sale app to confirm the price, the variations, and the modifiers all show the way you expect, for every location that should be selling them.
Skip building the spreadsheet by hand
MenuProof reads a photo or PDF of your menu and builds a Square catalog import file for you, modifier sets included, with a preview of the parsed menu before you export anything. You still export the file and run the import yourself, MenuProof never touches your live Square account. Square support is currently in beta.
First menu is free, no card required. Packs start at $49 after that.
Convert your Square menu freeSee the full Square menu import page or the MenuProof homepage for pricing and details.
FAQ
Where is the menu import option in Square?
Log into the Square Dashboard on a computer, go to Items, then click Actions near the top of the item list, then Import. Square gives you a spreadsheet template to fill in and upload from there.
How do I add sizes or variations to a Square item?
Use the same Item Name on multiple rows, with a different Variation Name, SKU, and price on each row. Square groups rows that share an Item Name into variations of one item automatically.
Will re-importing update my existing items or create duplicates?
It depends on the Token column. Export your current catalog first to get the tokens for existing items, then include those tokens in your file to update them. Leaving Token blank on an existing item usually creates a new, duplicate item instead of updating it.
Can I import modifier sets directly, or do they need to exist first?
Square's import file has columns for modifier sets and can create new sets from the file itself. You still need to be careful with naming, since a slightly different modifier set name across rows can create two sets instead of one shared set.
Is there a faster way to build the Square import file?
Yes. MenuProof reads a photo or PDF of your menu and builds a Square catalog import file, including modifier sets, with a preview before you export. Square support is currently in beta. First menu is free, no card required, packs start at $49. Try it free.