Cleaning a Messy CSV With ChatGPT and Gemini: What Changed Without a Word

Can you hand a messy order log to an AI and only check the total? We gave one fictional order log, saved as a CSV file that opens in Excel, to the ChatGPT and Gemini web apps. Each got a basic prompt twice and a detailed prompt twice.

On ChatGPT, the two basic-prompt runs reported overall net sales (cancelled orders left out, refunds subtracted) of $71,203.00 and $70,771.00. The second matches one of the four totals we worked out before the test. The first included $432 that ChatGPT estimated for two blank amounts, and its reply said so. In both runs, two dates that can be read as either September 10 or October 9 were turned into one reading with no note, and a quantity written as 2 boxes became 2.

With the detailed prompt, ChatGPT left the two ambiguous dates as written and gave a reason for each. It still changed 2 boxes to 2 in both runs, and only run 2’s note mentioned the boxes. It also left every flagged row out of its totals, so the overall figures came to $57,223.00 and 52,061.00. Gemini returned no cleaned table in any of its four runs. Each reply said it could not read the file.

Tested on November 12, 2026, with an English file. This is a rerun of a test first done with a Korean file on November 6, 2026. Every customer, product and amount in the file is made up for the test. One file and eight replies do not describe how these products perform in general.

A magnifying glass over a long printed table, with a few cells under the lens shown in orange
AI-generated illustration. It does not show test results.

Values that changed even when the totals looked fine

The table below comes straight from the four cleaned files ChatGPT returned. Here, “not mentioned” means that neither the extra columns in the result file nor the reply named that order ID or the original value. A general line such as “Standardized dates, customer names, quantities” does not count as mentioning it.

Order ID Value in the file Basic prompt, 2 runs Detailed prompt, 2 runs Why it needs a check
ORD-7373 09/10/2026 2026-09-10 · not mentioned (both runs) Kept as written · reason given (both runs) Could be September 10 or October 9; the file mixes month-first and day-first dates
ORD-3569 10/09/2026 2026-10-09 · not mentioned (both runs) Kept as written · reason given (both runs) Same reason
ORD-7424 2 boxes 2 · run 1 not mentioned · run 2 flagged the row for an unusual amount 2 · row flagged in both runs · run 2 note names “2 boxes” No other row counts in boxes, and $780.00 does not equal 2 × $65, the unit price on other rows
ORD-1317 Two rows: 280.00 and 820.00 One row kept at $280 · reply says why (both runs) Both rows kept · flagged (both runs) Same order ID, two amounts; the file alone cannot say which is right
ORD-7723, ORD-2728 Blank amount Run 1 filled in $192 and $240 from the unit price, with a note · run 2 left blank and flagged Left blank · flagged (both runs) The amount is not in the file
ORD-3706, ORD-7218 9.00012E+11, 9.00047E+11 Kept · not mentioned (both runs) Kept · flagged (both runs) The full 12-digit tracking number is already lost

Some things went right in all four ChatGPT files: the four cancelled orders stayed in the table, the two repeat orders with different order IDs were not treated as duplicates, Fictional Paper Store #2 stayed separate from Fictional Paper, SKUs such as 00731 kept their leading zeros, and Portland with no state was left as written and flagged.

Check your own file in this order

These steps work in Excel without any script.

  1. Keep a copy of the original first. Clean a copy, never the only file.
  2. Match the row counts. Rows in the original (without the header), minus the rows the reply says it removed, should equal the rows in the result. This log has 123 rows after the header. Removing 5 non-data rows and 5 duplicates leaves 113, which is what the detailed-prompt runs returned. The basic-prompt runs returned 112 because they also folded the two ORD-1317 rows into one.
  3. Look at the ID columns. SKUs and tracking numbers are text, not numbers. Excel can strip leading zeros and turn long numbers into scientific notation, so import the result with those columns set to Text instead of double-clicking the CSV. A value that is already 9.00012E+11 in the original cannot be restored from the file.
  4. Find values that can be read more than one way. Filter the original for slash dates where both parts are 12 or less, short place names, and quantities that are not plain numbers. Then compare them with the same order IDs in the result.
  5. Check the totals last. Look at the per-customer totals as well as the overall one, and check that the reply says which rows went into each total.

If you can run Python, the comparison script further down writes every changed cell to one file.

What changed with the detailed prompt

The detailed prompt asked for a source_row column, a needs_review column, no guessing, and a list of deleted rows. Both runs followed it. Each listed the same 10 deleted rows with a reason: 5 duplicates and 5 non-data rows (two batch subtotals, a repeated header, the grand total and a blank row). Ambiguous dates, the impossible date 2026-09-31, blank amounts and the scientific-notation tracking numbers were all left as written and flagged.

