Excel Data Processor with PDF Export

Upload three Excel files to process data with BO, SO, and PO conditions

Processing Instructions

1. File 1: Extract data based on column 3 content:
   • If 'BO' in column 3 → get data from column 10
   • If 'SO' in column 3 → get data from column 8
   • If 'PO' in column 3 → get data from column 8
   Column 2 and column 6 remain as is.
2. File 2: Search for column 1 data from File 1 in File 2, calculate row-wise sum of columns 4-11, and add to new file (4th column).
3. File 3: Extract date from column 5 based on column 2 code and add to new file based on matching values from column 1.
4. Final Step: Calculate sum of columns 4 and 5, place result in column 6.

BO → Column 10

SO → Column 8

PO → Column 8

First Excel File

Upload the first Excel file for data extraction based on BO/SO/PO conditions

Second Excel File

Upload the second Excel file for column sum calculation (columns 4-11)

Third Excel File

Upload the third Excel file for date extraction from column 5

Processed Data

Search Information

Searching column 1 data in second file...

Debug Information

Column 1 (BO/SO/PO Data)	Column 2 (Original 2nd Column)	Column 3 (Original 6th Column)	Column 4 (Sum from File 2)	Column 5 (Date from File 3)	Column 6 (Total: Col4 + Col5)
Upload three Excel files and click "Process Files" to generate the report

Excel Data Processor with PDF Export | All processing happens in your browser

Note: No data is uploaded to any server - everything processes locally