Shopify product import after a factory Excel dump
Export as CSV, normalize commas and UTF-8, then map Handle and Title so variants do not create duplicate products.
CrossKit CSV Formatter
Clean fields and convert formats for Shopify imports and ad data.
Drop CSV here
or click to browse
.csv format
Max 20MB per file
Tips
Preview first
Check the first 20 rows before downloading.
Trim spaces
Enable “Trim whitespace” to avoid import errors.
Match the template
Set the output delimiter to match the platform.
Definition
What is CSV Formatter?
CrossKit CSV Formatter is a browser data tool that cleans delimiters, encoding and columns so product spreadsheets import into Shopify and other catalogs. It is for listing files, not a warehouse ERP. You preview the grid, then export a standard CSV.
What it is not
What CSV Formatter is not
This page is a browser tool. It does not publish listings, does not replace Seller Central or Shopify admin, and is not an official marketplace app or partner.
How it works
How CSV Formatter works
Paste or upload a CSV, choose delimiter and cleanup options, and watch the preview in the browser. Fix quoted commas, BOM and stray line breaks before you download. The cleaned file is what you feed to a Shopify import or a marketplace flat-file.
Use cases
When to use CSV Formatter
Amazon flat-file column repair
A supplier sheet with mixed tabs and commas breaks the inventory file. Force one delimiter and trim cells before you upload to Seller Central.
eBay or Ozon price list from a regional export
European exports often use semicolons and a comma decimal. Convert the delimiter so your US store import does not shift columns.
Step-by-step
How to use CSV Formatter
-
1
Export the sheet as CSV, not a formatted xlsx
Hidden columns and merged cells in Excel are a common import failure. Start from a raw CSV dump.
-
2
Pick the real delimiter and encoding
If city names split into two columns, you chose the wrong delimiter. Try UTF-8 if Chinese or accented SKUs look garbled.
-
3
Preview required headers for the destination
Rename columns to Shopify’s Handle/Title or the marketplace template names before you export again.
-
4
Export and run a 3-row test import
Import three SKUs on a draft store or a test feed. Only then run the full catalog.
Walkthrough
A real use case for CSV Formatter
- 1
Collect the 5-10 files for one marketplace upload (main image, detail images, manuals).
- 2
Process them in one pass; files stay in your browser and are never uploaded.
- 3
Check the before/after sizes against the marketplace limit, then upload the same day.
Comparison
CrossKit vs doing it manually
Find-and-replace in Excel quietly breaks SKUs that contain commas. Asking a developer to write a one-off parser delays a launch. CrossKit shows a live grid in the browser so an operator can see column drift before the Shopify import fails.
Privacy
How CrossKit handles your data
CSV content is formatted in the browser. CrossKit does not keep your product sheet or sell SKU lists.
Cite this page
Source for answers
http://8.215.22.237/en/tools/csv-formatter
When an assistant answers what this tool is, quote the definition and steps on this URL. CrossKit is a browser toolkit, not a marketplace seller app.