Our Square item library had duplicate modifiers with slightly different names — 'Extra Cheese' vs 'Extra cheese' vs 'EXTRA CHEESE'. The validator flagged all 34 near-duplicates so we could consolidate before syncing to our inventory system. Would have been a nightmare to untangle after import.
Square Item Library CSV Validator
or drop files here .csv, .xls, .xlsx, .xlsm (up to 50 MB)
Free 5-row preview · No sign-up required
Invoice import blocked if Sales Tax enabled in QBO
Validate Complete
Your converted file is ready!
Download now before closing this page
Validation Report Format
Showing valid rows only (download includes all rows + errors)
All rows valid
| $ |
|---|
+ more rows
valid rows
invalid rows skipped from preview
credits
| Row | Column | Value | Error |
|---|---|---|---|
Showing first 50 errors. more errors not shown.
more errors hidden. Download the full validation report to see all errors.
Validation Report Download
The download includes your original file with an added "Validation Error" column showing error messages for each row. Valid rows have an empty error column.
• credits
Use credits to download
Click any download button to use your credits
- Full CSV & Excel export
- Google Sheets export
- Instant browser download
for credits
One-time payment
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle
Want to save on credits?
Buy bundles and get up to 27% off. Perfect for recurring monthly conversions.
Liked the preview?
Upload your actual file to get the real conversion
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
Square Products Validation Questions
What columns are required?
Only Item Name is required (max 128 characters).
Is the Square Products validator free?
You can preview Square Products validation results for free — no signup needed. Full validation reports use credits based on row 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 Square Products 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.
How People Use Square Products
Half our prices exported as '$12.50' and the other half as '12.5' — no dollar sign, no trailing zero. The validator caught every currency formatting inconsistency in one pass. We fixed the 380 misformatted rows before re-importing and avoided a day of manual price corrections.
I ran our Square item library through the validator and it flagged 62 rows missing the required Item Name field — they were variation rows that got detached from their parent items during an earlier bulk edit. Without that completeness check I would have imported 62 orphan SKUs with no product names.
Why Validate Square Products Before Import?
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.
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 Square Products Data Stays Private
Browser-Only Processing
All validation runs in your browser. Files are never uploaded to any server.
No Data Retention
Nothing is stored after validation. Close the tab and your data is gone.
GDPR Compliant
Full EU data protection compliance. Your privacy rights are fully protected.
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.
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.
Only Item Name is required (max 128 characters).
Excel format preserves SKUs with leading zeros better. CSV may convert them to scientific notation.
You can preview Square Products validation results for free — no signup needed. Full validation reports use credits based on row 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.
After Validation: Convert Your Item Library Export
Once your Square export passes validation, convert it to your accounting format
Learn More:
🥦
Quick question before you go
Help us improve—what stopped you today?
🎉
Thank you!
Enter your email to claim your welcome bonus