Can I read data from Excel, CSV or other custom delimited files?

Yes, Pentaho data integration provides a connector to almost any format of data, or atleast capability to build one. Out of the box Pentaho support Excel, CSV, XML, JDBC, ODBC, Big Data Storages like Hadoop, NoSQL storage like Cassandra, Mongo, Marklogic, SAP and more.