What Square export file format does this tool accept?

This tool accepts Square Item Library CSV/Excel files. Export from Square and upload the CSV/Excel file directly.

Can I convert Square CSV to QuickBooks Product/Service?

Yes, this tool converts Square Item Library CSV/Excel exports directly to QuickBooks Product/Service Import format compatible with QuickBooks Product/Service.

How do I import Square item library to QuickBooks Product/Service?

Export your item library from Square, upload the CSV file to this converter, then import the converted file to QuickBooks Product/Service.

Square Items to QuickBooks Products

🥦

QuickBooks Product/Service Import Format

valid rows

Migrate your Square Item Library to QuickBooks Products/Services. Transfers item names, variations, SKUs, prices, and inventory.

Free preview — then from $5. Save with bundles.

Free preview before you pay

Files never leave your browser

No account needed to start

Download Sample

Sample item library CSV

Download Sample

How to Convert Square → QBO Products

Export from Square

Items & services → Items → Actions → Export Library → Export

Upload and Configure

Upload Item Library Export CSV and choose Products and Services Import format

Preview and Download

Review converted data, download Quickbooks Online-ready file

Import to QuickBooks Online

Settings ⚙️ → Import Data → Products and Services → Upload CSV

Output is in QuickBooks Product/Service Import format — ready to import directly, no manual reformatting needed.

Field Mapping

How Square Items fields map to Quickbooks Online Product Service

Square Items	Source Value		Quickbooks Online Product Service	Target Value	Note
`SKU`	`LAT-LRG-001`	→	`SKU`	`LAT-LRG-001`	Stock Keeping Unit
`Description`	`Our signature espresso drink`	→	`Sales Description`	`Our signature espresso drink`	Product description
`Category`	`Beverages > Hot Drinks`	→	`Category`	`Beverages > Hot Drinks`	Product category (use : for hierarchy)
`Price`	`4.50`	→	`Sales Price/Rate`	`4.50`	Selling price

Data Transformation

Each Square item/variation becomes one QuickBooks product/service

One row per item (variations create separate rows)

Key columns: Item Name, Variation, SKU, Price, Current Quantity

1:1 — One input row creates one output row

One inventory/non-inventory item per Square item

Product Record Item name with variation appended (e.g., 'T-Shirt:Blue')

Product/Service Name unique; SKU unique if present; Category uses colon separator

Why Use the Square → QBO Products Converter?

Variation Support

Square item variations become individual QuickBooks products.

SKU Preservation

Stock Keeping Units transferred for inventory tracking.

Price & Cost

Selling price and unit cost both transferred.

Category Hierarchy

Square category structure converted to QuickBooks format.

Inventory Levels

Optional: Import current stock quantities.

Duplicate Detection

Warns about duplicate SKUs before import.

Common Products and Services Import Errors

Issues you might encounter when importing Item Library Export data to Products and Services Import - and how we solve them

Duplicate Product Name

QBO requires unique product/service names

Name: 'T-Shirt' (already exists)

Name: 'T-Shirt:Blue' (with variation)

Variations are appended to create unique names

Use Item Name:Variation format

Duplicate SKU

QBO doesn't allow duplicate SKUs

SKU: 'ABC123' (duplicate)

SKU: 'ABC123-BLU' (unique)

Review and fix duplicate SKUs before import

The converter warns about duplicate SKUs

Category Hierarchy Format

QBO uses : to separate category levels

Category: 'Apparel > T-Shirts'

Category: 'Apparel:T-Shirts'

Square's > separator is converted to QBO's : format

Automatic conversion during import

Square → QBO Products Conversion Questions

How do I export the Item Library from Square?

Go to Square Dashboard → Items & Inventory → Item Library → Export. Choose Excel format for best results (CSV may convert SKUs to scientific notation).

How are variations handled?

Each variation becomes a separate QuickBooks product using 'Item Name:Variation' format. Enable 'Combine Variations' to use this format.

Should I import inventory?

Enable 'Import Inventory Quantities' to set initial stock levels. Products with quantities become Inventory type; others become Service type.

Why Square Items Don't Import Directly to QuickBooks

The Variation Structure Problem

Square organizes products with variations (Size, Color) as nested data structures. QuickBooks expects flat product records—one row per SKU. Without conversion, you'd lose variation details or create incomplete product records that don't match your actual inventory structure.

What This Tool Does

We flatten Square's item hierarchy into QuickBooks-compatible product records: - Each variation becomes a separate product with combined name (Item:Variation) - SKUs, prices, and costs transfer correctly - Category hierarchy converts from Square's > to QuickBooks' : format Your QuickBooks product catalog mirrors your Square item library exactly.

Your Square → QBO Products Conversion is Secure

Client-Side Conversion

No server round-trips. Your Square → QBO Products data is processed entirely in the browser tab.

Auto-Erased on Close

The moment you close the page, all Square → QBO Products data is wiped from browser memory. No traces left.

EU Privacy Standard

Meets GDPR requirements by design — no data processing on external servers, ever.

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Frequently Asked Questions

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.

Go to Square Dashboard → Items & Inventory → Item Library → Export. Choose Excel format for best results (CSV may convert SKUs to scientific notation).

Each variation becomes a separate QuickBooks product using 'Item Name:Variation' format. Enable 'Combine Variations' to use this format.

QuickBooks doesn't allow duplicate SKUs. The converter warns about duplicates so you can fix them before import.

Enable 'Import Inventory Quantities' to set initial stock levels. Products with quantities become Inventory type; others become Service type.

Square uses > for category hierarchy (Apparel > T-Shirts). QuickBooks uses : instead. We convert automatically.

When exporting from Square as CSV and importing to QuickBooks, product prices are included in the import. However, price updates must be made manually in both systems—pricing changes in one system don't automatically sync to the other.

Products with duplicate names, variations, or special characters may fail to import. Ensure each product has a unique name, check your CSV file for formatting issues, and verify the import file matches QuickBooks' requirements.

No, the integration is one-way. Price changes made in QuickBooks do not update Square automatically. You must update prices in Square first, then export and re-import to QuickBooks if needed.

Sync with Square is retired and Connect to Square is being phased out. The current recommended solution is Square Connector by Intuit, which offers better compatibility, direct support, and more reliable product syncing with QuickBooks.

Square variations can't be imported directly into QuickBooks. Export your base items without variation details, then manually create separate items in QuickBooks for each variation if needed, or use the base product name.