Any easy way to bulk import 800 products into Shopify?

So I have a bridal boutique client who I am setting up a Shopify store for and they are wanting to import around 800 prom dresses. The issue I am having is I have around 7 total designers and each has either given a PDF price sheet that consists of style, price, color and material or a excel spreadsheet that are all formatted differently.

I understand Shopify has the CSV import functionality, but having to copy and paste over 800 dresses each with specific colors, styles and different pricing seems like a very tedious and time consuming task. There HAS to be an easier way, it’s as if it would almost be “easier” to just add these products one by one not using the CSV sheet.

Any ideas on what would be easiest? Really could use some help on this one instead of spending days importing each dress one by one.

Thank you!