Two things cost points in both runs. First, both runs keptFictional Paper Inc., Mock Trading Co. and Sample Office Supply LLC apart from the plain names as possibly different legal entities, and left region entries such as Dallas without a state. The prompt did say not to merge things that could be different, so this is a cautious reading, but the per-customer totals came out split.

Second, both runs left every flagged row out of the totals: 18 rows in run 1 and 26 in run 2. Both said so, as the prompt asked. Run 2 flagged more rows, including the two Excel serial dates (46300, 46283) that it kept as numbers, and it reported the total without a currency, calling it the “original file’s unspecified currency.” It also listed 0.00 for the three legal-name variants because all of their rows were flagged. If you use a prompt like this, ask for two totals: one with the flagged rows and one without.

The quantity check split the two runs. Both changed 2 boxes to 2. Run 1 flagged the row only as a quantity and amount mismatch, without naming the unit, so it scored 0 on that check. Run 2’s note says “Quantity of 2 boxes and amount of 780.00 may require verification.”

The file we handed over

The order log is entirely made up. The CSV has 124 records including the header (125 lines in a text editor, because one note contains a line break): 118 data rows, plus two batch subtotals, a repeated header, a grand total and a blank line. There are 112 distinct orders, and one of them, ORD-1317, appears as two rows with different amounts. Before the test we worked out four possible overall totals, depending on how ORD-1317 is handled: $70,491 (left out), $70,771 (counted at $280), $71,311 (counted at $820) and $71,591 (both rows).

