an hour of spaghetti code later and it works!!
i started by pre adding all the my columns from the bills of materials from other projects i’ve made.
then i made inputs for every single column type except item no. and unit cost because they can be automated with tracked variables.
finally, a bit of code to write them into the .csv file and voila, it shows up perfectly in excel!