Square catalog → QuickBooks Online · Products & Services CSV
Your Square items export, made importable.
QuickBooks rejects Square catalog exports because item variations create duplicate names, colons hijack the category format, and "variable" prices break the price column. This tool fixes all of it and hands you a clean, import-ready CSV. Your file never leaves your browser.
● 100% client-side — nothing is uploaded, stored, or seen by anyone but you
These fill the QuickBooks columns Square doesn't have. You can remap anything during QuickBooks' own import step.
Unlock the full converted file
Preview shows the first 10 rows. One payment unlocks downloads for this file and every file you convert — forever, on this device or any other, with your unlock code.
The four ways Square exports break QuickBooks imports
Each of these is a real rejection you'd otherwise fix by hand, row by row, in a spreadsheet.
Variation name collisions
Square exports every variation as its own row sharing one item name. QuickBooks requires unique names — and no longer supports variants at all. We merge item + variation into one unique name, and resolve any remaining collisions using the SKU.
Colon hijacking
QuickBooks reads colons as category separators ("Flowers:Roses"). An item called "Coffee: House Blend" silently becomes a sub-item of "Coffee". We sanitize colons in names and categories.
"Variable" prices
Square exports variable-priced items with the literal word "variable", which QuickBooks can't parse. We blank those prices (flagged in the journal so you can set them later) and normalize "$1,250.00" formatting.
Limits & ghost rows
Names over QuickBooks' 100-character limit get truncated, and empty filler rows in the export are dropped instead of importing as blank items.
How it works
No signup, no API connection, no access to your Square or QuickBooks account. It's a file in, a file out.
Export from Square
Square Dashboard → Items & services → Actions → Export library. You'll get a CSV of your full catalog.
Convert here
Drop the CSV above. Conversion runs locally in your browser using JavaScript — we never receive your file. Review the preview and the repair journal.
Import to QuickBooks
QuickBooks Online → Settings ⚙ → Import data → Products and Services. Upload the downloaded CSV and confirm the column mapping.
Questions bookkeepers ask
Why does my Square CSV fail to import into QuickBooks Online?
The most common cause is duplicate Product/Service names. Square exports each item variation (Small, Medium, Large…) as a separate row with the same item name, and QuickBooks requires every name to be unique. Colons in item names, the word "variable" in the price column, and names over 100 characters are the other usual culprits. This tool repairs all four.
Is my catalog data uploaded anywhere?
No. The conversion runs entirely in your browser using client-side JavaScript. You can disconnect from the internet after the page loads and it still works. Nothing is transmitted, logged, or stored.
What does the output look like?
A CSV with the columns QuickBooks Online expects for a Products and Services import: Product/Service Name, SKU, Type, Category, Sales Description, Sales Price / Rate, and Income Account. During import, QuickBooks lets you confirm or remap each column.
Will this sync ongoing sales between Square and QuickBooks?
No — this is a one-time catalog converter, not a sync service. If you want daily automated syncing you need a subscription connector. If you just need your item list inside QuickBooks (the most common case for a new client cleanup), this does that without a monthly fee.
What if my export has columns this tool doesn't recognize?
Square includes per-location stock and tax columns that QuickBooks' item import doesn't use; those are ignored safely. If the tool can't find an "Item Name" column at all, it will tell you rather than guess.
Do you offer refunds?
Yes — if the converted file doesn't import, reply to your receipt email and you'll get a full refund. The free preview exists so you can verify the output before paying.
Guides
Plain-English fixes for the errors that send people here. Each one explains the manual repair, whether or not you use the converter.
- Fix "The name supplied already exists" on QuickBooks imports
- Square items CSV won't import into QuickBooks Online: all four causes
- Import Square products into QuickBooks without a sync subscription
- QuickBooks Online removed product variants — what Square sellers should do
- The word "variable" in your Square export breaks the price column