Home › Merge Guides › Squarespace + Walmart Marketplace › Side Hustle Bookkeeping
Merge Squarespace and Walmart Marketplace Sales Data for Side Hustle Bookkeeping
Running sales channels as a side hustle usually means doing your own books, which gets tedious fast once more than one platform is involved.
Why Squarespace and Walmart Marketplace exports don't line up
- Squarespace: a Date column in ISO-like format; Subtotal, Discount, Shipping, and Total as separate columns; an Order ID that's a short alphanumeric code. Also, customer and shipping address fields are wide, so the money and date columns can end up far to the right of the sheet.
- Walmart Marketplace: an Order Date column separate from the ship-by date; item price and a separate Walmart referral fee; a numeric Purchase Order ID. Also, each order line can appear as its own row with a repeated order ID, similar to Shopify's line-item export.
For side hustle bookkeeping, that mismatch is exactly what causes hours of manual cleanup every period.
How to merge them in under a minute
- Open CSV Experts and set your target columns once (Date, Channel, Order ID, Total).
- Drop in your Squarespace export and map its columns once.
- Drop in your Walmart Marketplace export and map it the same way — both merge into one sheet, normalized.
- Export as CSV or Excel. Same-layout files merge automatically next time.
FAQ
Does this upload my sales data anywhere?
No. Everything runs in your browser using JavaScript — your files are never sent to a server.
Does it work for more than two channels?
Yes. Add as many source files as you want; each distinct file layout is mapped once and remembered.
Prefer a longer walkthrough of this pair? See the step-by-step version.
More Squarespace + Walmart Marketplace guides
- Squarespace + Walmart Marketplace for Bookkeeping
- Squarespace + Walmart Marketplace for Tax Prep
- Squarespace + Walmart Marketplace for QuickBooks Import
- Squarespace + Walmart Marketplace for Xero Import
- Squarespace + Walmart Marketplace for Profit Tracking
- Squarespace + Walmart Marketplace for Inventory Reconciliation