Hi,
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
Arun Patidar