HSN in GST return

we need to file HSN wise summary of sales in GSTR-1 . what is the simplest way of preparing data for maintaining HSN wise details, because sometimes a dealer has been dealing in more than 1000 products.