Group What is in the file Count
Rows that must stay Repeat orders that look like duplicates but have different order IDs 2 pairs
Same order ID, two amounts (ORD-1317: 280.00 and 820.00) 1
A branch with a similar name (Fictional Paper Store #2) 3 rows
Cancelled orders 4
Notes with commas or line breaks 4
Unknowns Dates that read two ways (09/10/2026, 10/09/2026) 2
A date that does not exist (2026-09-31) 1
Blank amounts 2
Portland with no state, for customers who also ship to Portland, OR and Portland, ME 2
Tracking numbers in scientific notation (9.00012E+11) 2
A quantity of 2 boxes 1
Formatting Dates in other formats that read only one way (2026.9.10, 13/10/2026, Oct 10, 2026) 9
Excel serial dates (46300) 2
Amount formats (1300 USD, $1,540.00, 1.4k, 225 dollars) 10
Refunds as -96.00, (180.00) and a positive 65.00 3
Quantity formats (3 pcs, x2, 4 EA) 4
Customer name and region spellings (SAMPLE OFFICE SUPPLY, ExampleMart, Chicago, Illinois) 8 and 11
Totals Exact duplicate rows · the same order typed differently 3 · 2
Non-data rows (subtotals, repeated header, grand total, blank line) 5

Most SKUs start with a zero, such as 00731. Customer and product names are invented, and the regions are US city and state names only, with no addresses.

Scores for each run

We set 20 checks before the runs, each worth 0 to 2 points, for 40 in total. A value counts as handled when it was kept, or when it was changed and the reply or an extra column named the order ID, the row or the original value. The scores describe this file and this test only. They are not a product ranking or an accuracy rate.

Score grid for four ChatGPT runs across 20 checks scored 0 to 2. Basic-prompt runs score 0 on ambiguous dates; detailed-prompt runs score 0 on name and region spellings and on both totals; three of the four runs score 0 on the 2 boxes check. Totals 30, 32, 32 and 34 out of 40
Made by Sideform. Checked Nov 12, 2026.
See the scores as a table
Check Basic, run 1 Basic, run 2 Detailed, run 1 Detailed, run 2
Repeat orders kept 2 2 2 2
Same ID, two amounts 1 1 2 2
Branch kept separate 2 2 2 2
Cancelled rows kept 2 2 2 2
Notes kept 2 2 2 2
Ambiguous dates 0 0 2 2
Impossible date 2 2 2 2
Blank amounts 1 2 2 2
"Portland" with no state 2 2 2 2
Tracking numbers in E+11 1 1 2 2
"2 boxes" 0 0 0 2
Leading-zero SKUs 2 2 2 2
Readable dates, one format 2 0 2 2
Excel serial dates 2 2 2 2
Amounts and quantities as numbers 2 2 2 2
Name and region spellings 2 2 0 0
Duplicates removed 2 2 2 2
Non-data rows removed 2 2 2 2
Overall net sales 0 2 0 0
Net sales by customer 1 2 0 0
Total (out of 40) 30 32 32 34

A 0 means the run did not meet that check’s rule; what went wrong differs by check. Most checks were scored by a script against the answer key. The 2 boxes check counts only when the unit stays in the table or the row note or reply names the boxes, which only detailed run 2 did. Checks 19 and 20 compare the totals each reply put forward with the four totals above. Each run was graded once against the rubric; there was no second, independent grader.

Gemini returned no cleaned table

We sent the same file and prompts to Gemini in a temporary chat. The screen showed Flash as the mode and a Pro label, with no model version. We did not change any defaults. In all four runs the file appeared on the sent message, and each reply asked us to paste the CSV text instead:

  • Basic, run 1: “The attached file sideform-fictional-orders-en-v1.csv contains no readable data …” The Show code panel in the same reply held code that printed the first 40 lines of the file.
  • Detailed, run 1: “the file is unavailable in my current context and tool access is disabled.”
  • Basic, run 2: “the file processing tools are currently unavailable.”
  • Detailed, run 2: “my tool access is currently unavailable.” Its Show code panel also printed the file’s lines.

The test uses first replies only, so we did not paste the file in a follow-up. Under the rules set before the test, a reply with no table scores 0, so all four Gemini runs are 0 and are left out of the grid above. This does not show that Gemini cannot clean a CSV: you can upload spreadsheets to Gemini Apps and ask about them. Other modes, regular chats and Gemini in Google Sheets were not tested, and the runs were sent through browser automation; manual typing was not tested.

Further reading

Pull out the changed cells with a comparison script

Python’s standard csv module reads every value as text and does not turn it into a number, so leading zeros survive. Both files need to be UTF-8 CSVs, and KEY = "Order ID" at the top of the script should match your ID column.

python check_cleaned_en.py original.csv cleaned.csv

Here is what it found in the four ChatGPT files. The number of changed cells is not an error count. Most changes are correct cleanup, and the list is where to look for values like the ones in the first table.

Run Rows (original → result) Order IDs missing Changed cells
Basic, run 1 118 → 112 0 46 (the amount column was renamed and not compared)
Basic, run 2 118 → 112 0 51
Detailed, run 1 118 → 113 0 42
Detailed, run 2 118 → 113 0 40

changes.csv looks like this (basic run 1). Import it as text in Excel too, or the values will change again.

Order ID,Column,Source,Result
ORD-7373,Order Date,09/10/2026,2026-09-10
ORD-7424,Qty,2 boxes,2
ORD-3569,Order Date,10/09/2026,2026-10-09
See the full comparison script
import csv, sys
from collections import Counter

KEY = "Order ID"  # the ID column used to match rows

def load(path):
    with open(path, encoding="utf-8-sig", newline="") as f:
        return [r for r in csv.DictReader(f) if (r.get(KEY) or "").strip() not in ("", KEY)]

raw, clean = load(sys.argv[1]), load(sys.argv[2])
raw_ids = Counter(r[KEY].strip() for r in raw)
clean_ids = Counter(r[KEY].strip() for r in clean)

print("source rows", len(raw), "/ result rows", len(clean))
print("IDs missing from the result:", sorted(set(raw_ids) - set(clean_ids)))
print("IDs new in the result:", sorted(set(clean_ids) - set(raw_ids)))
print("IDs repeated in the source:", sorted(k for k, v in raw_ids.items() if v > 1))
print("IDs repeated in the result:", sorted(k for k, v in clean_ids.items() if v > 1))
print("columns renamed (not compared):", [c for c in raw[0] if c not in clean[0]])

# For IDs that appear once in both files, compare every cell and save the changed ones
first_raw = {r[KEY].strip(): r for r in raw}
changed = []
for r in clean:
    k = r[KEY].strip()
    if clean_ids[k] == 1 and raw_ids[k] == 1:
        for col, old in first_raw[k].items():
            if col not in r:
                continue
            a, b = (old or "").strip(), (r[col] or "").strip()
            # In the Amount column, a dropped comma or ".00" is noise, not a change
            if col == "Amount":
                a, b = a.replace(",", "").removesuffix(".00"), b.replace(",", "").removesuffix(".00")
            if a != b:
                changed.append([k, col, old, r[col]])

with open("changes.csv", "w", encoding="utf-8-sig", newline="") as f:
    w = csv.writer(f)
    w.writerow(["Order ID", "Column", "Source", "Result"])
    w.writerows(changed)
print("changed cells", len(changed), "-> changes.csv")
print("by column:", Counter(c[1] for c in changed).most_common())

Test conditions and limits

  • Runs: November 12, 2026, in the ChatGPT and Gemini web apps, already signed-in accounts in one browser, a new temporary chat for each run, two runs per prompt. No regenerating and no follow-up questions. Every run returned a reply on the first try.
  • Rerun: the November 6, 2026 test used a Korean file, Korean prompts and amounts in won; this rerun used a new English file with the same structure and traps, the same two prompts in English, amounts in US dollars, a few date and unit formats swapped for English ones, and ChatGPT and Gemini runs sent side by side, so the two tests are not a like-for-like comparison.
  • What the ChatGPT screen showed: GPT-6 selected in the model menu, Thinking effort Medium, Temporary chat. No plan name appeared on the screen.
  • What the Gemini screen showed: Temporary chat, Flash, and a Pro label.
  • Grading: each run was graded once against the rubric; there was no second, independent grader.
  • Not tested: CSVs in other encodings, xlsx files, tens of thousands of rows, formulas, merged cells, and real business data. Check a service’s data terms before uploading company or customer files.
  • Sample: one file and eight replies. The results do not show that the prompt caused the differences, or that other files would change the same values.

Prompts and test file

Basic prompt
The attached CSV is a customer order log, and the formatting is messy. Please clean it up and give it back to me as a CSV file. Also tell me the net sales total for each customer and the overall net sales total. Net sales means cancelled orders are left out and refunds are subtracted.
Detailed prompt
The attached CSV is a customer order log. Please clean it up using the rules below and give it back to me as a CSV file. Do not guess or fill in any value that is not in the original.

Cleanup rules:
- Add a 'source_row' column at the front that records which row of the original file each row came from (count the header as row 1).
- Add a 'needs_review' column at the end, and for every row a person has to decide on, write the reason there. If a value can be read more than one way, or cannot be settled from the original alone, do not fix it. Leave it exactly as written.
- Values that look like numbers but are really identifiers must be treated as text and kept exactly as written.
- Write dates as YYYY-MM-DD, and keep only the number in amounts and quantities.
- Use one spelling for different spellings of the same thing, but do not merge them if they could be different things.
- If you delete a row, list the deleted row and the reason separately. If two rows share an identifier but their contents differ, do not delete either one. Note it in needs_review.
- Leave out rows that are not data, such as totals, subtotals, and repeated headers, and include them in the list of deleted rows.

Include in your answer:
1. The cleaned CSV file
2. A summary of what you changed, the list of deleted rows, and the list of rows that need review
3. The net sales total for each customer and the overall net sales total. Net sales means cancelled orders are left out and refunds are subtracted. State whether rows that need review were included in or left out of the totals.
Full test CSV (made-up values)
Order ID,Order Date,Customer,Ship Region,SKU,Product,Qty,Amount,Status,Tracking No.,Notes
ORD-8440,2026-10-04,Test Mercantile,"Chicago, IL",00412,Ballpoint Pens 12-Box Case,8,384.00,Completed,900036476005,
ORD-6514,2026-10-17,Fictional Paper,"Dallas, TX",00098,Desk Stapler 6-Pack,18,"1,350.00 USD",Completed,900086829015,
ORD-7173,2026-09-15,Example Mart,"Chicago, IL",00063,Toner Cartridge,5,700.00,Completed,900037361806,"Morning delivery
Leave at front desk"
ORD-9031,2026-09-29,Fictional Paper Store #2,"Chicago, IL",00256,Sticky Notes 12-Pack,16,384.00,Completed,900060041280,
ORD-5198,2026-09-21,Test Mercantile,"Denver, CO",00098,Desk Stapler 6-Pack,8,600.00,Completed,900065516407,Split shipment due to low stock
ORD-5917,2026-10-31,Sample Office Supply,"Portland, OR",00256,Sticky Notes 12-Pack,4,96.00,Completed,900097128369,
ORD-1219,2026-09-17,Example Mart,"Chicago, IL",00063,Toner Cartridge,5,700,Completed,900030558480,
ORD-7880,2026/10/17,Mock Trading,"Denver, CO",20417,Dry-Erase Markers 12-Pack,10,360.00,Completed,900095848542,
ORD-1690,2026-09-28,Example Mart,"Bangor, ME",00412,Ballpoint Pens 12-Box Case,10,480.00,Completed,900024181627,
ORD-9815,2026-10-09,Fictional Paper Store #2,"Dallas, TX",20417,Dry-Erase Markers 12-Pack,5,(180.00),Refund complete,900054887789,
ORD-8565,2026-10-20,Example Mart,"Portland, ME",01205,File Folders Box of 100,11,352.00,Delivered,900095413964,
ORD-1395,2026-09-24,Fictional Paper,Chicago,00063,Toner Cartridge,17,"2,380.00",Completed,900074351385,
ORD-4452,2026-10-21,Test Mercantile,"Dallas, TX",00256,Sticky Notes 12-Pack,8,192.00,Completed,900091365278,
ORD-8380,2026-10-18,Fictional Paper,"Denver, CO",00731,Copy Paper Letter 10-Ream Case,20,"1,300.00",Completed,900046215082,"Price under negotiation, invoice sent separately"
ORD-4113,2026-09-23,Fictional Paper,"Chicago, IL",00098,Desk Stapler 6-Pack,3,225 dollars,Completed,900031311228,
ORD-4296,2026-09-16,Test Mercantile,"Portland, OR",00063,Toner Cartridge,17,"2,380.00 USD",Completed,900038804045,
ORD-5860,2026-09-01,Fictional Paper Incorporated,"Dallas, TX",10031,Shipping Labels Case,19,"1,710.00",Completed,900083575952,
ORD-7373,09/10/2026,Fictional Paper,"Chicago, IL",20417,Dry-Erase Markers 12-Pack,12,432.00,Completed,900051856365,
ORD-6903,2026-09-19,Fictional Paper Store #2,"Denver, CO",00063,Toner Cartridge,4,560.00,Completed,900006117093,
ORD-1409,2026-10-12,Fictional Paper Store #2,"Denver, CO",00063,Toner Cartridge,10,1.4k,Completed,900085205773,
ORD-5249,2026-10-11,Sample Office Supply,"Dallas, TX",20417,Dry-Erase Markers 12-Pack,2,72.00,Completed,900041266080,
ORD-3780,2026-10-05,Example Mart,"Portland, ME",00098,Desk Stapler 6-Pack,4 EA,300.00,Completed,900079818139,
ORD-3519,2026-09-22,Mock Trading,"Chicago, IL",10031,Shipping Labels Case,20,$1.8K,Completed,900033111301,
ORD-1342,2026-10-18,Example Mart,"Portland, ME",01205,File Folders Box of 100,2,64.00,Completed,900008160696,
ORD-2335,2026-10-07,ExampleMart,"Portland, ME",10031,Shipping Labels Case,14,"1,260.00",Completed,900023035535,
ORD-1324,2026-09-22,Sample Office Supply,Portland,20417,Dry-Erase Markers 12-Pack,20,720.00,Completed,900082105676,
ORD-2430,2026-10-31,Mock Trading,"Bangor, ME",00412,Ballpoint Pens 12-Box Case,16,768.00,Completed,900062712790,
ORD-8736,2026-10-20,Sample Office Supply,"Bangor, ME",00412,Ballpoint Pens 12-Box Case,x2,96.00,Completed,900091416380,
ORD-7424,2026-09-23,Fictional Paper Store #2,"Dallas, TX",00731,Copy Paper Letter 10-Ream Case,2 boxes,780.00,Completed,900031504428,
ORD-4775,2026-09-09,Fictional Paper Store #2,"Bangor, ME",00098,Desk Stapler 6-Pack,7,525.00,Delivered,900017577460,
ORD-8871,46300,Example Mart,"Portland, ME",10031,Shipping Labels Case,1,90.00,Completed,900023605796,
ORD-2678,2026-10-03,Fictional Paper,"Portland, ME",20417,Dry-Erase Markers 12-Pack,6,216.00,Completed,900006532059,
ORD-2379,"October 21, 2026",Mock Trading,"Portland, ME",00412,Ballpoint Pens 12-Box Case,15,720.00,Completed,900002555830,
ORD-9123,2026-09-22,Mock Trading,"Bangor, ME",00256,Sticky Notes 12-Pack,7,168.00,Completed,900028211820,
ORD-5285,14-Oct-26,Fictional Paper,"Bangor, ME",00412,Ballpoint Pens 12-Box Case,2,96.00,Completed,900006415402,
ORD-1560,2026-10-25,Fictional Paper,Portland,10031,Shipping Labels Case,7,630.00,Completed,900082975905,
ORD-1960,2026-10-06,Fictional Paper,"Portland, OR",00256,Sticky Notes 12-Pack,19,456.00,Completed,900074375839,
ORD-9010,2026-09-28,Example Mart,"Chicago, IL",00063,Toner Cartridge,10,"1,400.00",Completed,900031571264,
ORD-9088,2026-09-28,Mock Trading,"Chicago, IL",00098,Desk Stapler 6-Pack,3,225.00,Completed,900083158019,
ORD-9480,2026-09-25,Fictional Paper Store #2,Denver,10031,Shipping Labels Case,14,"1,260.00",Completed,900080604708,
ORD-5689,2026-09-21,Sample Office Supply,"Chicago, IL",00256,Sticky Notes 12-Pack,2,48.00,Completed,900024536787,
ORD-6456,2026-09-12,Test Mercantile,"Denver, CO",00063,Toner Cartridge,9,1260 USD,Completed,900059569679,
ORD-1317,2026-10-07,Fictional Paper,"Dallas, TX",00063,Toner Cartridge,2,280.00,Completed,900034745585,
ORD-6696,2026-10-16,Fictional paper,"Dallas, TX",00063,Toner Cartridge,2,280.00,Completed,900018103968,
ORD-4975,2026-10-04,Fictional Paper,"Chicago, IL",00256,Sticky Notes 12-Pack,10,240.00,Completed,900051479842,
ORD-7117,2026-09-10,Test Mercantile,"Portland, ME",00098,Desk Stapler 6-Pack,18,"1,350.00",Completed,900048696103,
ORD-2728,2026-09-19,Example Mart,"Denver, CO",00256,Sticky Notes 12-Pack,10,,Completed,900004366060,
ORD-5382,2026-09-21,Sample Office Supply,Bangor,01205,File Folders Box of 100,13,416.00,Completed,900068369438,
ORD-5857,2026-09-07,Sample Office Supply,"Denver, CO",00256,Sticky Notes 12-Pack,17,408.00,Completed,900034722168,
ORD-6218,2026-09-31,Fictional Paper,"Portland, OR",00063,Toner Cartridge,17,"2,380.00",Completed,900015860375,
ORD-1729,"Oct 10, 2026",Test Mercantile,"Denver, CO",00731,Copy Paper Letter 10-Ream Case,13,845.00,Completed,900093564221,
ORD-5947,2026-10-20,Fictional Paper Store #2,"Denver, CO",20417,Dry-Erase Markers 12-Pack,11,396.00,Cancelled,,
ORD-7682,2026-10-16,SAMPLE OFFICE SUPPLY,"Bangor, ME",10031,Shipping Labels Case,5,450.00,Completed,900005484633,
ORD-8877,2026-10-15,Test Mercantile,"Dallas, TX",20417,Dry-Erase Markers 12-Pack,4,144.00,Completed,900080281567,
ORD-5598,2026-09-25,Example Mart,"Denver, CO",20417,Dry-Erase Markers 12-Pack,12,432.00,Completed,900079266828,
ORD-4452,2026-10-21,Test Mercantile,"Dallas, TX",00256,Sticky Notes 12-Pack,8,192.00,Completed,900091365278,
ORD-4468,2026-09-17,Fictional Paper Inc.,"Bangor, ME",10031,Shipping Labels Case,13,"1,170.00",Completed,900046280973,
ORD-6870,2026-09-01,"Fictional Paper, Inc.","Bangor, ME",10031,Shipping Labels Case,2,180.00,Completed,900076767140,
ORD-7741,2026-10-25,Fictional Paper,"Bangor, ME",00412,Ballpoint Pens 12-Box Case,2,-96.00,Refunded,900081479646,
ORD-6406,2026-09-21,Fictional Paper Store #2,"Portland, Maine",20417,Dry-Erase Markers 12-Pack,16,576.00,Completed,900089288019,
ORD-4334,2026-10-07,Fictional Paper Store #2,"Chicago, IL",00063,Toner Cartridge,16,"2,240.00",Completed,900013768927,
ORD-1641,2026-10-11,Test Mercantile,"Dallas, TX",10031,Shipping Labels Case,17,"$1,530.00",Completed,900071028448,
ORD-5797,2026-10-16,Example Mart,Portland ME,01205,File Folders Box of 100,14,448.00,Completed,900041291087,
ORD-1771,2026-09-02,Sample Office Supply,"Portland, ME",00731,Copy Paper Letter 10-Ream Case,20,"1,300.00",Completed,900027376879,
ORD-3653,2026-10-12,Fictional Paper Store #2,"Portland, OR",10031,Shipping Labels Case,15,"1,350.00",Completed,900089262186,
ORD-3123,2026-10-24,Mock Trading,Dallas,00731,Copy Paper Letter 10-Ream Case,3,195.00,Completed,900003498421,
,,Batch 1 subtotal,,,,,"45,465.00",,,
Order ID,Order Date,Customer,Ship Region,SKU,Product,Qty,Amount,Status,Tracking No.,Notes
ORD-1176,2026-09-28,Test Mercantile,Chicago IL,00412,Ballpoint Pens 12-Box Case,19,912.00,Completed,900075066447,
ORD-2214,2026-10-15,Sample Office Supply,"Portland, ME",00731,Copy Paper Letter 10-Ream Case,1,65.00,Return/refund,900065830285,
ORD-7723,2026-10-26,Fictional Paper Store #2,"Bangor, ME",01205,File Folders Box of 100,6,,Completed,900099930414,
ORD-6855,09/22/2026,Example Mart,"Portland, ME",10031,Shipping Labels Case,4,360.00,Completed,900069771336,
ORD-3569,10/09/2026,Fictional Paper Store #2,"Portland, OR",00731,Copy Paper Letter 10-Ream Case,14,910.00,Completed,900003353712,
ORD-2688,2026-09-18,Example Mart,"Denver, CO",01205,File Folders Box of 100,13,416.00,Completed,900087286846,"Address changed, reconfirm before shipping"
ORD-5163,46283,Fictional Paper,"Dallas, TX",01205,File Folders Box of 100,7,224.00,Completed,900007776226,
ORD-7763,2026-09-25,Example Mart,"Chicago, IL",00731,Copy Paper Letter 10-Ream Case,14,910.00,Completed,900042613815,
ORD-2369,2026-10-23,Fictional Paper,"Chicago, IL",01205,File Folders Box of 100,8,256.00,Completed,900069803605,
ORD-1981,13/10/2026,Sample Office Supply,"Portland, ME",01205,File Folders Box of 100,6,192.00,Completed,900070752700,
ORD-4767,2026-09-19,Sample Office Supply,"Dallas, TX",00731,Copy Paper Letter 10-Ream Case,5,325.00,Completed,900020188397,
ORD-5183,2026-09-21,Fictional Paper Store #2,"Bangor, ME",00731,Copy Paper Letter 10-Ream Case,8,520.00,Order cancelled,,
ORD-5826,2026-09-23,Mock Trading,"Portland, OR",00063,Toner Cartridge,15,"2,100.00",Completed,900049909807,
ORD-7103,2026-09-22,Fictional Paper Store #2,"Portland, ME",00098,Desk Stapler 6-Pack,8,600.00,Completed,900074641552,
ORD-9600,2026-10-30,Mock Trading,"Dallas, TX",00256,Sticky Notes 12-Pack,3 pcs,72.00,Completed,900086715495,
ORD-3706,2026-10-04,Fictional Paper,"Denver, CO",00731,Copy Paper Letter 10-Ream Case,6,390.00,Completed,9.00012E+11,
ORD-2519,2026-10-29,Example Mart,"Denver, CO",00063,Toner Cartridge,3,420.00,Completed,900093974724,
ORD-6688,2026-09-06,Mock Trading,"Dallas, TX",20417,Dry-Erase Markers 12-Pack,2,72.00,Completed,900032940588,
ORD-4045,2026-10-15,Fictional Paper Store #2,"Bangor, ME",00098,Desk Stapler 6-Pack,9,675.00,Completed,900040461168,
ORD-2614,2026-09-27,Fictional Paper Store #2,"Chicago, Illinois",00731,Copy Paper Letter 10-Ream Case,12,780.00,Completed,900089444858,
ORD-9572,2026-09-19,Sample Office Supply,"Dallas, TX",20417,Dry-Erase Markers 12-Pack,19,684.00,Cancelled,,
ORD-3883,20261011,Sample Office Supply,"Bangor, ME",00063,Toner Cartridge,6,840.00,Completed,900083378563,
ORD-3324,2026-10-15,Test Mercantile,"Dallas, TX",20417,Dry-Erase Markers 12-Pack,4,144.00,Completed,900094589701,
ORD-5152,2026-10-05,Example Mart,"Chicago, IL",10031,Shipping Labels Case,13,"1,170.00",Canceled,,
ORD-2535,2026-10-09,Fictional Paper Store #2,"Denver, CO",10031,Shipping Labels Case,16,"$1,440.00",Completed,900039845605,
ORD-8499,2026-09-06,Sample Office Supply,"Portland, ME",00412,Ballpoint Pens 12-Box Case,2,96.00,Completed,900012402098,
ORD-2684,2026-09-29,Sample Office Supply LLC,"Denver, CO",00063,Toner Cartridge,8,"1,120.00",Completed,900024168896,
ORD-9619,2026-09-27,Example Mart,"Denver, CO",01205,File Folders Box of 100,5,160.00,Completed,900083818598,
ORD-3970,2026-10-19,Mock Trading Co.,"Portland, ME",20417,Dry-Erase Markers 12-Pack,7,252.00,Completed,900002157288,
ORD-4679,2026-09-22,Mock Trading,"Bangor, ME",00256,Sticky Notes 12-Pack,7,168.00,Completed,900035475260,
ORD-2400,2026-10-05,Mock Trading,"Portland, OR",00256,Sticky Notes 12-Pack,4,96,Completed,900047885100,
ORD-7763,2026-09-25,Example Mart,"Chicago, IL",00731,Copy Paper Letter 10-Ream Case,14,910.00,Completed,900042613815,
ORD-9088,2026-09-28,Mock Trading,"Chicago, IL",00098,Desk Stapler 6-Pack,3,225.00,Completed,900083158019,
ORD-1317,2026-10-07,Fictional Paper,"Dallas, TX",00063,Toner Cartridge,2,820.00,Completed,900034745585,
ORD-1457,2026-09-01,Test Mercantile,"Bangor, ME",10031,Shipping Labels Case,10,900.00,Completed,900093210280,
ORD-5909,2026-09-02,Fictional Paper Store #2,"Chicago, IL",00256,Sticky Notes 12-Pack,9,216.00,Completed,900064180383,
ORD-1111,2026-10-24,Fictional Paper Store #2,Denver CO,00412,Ballpoint Pens 12-Box Case,3,144.00,Completed,900026577569,
ORD-8971,2026-10-09,Sample Office Supply,Dallas TX,10031,Shipping Labels Case,2,180.00,Completed,900047594607,
ORD-1690,"September 28, 2026",Example Mart,"Bangor, ME",00412,Ballpoint Pens 12-Box Case,10,480.00,Completed,900024181627,
ORD-4767,2026-09-19,SAMPLE OFFICE SUPPLY ,"Dallas, TX",00731,Copy Paper Letter 10-Ream Case,5,325 USD,Completed,900020188397,
ORD-2933,"September 16, 2026",Fictional Paper Store #2,"Portland, ME",01205,File Folders Box of 100,2,64.00,Completed,900053495356,
ORD-5910,2026-10-29,Mock Trading,"Chicago, IL",10031,Shipping Labels Case,18,"1,620.00",Complete,900013823785,
ORD-4555,2026-10-24,Example Mart,"Denver, CO",00098,Desk Stapler 6-Pack,14,"1,050.00",Completed,900046839275,
ORD-8188,2026-10-17,Sample Office Supply,Bangor ME,00098,Desk Stapler 6-Pack,20,"1,500.00",Completed,900043379696,
ORD-2923,2026-10-14,Fictional Paper Store #2,"Dallas, TX",20417,Dry-Erase Markers 12-Pack,6,216.00,Completed,900024605296,
ORD-3639,2026-09-04,Example Mart,"Portland, ME",00731,Copy Paper Letter 10-Ream Case,20,"1,300.00",Completed,900039743962,
ORD-1699,2026.9.10,Test Mercantile,"Portland, OR",00098,Desk Stapler 6-Pack,17,"1,275.00",Completed,900029017537,
ORD-7546,2026-09-11,Test Mercantile,"Bangor, ME",10031,Shipping Labels Case,6,540.00,Complete,900017625021,
ORD-8703,2026-10-15,Mock Trading,"Denver, CO",20417,Dry-Erase Markers 12-Pack,3,108.00,Completed,900008565957,
ORD-1146,2026-10-08,Fictional Paper Store #2,"Bangor, ME",00063,Toner Cartridge,8,"1,120.00",Completed,900029925054,
ORD-7218,2026-10-08,Fictional Paper,"Portland, ME",00063,Toner Cartridge,11,"1,540.00",Completed,9.00047E+11,
ORD-7113,2026-10-01,Sample Office Supply,"Portland, ME",01205,File Folders Box of 100,8 pcs,256.00,Completed,900047007614,
,,Batch 2 subtotal,,,,,"31,028.00",,,
,,Grand total,,,,,"76,493.00",,,
,,,,,,,,,,

Leave a Reply

Your email address will not be published. Required fields are marked *