You need to write custom solution for that. There is no OOTB solution available.
1. Read CSV/EXCEL
2. Creat node
3. set property
You can use scheduler if the nodes has to be created iteratively or Listener when file is changed or on demand.
You can create nodes only in Author and later publish on publishers
You need to write custom logic to read excel file and create node as per your requirement means name of th node and set property accordingly. Better to run this job as scheduler/sling job on Author and then publish as per your requirements.