Square Insights
Read your Square sales data the way an event planner would, not the way an accountant would. Free, private, no signup.
🔒 Your data never leaves your browser. We don't upload, store, or see your sales information.
How it works
Three steps. No login, no upload, no spreadsheet wrangling. The parser runs entirely in your browser, so your sales data never touches our servers.
- Step 1
Export from Square
In your Square Dashboard, go to Reports → Sales → Item Sales, pick a date range that matches one event, and click Export → Summary CSV.
- Step 2
Drop the CSV above
Drag the file into the drop zone, or click to browse. Drop multiple CSVs to compare events. Rename each one so you remember which is which.
- Step 3
Get a packing plan
You'll see your true bestsellers, items that consistently underperform, and a per-item production estimate for your next similar event.
What you'll see
Here's the actual output from our soap-maker sample data (3 events, 17 unique items, 353 units sold). Click "Load sample data" in the drop zone above to play with the same numbers interactively.
True bestsellers
Items that show up in the top 10 of every event you uploaded.
| Item | Total sold |
|---|---|
| Lavender bar | 65 |
| Oatmeal honey bar | 52 |
| Eucalyptus + mint bar | 42 |
| Lavender 3-pack | 32 |
| Rose clay bar | 26 |
What to bring next time
The highest-selling event for each item, multiplied by 1.5 for headroom.
| Item | Bring |
|---|---|
| Lavender bar | max 28 → bring 42 |
| Oatmeal honey bar | max 22 → bring 33 |
| Eucalyptus + mint bar | max 19 → bring 29 |
| Lavender 3-pack | max 14 → bring 21 |
| Rose clay bar | max 11 → bring 17 |
Production estimate
For each top-selling item, we take the highest quantity sold at any single event and add 50% headroom. That's the number you bring so you don't sell out at noon and don't haul half your stock home.
True bestsellers
One hot event is luck. An item that lands in the top 10 of every event is a real anchor. Make these. Always. Never run out.
Consistent dead weight
Items that show up in two or more events and sell poorly every time. Square's report shows the numbers. We tell you to consider leaving them home.
🔒 Your data never leaves your browser
The CSV parser is JavaScript that runs in your tab. No upload, no server-side processing, no analytics on the contents of your file. We don't see your sales data, we don't store it, and we couldn't hand it over if someone asked. Close the tab and it's gone.
This tool vs. the MyEventPrep app
This tool answers one question: what should I bring to my next event? The full MyEventPrep app handles everything around that question, end to end.
Use this tool when…
- • You want a quick answer right now, no signup
- • You already track sales in Square
- • You want to compare a couple of past events
- • You're privacy-conscious and don't want to upload data
Use the full app when…
- • You need a printable production prep sheet
- • You want to track stock-on-hand between events
- • You're planning a season of multiple events
- • You want post-event reflection saved alongside numbers
Frequently asked questions
- How do I export an Item Sales CSV from Square?
- Sign in to your Square Dashboard. Go to Reports → Sales → Item Sales. Set the date range to cover one event (or one weekend). Click Export in the top-right and choose Summary CSV. That's the file this tool wants.
- Is my sales data really private?
- Yes. The CSV parser is JavaScript that runs in your browser tab. The file never leaves your device, we don't run analytics on its contents, and there's no upload step. You can verify this by opening your browser's Network tab while you use the tool.
- What CSV format does the tool need?
- Square's Item Sales Summary export. Not the Item Sales Detail export, which is one row per transaction. The Summary version groups by item and is what Square offers by default when you click Export from the Item Sales report.
- Can I compare events from different time periods?
- Yes. Drop two or more CSVs into the tool, one per event. Rename each one (Spring Market, Summer Pop-Up, etc.) so you can keep track. The tool finds items that sold consistently across all of them, items that consistently flopped, and a combined production estimate based on the best event for each item.
- How is this different from Square's built-in reports?
- Square shows you numbers. This tool turns numbers into decisions. Square's report tells you the lavender bar sold 28 units at the spring market. This tool tells you to bring 42 lavender bars to the next similar event because that's your historical max plus 50% headroom — the math an event planner would do, not an accountant.