Excel & CSV Data Processor
Instructions:
- Upload your Excel file (first file) containing columns A to F
- Upload your CSV file (second file) containing columns B and D
- Click "Process Files" to combine the data
- Review the results and download the colorful PDFs
Processing Logic: The tool will keep columns B and F from the Excel file, and add column D from the CSV file by matching column B (Excel) with column B (CSV). If no match is found, it will display '0'. Rows with blank F column or containing 'office name' will be excluded.
Upload Excel File (First File)
No file selected
Supported formats: .xlsx, .xls
Upload CSV File (Second File)
No file selected
Any CSV filename accepted: table-data.csv, table-data(1).csv, etc.
All Processed Data
BOs with at least 1 article booked
BOs with nil article booking
No comments:
Post a Comment