Tools in this guideAll tools
01The problem
Your ERP export comes out messy. Title lines at the top. Spaces in part numbers. Three kinds of dates. Numbers stored as text. The same row twice. You fix it by hand every week.
02What you need
- Claude at claude.ai. The free plan works for practice.
- Excel.
- Your export, open in Excel or saved as a CSV file.
- About 10 minutes.
Is the data safe to use? Exports can hold costs, customer names, and supplier names. Delete those columns first, or use the sample below.
Sample data / made-up inventory export, not a real company
INVENTORY STATUS REPORT Run: 11/03/2026 06:02 User: SAMPLE Item,Description,Whse,On Hand,On Order,Due Date,Buyer bk-1001 ,BRACKET STEEL ZP,01,"1,250",0,,JM BK-1001,BRACKET STEEL ZP,01,"1,250",0,,JM WS-220,WASHER 1/4 SS,01,40,500,11/14/26,KL ws-220 ,WASHER 1/4 SS,02,15,0,,KL HX-0750,HEX BOLT 3/4-10,01,-12,200,2026-11-20,JM GK-310,GASKET EPDM 3IN,01,0,0,, CL-045,CLAMP HOSE 45MM,01,310,,11/9/2026,KL PL-100,PALLET 48X40,03,"2,000",0,,TR *** END OF REPORT ***
03Steps
- Open your export in Excel. Delete any column with prices, costs, or names you should not share.
- Select the rows you need and copy them. To practice, click Copy sample export above.
- Open claude.ai. Start a new chat.
- Click Copy prompt below. Paste it into the chat.
- Paste your export under PASTE EXPORT HERE. Press Enter.
- Read the change list first. Make sure every change is one you want.
- Read the flags. These are the rows a person needs to look at.
- Copy the CSV block. In Excel, paste it into cell A1 of a new sheet. Then use Data, Text to Columns, Comma.
- Keep the prompt. Next week, you only paste the new export.
Placeholder Real screenshot of step 8 goes here Text to Columns in Excel, with an orange arrow on Comma.
04Copy this
The prompt (what you type in)
You are helping a planner clean an ERP export. Do these steps: 1. Remove report title lines, run dates, blank lines, and "end of report" lines. Keep the column header row. 2. Trim extra spaces. Make part numbers all capital letters. 3. Write every date as YYYY-MM-DD. 4. Write numbers as plain numbers with no commas. 5. If two rows are exactly the same after cleaning, keep one and tell me which one you removed. The same part in a different warehouse is not a copy. 6. Do not fill in blank cells. Leave them blank. 7. Do not change any other value. Then give me three things: A. The clean table as CSV, in one code block. B. A list of every change you made, row by row. C. A list of rows a person should check, and why. Flag stock below zero, zero stock with nothing on order, and blank cells that do not fit the rest of the row. PASTE EXPORT HERE:
05What good looks like
With the sample export, a good answer has these three parts. (Sample data, checked by hand.)
A. The clean table
| Item | Description | Whse | On Hand | On Order | Due Date | Buyer |
|---|---|---|---|---|---|---|
| BK-1001 | BRACKET STEEL ZP | 01 | 1250 | 0 | JM | |
| WS-220 | WASHER 1/4 SS | 01 | 40 | 500 | 2026-11-14 | KL |
| WS-220 | WASHER 1/4 SS | 02 | 15 | 0 | KL | |
| HX-0750 | HEX BOLT 3/4-10 | 01 | -12 | 200 | 2026-11-20 | JM |
| GK-310 | GASKET EPDM 3IN | 01 | 0 | 0 | ||
| CL-045 | CLAMP HOSE 45MM | 01 | 310 | 2026-11-09 | KL | |
| PL-100 | PALLET 48X40 | 03 | 2000 | 0 | TR |
B. The change list
- Removed the 2 title lines, the blank line, and the end line.
- BK-1001: trimmed spaces, made capitals, 1,250 to 1250.
- Removed the second BK-1001 row in warehouse 01. It was an exact copy.
- WS-220, warehouse 01: 11/14/26 to 2026-11-14.
- WS-220, warehouse 02: trimmed spaces, made capitals. Kept, because it is a different warehouse.
- CL-045: 11/9/2026 to 2026-11-09.
- PL-100: 2,000 to 2000.
C. The flags
- HX-0750: on hand is -12. Stock below zero. Check counts and open moves.
- GK-310: zero on hand, nothing on order, and no buyer. Who owns this part?
- CL-045: On Order is blank, but there is a due date. Blank is not zero. Check the PO.
06Common mistakes
- Excel drops leading zeros, so warehouse 01 turns into 1. In Text to Columns, set that column to Text.
- Skipping the change list. Read it every time. AI can change a value you did not ask it to.
- Pasting cost columns into a personal AI account. Delete them first.
◆Ideas behind this guide
- Use AI to build the tool: get the clean-up rules once, then let Excel do the work.
- When not to use AI: counting is a job for Excel, not a chat.
- Why AI fails on long tasks: check each step instead of trusting the final table.
07Next guide
Compare three supplier quotes Ready now
08Safe use
Before you use real data
Use sample or cleaned data when you learn. Check AI output before you act on it. Read the safe use notes.