Start

Guides / Planners / Guide 12

Free guide

Turn a messy ERP export into a clean report

You will end with a clean table, a list of every change, and a short list of rows a person needs to check.

Difficulty: 1 of 5 stars, Starter+10 pts, points for this guide10-minute guide
ForPlannerAnalyst
  • TimeAbout 10 minutes
  • ToolsExcel, Claude
  • CostFree plan is fine to practice
Tools in this guideAll tools
  • Excel
    Work tool. Microsoft's spreadsheet app.
  • Claude
    AI app. An AI chat app. You type or paste text, or add a file, and it writes back.

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

  1. Open your export in Excel. Delete any column with prices, costs, or names you should not share.
  2. Select the rows you need and copy them. To practice, click Copy sample export above.
  3. Open claude.ai. Start a new chat.
  4. Click Copy prompt below. Paste it into the chat.
  5. Paste your export under PASTE EXPORT HERE. Press Enter.
  6. Read the change list first. Make sure every change is one you want.
  7. Read the flags. These are the rows a person needs to look at.
  8. Copy the CSV block. In Excel, paste it into cell A1 of a new sheet. Then use Data, Text to Columns, Comma.
  9. 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

ItemDescriptionWhseOn HandOn OrderDue DateBuyer
BK-1001BRACKET STEEL ZP0112500JM
WS-220WASHER 1/4 SS01405002026-11-14KL
WS-220WASHER 1/4 SS02150KL
HX-0750HEX BOLT 3/4-1001-122002026-11-20JM
GK-310GASKET EPDM 3IN0100
CL-045CLAMP HOSE 45MM013102026-11-09KL
PL-100PALLET 48X400320000TR

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

  1. Excel drops leading zeros, so warehouse 01 turns into 1. In Text to Columns, set that column to Text.
  2. Skipping the change list. Read it every time. AI can change a value you did not ask it to.
  3. Pasting cost columns into a personal AI account. Delete them first.

◆Ideas behind this guide

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.

Get your first win this week.

One minute. Three guides picked for your job.

Start my first win