How-to guides
How to Organize All Your Online Orders in Excel
Tracking purchases across multiple shops quickly turns into a mess of forwarded emails, browser tabs, and memory. Excel gives you a single place to log everything—dates, costs, quantities, delivery status—so you can see exactly what you have spent and what is still on its way. The approach below works whether you are managing personal shopping, reselling stock, or reconciling business expenses.
You do not need advanced Excel skills. A consistent structure matters far more than complex formulas. Set it up once, follow the same process for each order, and the workbook stays useful rather than becoming another thing to ignore.
Start with One Workbook, Not One File per Shop
The most common mistake is creating a separate spreadsheet for each retailer. After a month you have a dozen files, none of which talk to each other. Instead, create one workbook called something like Orders_2025.xlsx and keep everything inside it. This makes cross-shop comparisons straightforward and means your summary formulas can pull from every sheet at once. Store the file somewhere you can reach it from both your phone and desktop—OneDrive, Google Drive, or Dropbox all work fine with Excel files.
Decide on a Sheet Structure Before You Add Any Data
Two structures work well depending on your situation. If you place orders regularly throughout the year, create one sheet per month: Jan, Feb, Mar, and so on. If you manage orders for several people or clients, create one sheet per person. A third sheet called Summary should always exist—this is where you pull totals from every other sheet using a simple formula. Avoid creating a new sheet for every individual order; that fragments your data and makes formulas complicated. Pick the structure that matches how you actually think about your orders, then stick to it.
The Seven Columns Every Order Sheet Needs
Keep column headers identical across every sheet so that cross-sheet formulas work without adjustment. A reliable set is: Date, Shop, Order Reference, Product Name, Quantity, Unit Price, and Line Total. Add an eighth column, Status, with values like Ordered, Shipped, Delivered, or Returned. If you track online orders in Excel for tax or reimbursement purposes, a ninth column for Category (Office, Travel, Inventory, etc.) saves time at year-end. Freeze row 1 so headers stay visible as the list grows.
Formulas Worth Adding From the Start
Line Total is simply =E2*F2 (Quantity multiplied by Unit Price). At the bottom of each sheet, add a grand total with =SUM(G:G), excluding the header. On your Summary sheet, pull each monthly or per-person total with a formula like =Jan!G1001 or, more robustly, =SUM(Jan!G:G). To count how many orders came from a specific shop, use =COUNTIF(B:B,"Amazon"). For a running spend by category, SUMIF works: =SUMIF(I:I,"Office",G:G). None of these require macro knowledge; they are all standard functions available in every Excel version.
Adding Product Photos to Your Spreadsheet
A photo column transforms a flat list into something you can scan visually—useful when you are checking a return, comparing similar items, or presenting a purchase list to someone else. In Excel, you can insert an image into a cell by selecting the cell, going to Insert > Picture > Place in Cell, then choosing your image file. Resize the row height to match. The practical problem is sourcing the images: you need a cropped photo of each product, which means manually saving screenshots and cutting them one by one. This is where the process gets tedious at scale, which is why some people look for a faster starting point before doing any manual cleanup in Excel.
Using snapNsheet to Generate a Ready-Made Row Set
If you want to organize online orders in Excel without typing every product name and price by hand, snapNsheet offers a shortcut for the data-entry step. You upload screenshots of your order confirmation, cart, or receipt—up to ten images per conversion, covering up to 75 products—and it produces an .xlsx file with one row per product, including the cropped product photo embedded in the cell, product name, quantity, unit price, line total, and a grand-total formula. You review the detected rows on screen before downloading. The file drops straight into your workbook: paste the rows into the relevant monthly or customer sheet, then add your Status and Category columns. It reads EUR, USD, and GBP prices. Note that it works from screenshots only—it does not connect to any store account—so image quality affects accuracy, and prices that are cut off or hidden in the screenshot will not be captured.
Keeping the Workbook Accurate Over Time
A spreadsheet is only as good as the discipline behind it. Set a fixed time each week—ten minutes on a Sunday evening works for many people—to add any orders placed since your last update. Update the Status column as deliveries arrive or returns are processed. If a price changes after a partial refund, note the adjustment in a Comments column rather than overwriting the original figure; that way you keep an audit trail. Archive completed months by moving their sheets into a separate workbook at the start of each new year, so the active file stays fast and uncluttered.
Common Mistakes That Undermine the System
Merging cells looks tidy but breaks almost every formula that tries to reference that range—avoid it entirely. Storing currency symbols inside the number cell (typing £45 instead of formatting the column as currency) turns numbers into text and makes SUM return zero. Leaving blank rows between orders confuses COUNTA and SUMIF ranges. Finally, if you share the workbook with someone else, agree on the Status dropdown values in advance; free-text entries like 'delivered', 'Delivered', and 'dlvrd' will all be counted separately by COUNTIF. Consistent formatting is the unglamorous foundation that makes every formula reliable.
Frequently asked questions
How many sheets should one Excel workbook have for tracking orders?
One sheet per month or one per customer is enough for most situations, plus a Summary sheet. More than fifteen active sheets in one workbook starts to slow navigation. Archive older months into a separate annual file to keep things manageable.
Can I track orders from multiple shops in the same sheet?
Yes. Include a Shop column and use SUMIF or COUNTIF to filter by retailer. Keeping everything on one sheet per month is simpler than splitting by shop, because you can still isolate any retailer with a formula while maintaining a single sorted date order.
What is the easiest way to add product images to Excel cells?
Use Insert > Picture > Place in Cell in recent Excel versions. The image sits inside the cell and moves with it when you sort or filter. Sourcing clean, cropped product photos is the time-consuming part; tools like snapNsheet embed them automatically from your order screenshots.
Does snapNsheet connect to my shop account to pull order data?
No. snapNsheet reads screenshots you upload—PNG, JPG, or WEBP files up to 8 MB each. It does not log into any store or access account data. The accuracy of the output depends on the clarity and completeness of the screenshots you provide.