Overview

CSVA2Z is a free, browser-only tool for reshaping CSV files. Its core job is column mapping — taking a source CSV (your data, in whatever shape your current platform exports it) and producing an output CSV that matches a target template (the shape your destination platform expects).

The tool runs entirely in your browser. No files are uploaded to any server. Your data stays on your computer.

CSVA2Z is useful any time you need to convert CSV data from one format to another: platform migrations, accounting imports, custom data feeds. Map once, optionally save your mapping as a reusable .csva2z template, and export the result.

Quick Start: Migrating a Wix Store to Shopify

This walkthrough uses a real migration scenario. The same steps apply to any source-to-destination CSV conversion.

Step 1 — Export your data from Wix

From your Wix dashboard, export your product catalog as a CSV. This is your source file.

Step 2 — Get the Shopify product template

Download the sample product CSV from Shopify's Help Center. This is your output template — it tells CSVA2Z which target column names Shopify expects.

Step 3 — Load both files into CSVA2Z

• Click Select Input File in the sidebar and pick your Wix export.
• The data appears in the source table. Row 1 (slightly tinted) shows the original Wix header names; it stays pinned at the top as you scroll.
• Click Select Output Template and pick the Shopify template CSV.
• Each column header in the source table can be mapped to a target field name. Double-click any header to open the mapping dropdown.

Step 4 — Map your columns

For each Wix column you want to migrate, double-click its header and pick the matching Shopify field from the dropdown. For example:

• Wix name → Shopify Title
• Wix handleId → Shopify URL handle
• Wix description → Shopify Description
• Wix price → Shopify Price

Columns you don't want to migrate, leave unmapped.

Step 5 — Save the mapping as a template (optional but recommended)

Click Save Map Template. You'll be prompted for a filename. Save it as something like wix-to-shopify.csva2z. Next time you migrate another Wix store to Shopify, you can click Load Map Template and skip the manual mapping.

Step 6 — Create the result table

Click Create New CSV. The source table is hidden, and a new result table appears with your data reshaped to the target columns.

Step 7 — Fill in required Shopify fields

Shopify requires certain values that Wix doesn't export. Use right-click on each target column to fill them:

• Right-click the Status column header → Fill... → type active → Enter.
• Right-click Continue selling when out of stock → Fill → FALSE.
• Right-click Fulfillment service → Fill → manual.

Step 8 — Transform image URLs

Wix exports image filenames without the host prefix. To get full URLs, right-click the Product image URL column → Formula... → pick Prefix with constant → enter https://static.wixstatic.com/media/ (include the trailing slash) → review the preview → Apply.

Step 9 — Export

Click Save CSV. The result downloads as a CSV file ready for Shopify's import wizard.

Step 10 — Import to Shopify

In your Shopify admin, go to Products → Import → upload the CSV. Shopify will fetch each Wix image URL once and re-host the images on its own CDN. You can then deactivate Wix.

The Mapping Model

CSVA2Z has two distinct tables, used at different stages of the workflow:

The Source Table

Shown after loading the input CSV. It displays your data as-is. The source table is read-only: you cannot edit cells in it. Its job is to let you see what you have so you can decide how to map it.

• Row 1 (tinted) shows the original CSV's header values. It stays pinned to the top while scrolling.
• Column headers start blank. Double-click a header to assign a target field name from the loaded output template.
• Cells with content wider than the column width are truncated visually. Hover any cell to see its full content as a tooltip.

The Result Table

Shown after clicking Create New CSV. This is your editable working spreadsheet — the reshaped output, with cells you can modify before export.

• Click any cell to edit its value directly.
• Right-click a column header for bulk operations (Fill, Formula).
• Select rows or cell ranges to narrow the scope of Fill/Formula operations.

Loading Files

• Select Input File — your source CSV. Headers and rows are parsed and displayed in the source table.
• Select Output Template — a CSV whose first row contains the target column names you want to map TO. Only the header row is used; data rows are ignored.
• If you select a new input file while a result table is on screen, CSVA2Z warns you that your current mapping will be discarded.
• You can re-pick the same file (the file picker resets between clicks so re-selecting works).

Mapping Columns

Double-click any source column header to open a dropdown listing every target field from your loaded output template. Pick one to assign that target name to the column.

• You can change a mapping at any time before clicking Create New CSV — just double-click the header again.
• The original source header is always visible in the tinted row 1 below the column headers.
• Columns you don't map are excluded from the output.

Save and Load Map Templates

Once you've built a mapping you're happy with, save it as a reusable .csva2z file. The next time you need to convert the same kind of source data to the same kind of target, load the template and skip the manual work.

Save Map Template

• Click Save Map Template in the sidebar.
• You'll be prompted for a filename. Use something descriptive like wix-to-shopify or square-to-quickbooks.
• A .csva2z file downloads to your computer. Keep it somewhere you can find later.

Load Map Template

• Load your new source CSV first (the template needs columns to map against).
• Click Load Map Template and pick a previously-saved .csva2z file.
• If you already have an output template loaded, CSVA2Z warns you that your current mapping will be overwritten.
• If the new source CSV's columns don't match what the template was built for, CSVA2Z warns you about the mismatches and offers position-only matching as a fallback.
• You're never locked in: cancel either warning to abort.

What's in a .csva2z file

