I believe that SUAC has noted previously that the BSA is only sharing the format of the IA2 upload file with specific third-party software providers (it wasn’t specified which ones, but there was an approval process by BSA implied). It seemed pretty clear at the time that the BSA had no intention of sharing that formatting information with the general public (i.e. volunteers).
@Stephen_Hornak is likely on to a good line of inquiry. If the output file you have from your council is from Black Pug, there is an upload process in the Feature Assistant Extension (Feature Assistant - What is it?) that uses native Scoutbook features, rather than relying on the proprietary IA2 upload file format pathway. The best way to determine that is to reach out to your council summer camp contacts to find out what software (if any) they use. It’s possible that they simply have everything in an Excel file, and export to CSV to be more platform/software independent.