How to import a menu into Square's item library
Updated November 12, 2026 · 7 min read
Square's item library import is solid for retail-style catalogs. Restaurant menus are harder, because most of what makes a menu a menu (sizes, add-ons, "choose one") lives in variations and modifier sets. Here's how the sheet is laid out and the order that avoids a re-do.
Step 1: Get the template from the account
In the Square Dashboard go to Items & services → Items → Actions → Import library and download the template, or export the current library. Square says not to reorder, rename or delete columns, and the exact columns vary by account (locations, features, template version). So always start from the target account's own file. Square recommends the .xlsx version.
Step 2: One row per variation
Square groups rows into items by Item Name. A drink with two sizes is two rows with the same Item Name and different Variation Name values:
| Item Name | Variation Name | Price | Categories |
|---|---|---|---|
| Latte | 12oz | 4.75 | Coffee |
| Latte | 16oz | 5.50 | Coffee |
| Cold Brew | Regular | 4.50 | Coffee |
- Single-price items still need a variation name. "Regular" is the convention.
- Prices are plain dollars, no $ sign. Use Variable (or leave blank) for market price.
- Item-level fields like description and category must match on every row of the same item.
- Leave the Token column blank for new items. Square fills it in.
Step 3: Create modifier sets before you import
This is the part that catches people. The sheet has a Modifier Set - Name column for each modifier set in the account, and you put Y or N to switch it on for an item. But the import can't create a modifier set, its options, prices, or the min/max rules. If the set doesn't exist, there's no column for it.
- List every modifier set on the menu: name, options, option prices, and the rule ("choose 1", "up to 3").
- Create each one in Items → Modifiers with the exact name.
- Download a fresh template. The new sets now appear as columns.
- Mark Y for each item that uses each set.
Taxes work the same way: a Tax - Name (rate%) column per tax that exists in the account. Keep the header exactly as Square writes it.
Step 4: Import
Back in Actions → Import library, upload the file and pick Modify library (add/update) or Replace library (fresh account). Square previews the changes and keeps the good rows if some fail, with an error report you can download.
Gotchas
- Two different items with the same name merge into one item with extra variations. Make names unique ("Burrito - Breakfast").
- Don't open a CSV with SKUs directly in a spreadsheet app. It can strip leading zeros. Import it as text, or use .xlsx.
- Nested modifiers have to be set up in the Dashboard after import.
- No images in the sheet. Add photos in the Dashboard.
What about Square's free menu upload?
Square also offers to build a menu from a photo, PDF or URL. It only builds Square menus, and Square says most builds take under 24 hours. If that works for you, use it. If you need it in minutes, want to check it yourself first, or you're moving the menu to or from another POS, that's what we built.
The fast way
Upload menu photos, a PDF, a spreadsheet or another POS's export to Fast POS Menu. It builds the variations and modifier sets, then gives you two things: the item library sheet, and a checklist of exactly which modifier sets to create first (names, options, prices, min/max). Create the sets, import the sheet, done.
Moving a merchant onto Square from Toast? Read Toast to Square without retyping.
Menu labels and import rules are as of the date above and can change. Square, Clover and Toast are trademarks of their respective owners. Fast POS Menu is independent and not affiliated with or endorsed by them. Our import files are in beta while we confirm them against real accounts.