The file is plain JSON containing: the format version, when it was saved, the source column count, the output target headers, and per-column mappings (position, source header text, target field name). You can open one in any text editor.

CSVA2Z does not ship pre-built templates — you build your own based on your specific source and destination needs.

Creating the Result Table

Click Create New CSV when your mapping is ready. The source table hides, and the result table appears with your data shaped to the target columns.

• If you selected specific source rows (via the row-index gutter), only those rows are included.
• If no source rows are selected, all rows are included.
• You can go back to the source by loading a new file (with the appropriate warning).

Editing the Result

Direct cell editing

Every cell in the result table is an editable text input. Click and type to change a value. Click elsewhere to commit.

Selecting rows and cells

Selection is what makes Fill and Formula precise. CSVA2Z supports:

• Row selection — click the row-index gutter (the leftmost column with row numbers). Hold Shift to extend a range; hold Ctrl (or Cmd) to toggle individual rows.
• Cell-range selection — click and drag across cells in the body to select a rectangle. Selected cells highlight.
• Column selection — click a column header (in the column-selector row).
• Keyboard extension — with a row selected, Shift+Arrow, Shift+PageUp/PageDown, Shift+Home/End extend the selection from your starting anchor.

Fill — bulk set a value

Right-click and pick Fill.... An inline input appears near your cursor. Type the value, press Enter to apply, Escape or click outside to cancel.

The scope depends on where you right-clicked and what's selected:

• Right-click a column header, no selection → fills every row in that column.
• Right-click a column header, rows selected → fills only those rows in that column.
• Right-click a column header, cell range selected in that column → fills only those cells.
• Right-click a body cell, rows selected → fills the selected rows across every column.
• Right-click a body cell, cell range selected → fills exactly those cells (range may span multiple columns).
• Right-click a body cell, nothing selected → Fill is hidden from the menu.

Formula — single-column text transformations

Right-click and pick Formula.... A centered modal opens with eleven pre-canned transformations. Pick one with the radio buttons, fill in any required text/number inputs, watch the live preview update for the first three target cells, then click Apply.

The same scope rules as Fill apply to Formula.

Available transformations

• Prefix with constant — prepend a literal string to each cell. (For example, adding a URL host to bare filenames.)
• Suffix with constant — append a literal string.
• Prefix + Suffix — both at once. Either field can be empty.
• Lowercase — converts the value to lowercase.
• Uppercase — converts to uppercase.
• Trim leading/trailing whitespace — removes surrounding spaces, tabs, newlines.
• Slugify (for URL handles) — lowercases, strips accents, replaces non-alphanumeric with hyphens, trims hyphens at edges. "Red Ball" becomes "red-ball".
• Truncate to N characters — caps the length. Useful for Shopify's 320-character SEO description limit.
• Replace text — find/replace within each cell. Provide both the text to find and the replacement.
• Strip HTML tags — removes tags like <p> or <br> from values that contain embedded HTML (common in CMS exports).
• Default value if blank — leaves non-empty cells alone; replaces empty cells with a default you provide.

Formulas evaluate once on Apply and write the computed value into each cell. The formula itself is not stored on the cell — the cell becomes plain text afterward.

Fill handle

When a cell is selected, a small square appears at its bottom-right corner. Drag it down or right to fill the cell's value into adjacent cells in that direction. Drag back to contract.

Exporting

Click Save CSV to download your result table as a CSV file.

• Only the columns you mapped are included.
• The file uses UTF-8 encoding (required by most modern platforms including Shopify).
• The Use Line Feeds option in the sidebar lets you choose LF line endings (Unix-style) instead of CRLF (Windows-style) if your destination prefers them.

Merging Multiple CSVs

Use the Merge CSV Files button to combine multiple CSV files with identical headers into one:

• Click the button to open the merge popup.
• Select two or more CSV files. Their column headers must match exactly (case-sensitive).
• The tool combines all rows into a single result.
• If headers don't match, an error appears.

Merge is for combining CSVs of the same shape. Use the main mapping flow if you need to reshape data from different sources.

Tips and Limitations

• Data privacy. Everything runs in your browser. No CSV content is uploaded to any server. Your data never leaves your computer.
• Tested with files up to ~2,200 rows × 50+ columns. Larger files may take a few seconds to render but generally work.
• Bulk editing post-import. CSVA2Z handles the structural reshape. Once your data is imported into the destination platform (Shopify, QuickBooks, etc.), use that platform's own bulk editor for fine-tuning.
• Variant grouping is not automatic. If your destination uses parent-product + variant-row patterns (like Shopify), your source data must already represent that structure. CSVA2Z does not infer variant groupings.
• Light and dark mode. Click the sun/moon icon in the top-right corner to toggle. Your preference is remembered across visits.

Who CSVA2Z Is For

• E-commerce merchants — Migrate product catalogs between platforms (Wix, Squarespace, Shopify, WooCommerce, BigCommerce). Reshape inventory exports for new systems.
• Accounting and finance teams — Reformat transaction exports for QuickBooks, Xero, or other accounting platforms.
• Data analysts — Quickly edit, merge, and normalize CSV datasets without leaving the browser.
• Small business owners — Manage customer lists, inventory, and reporting data without expensive software.
• Developers and IT teams — Rapidly prototype data transformations and validate CSV structure before bulk imports.

Contact

Questions, bug reports, or feature requests: contact Daniel Kearns at admin@ubiquitous.llc.