Excel supports data import from various sources such as text files, databases, and other spreadsheet formats. Data can be exported to formats like CSV, PDF, and HTML. Users can use the "Data" tab to manage external data connections and import/export operations.