I will merge CSV files into one excel workbook with source checks
About this Gig
I will merge up to 7 CSV files with the same column structure, with a maximum of 100 data rows across all files, into one static Excel workbook. I will check row counts, quantity totals, and monetary totals against each source file. I will flag suspected duplicates and conflicting records for your review and keep those rows in the workbook. Automatic refresh is outside the scope. Delivery is in 5 days and includes 1 revision within the original scope.
FAQ
Which file formats do you support?
Please send UTF-8 .csv files with the same column headers and layout. I deliver one static Excel (.xlsx) workbook. Please export spreadsheets to CSV before sending them.
How many files and rows can I send?
The package covers up to 7 CSV files and 100 data rows in total across all files. Header rows do not count toward the limit.
How do you handle suspected duplicates and conflicts?
I use the matching rules we agree on, retain the original rows, and flag suspected duplicates and conflicting records for review. Complex data repair is outside the scope.
Does the workbook refresh automatically?
The workbook is a one-time snapshot of the files you provide. Automatic refresh and system integration are outside the scope.
What do the 5-day delivery and one revision cover?
The 5-day delivery applies to the agreed scope once complete requirements are submitted. One revision covers corrections to the agreed checks or layout using the same files. New files and new rules are outside that revision.

