Square Item Library CSV Validator

🥦

Validate Complete

Validation Report Format
valid rows

Check your Square item library CSV export for missing columns and data format issues.

Free preview — then from $5. Save with bundles.
Free preview before you pay
Files never leave your browser
No account needed to start

Download Clean Sample

Valid Square item library export (no errors)

Clean Template

Download Error Sample

Sample with validation errors for testing

Error Example

Validation Questions Answered

What columns are required?

Only Item Name is required (max 128 characters).

Is this tool free?

First transactions are free to preview. Full conversions use credits based on transaction count.

What file formats does Square accept?

Square accepts .xlsx (Excel) and .csv formats only. Files saved as .xls, .xlsm, or other formats will not import.

How Validation Works

1

Export from Square

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

2

Upload CSV

Upload your Item Library Export export file

3

Review Validation Results

Check your Square data for errors and warnings

Issues are flagged inline with clear fix suggestions — review and correct before you import.

Why Validate Item Library?

Product Catalog Integrity

Item Library imports fail when required columns are missing. Item Name is required and has a 128 character limit.

What This Tool Checks

We validate your Square item library export: - Required columns present (Item Name) - SKU and price formats valid - Inventory quantities are integers

Your Data Stays Private During Validation

Every Row Checked

Each record is validated against format rules. Catch errors before they reach your platform.

Runs in Your Browser

Validation happens locally. Your data never leaves your browser.

GDPR Compliant

No files uploaded, no data retained. Full EU privacy compliance.

Why Validate Before Importing?

Name Validation

Checks for required Item Name column (max 128 characters).

Variation Checking

Validates Variation Name and SKU columns.

Price Validation

Validates Price and Unit Cost currency columns.

Inventory Checking

Validates Current Quantity, New Quantity, and Stock Alert columns.

Browser-Based

Files processed locally. Your data never leaves your computer.

Instant Results

Get validation results in seconds, even for large files.

Common Target Import Errors

Issues you might encounter when importing Source data to Target - and how we solve them

Missing Item Name

The 'Item Name' column is required but empty

(blank Item Name)
Latte

Every catalog item must have a name

Check for blank items in Square item library

Missing Variation Name

The 'Variation Name' column is required but empty

(blank Variation Name)
Large

Every item variant needs a variation name

Square requires at least one variation per item

Invalid Price Format

The 'Price' column contains non-numeric values

varies or TBD
4.50

Price must be numeric (blank for variable pricing)

Check for formatting issues in Square item library

Duplicate SKU

The same SKU appears on multiple items/variations

SKU 'ABC123' on two different items
Each item should have unique SKU

SKUs must be unique across your catalog

Review duplicates in Square item library

More credits - more savings

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

// PRICING //

Choose the plan that fits your needs

5,381 reviews, Excellent
Pay as you go

Just start processing on any tool page

$1/credit

Tools processing starts from 5 credits. Then 1 credit = 1k rows. No sign-up needed.

OR

Credit Bundles

$ /Credit

One-time purchase

  • No monthly commitment
  • Credits valid for one year
  • Access to all tools
  • Full file downloads

Monthly Bundles Pro

$ /Credit

Best for professionals and content creators

Annual Discount
Per month, billed annually:
Save 20% more
  • Credits refresh monthly
  • Priority processing

Purchase Credits

  • Full CSV & Excel export
  • Google Sheets export
  • Instant browser download
for credits

Visa Mastercard PayPal Apple Pay Google Pay
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle

Do unused credits expire?

One-time credit bundles are valid for one year. Subscription credits refresh monthly. You can use credits across any tool, anytime.

Is my data secure?

Files process entirely in your browser. We're GDPR compliant with TLS encryption.

Can I get a refund?

Yes! Full refund within 14 days if no credits used. Partial refund for unused credits anytime. Contact sup@spreadsheetbroccoli.com.

Powered by Paddle

Terms of service applies. VAT included where applicable.

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.
No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.
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.
Only Item Name is required (max 128 characters).
Excel format preserves SKUs with leading zeros better. CSV may convert them to scientific notation.
First transactions are free to preview. Full conversions use credits based on transaction count.
Yes. Use filters in your Item Library to display only the items you want, then export—only visible items are included in the export.
Select the SKU or price column, right-click Format Cells, choose Number, and set decimal places to 0 to fix scientific notation errors.
Prices must be formatted as numbers (e.g., 5.00) not currency (e.g., $5.00). Ensure the price column is set to numeric format.
Remove commas before importing. You can add them back to item names, descriptions, and modifiers after successful import.
Square accepts .xlsx (Excel) and .csv formats only. Files saved as .xls, .xlsm, or other formats will not import.
Yes. All variations of an item must have the same category and description as the parent item to pass validation.
GTIN codes must be exactly 8, 12, 13, or 14 digits with only numbers 0-9—no special characters or letters allowed.