If you are referring to Excel's ability to read in delimited text files, JMP can do the same thing. Click on File > Open and select Files of type: Text Files (*.txt; *.csv; *.dat; *.tsv). Your best bet is to use the option Data with preview. This will bring up a screen allowing you to specify all kinds of options, such as fixed width fields or delimited, the delimiter to use (if delimited fields), end of field character, etc.