Why would we import data from an Excel workbook if we can just open it? The main reason is to take advantage of the transformations we can do using Get & Transform. We will show this by using a file containing real data from the Titanic passengers, which is often used to test machine learning classification models and predict whether a given passenger survived the tragedy or not.
Let's follow some simple steps to load and transform the data. While in a new workbook, follow these steps:
- Click on Data.
- Navigate to Get Data | From File | From Workbook, as shown in the following screenshot:
![](https://static.packt-cdn.com/products/9781789345377/graphics/assets/823c4c39-81d8-4aeb-83ac-3f3bb56182fd.png)
The preview window is slightly different to the one we see when opening a CSV file, as you can see in the following screenshot:
![](https://static.packt-cdn.com/products/9781789345377/graphics/assets/7c7c2b86-db46-4c7b-b4e0-555415581841.png)
In the left part of the preview, you can see a folder named titanic.xls, which represents the file, and below that...