Below are some tips on exporting Supplyit report data to Excel which will make it easier for you to manage the worksheet.
After selecting Excel as the format for the report you will also want to check Hide header under View. Doing this removes the extra columns that are inserted in the export.
Numbers can be stored in cells as text, after you import data from Supplyit. Please refer to the link for assistance in converting to number format.