Welcome to this Excel Jet Consult blog post. In this tutorial, we are going to learn how to use the new Get Data From Picture which is available in M365 for Excel, Mac for Excel and Excel on the Web versions to Get Data from Multiple Pictures and Analyze with PivotTable. Let’s get started
Video
Sample Dataset
In the screenshots, we have two sales data for year 2020 and 2021 respectively. Our goal is to use the Get Data From Picture connector to get the datasets into Excel. Then, we append the two data and analyze using PivotTable.
Get Data From 2020 and 2021 Datasets
The Get Data From Picture connector is located in the Get & Transform Data group of the Data tab.
- Click on From Picture and then Picture From File respectively
- Browse through the picture location and double-click to select
- Data from Picture task pane opens to the right of the window
- Then, we can easily go through the data by making necessary review and corrections. After doing that,
- Select the preferred cell to dump the data and lick on Insert Data
From the screenshot below, we have the data in the spreadsheet
- To get the 2021 dataset, repeat all the steps above by selecting the 2021 from the location
- To append the 2021 below the 2020 dataset, select the last cell below 2020 and drop the data there.
- Then, delete the 2021 headings
From the screenshot below, we can see that the 2020 and the 2021 data has been appended. Therefore, we can further analyze using the PivotTable
From the screenshot below, we have a PivotTable report showing Product by Sum of Units
See you in the next tutorial