How to import multiple data using Data Connector

Use Data: Connect Multiple Files menu to import multiple specified files or all files in specified folder into same or different books. Check "Open Dialog for First File" to get a chance to customize settings for 1st file and other files will be imported using the the same settings.