Excel is a powerful tool that allows you to organize and analyze data effectively. While copying and pasting tables from websites directly into Excel is a common method, sometimes tables are embedded within images or presented as pictures, making it challenging to extract the data. In such cases, the “Data from Picture” function in Excel can be a lifesaver. This article will guide you through the process of using the Data from Picture function to copy a table from a website image and paste it into Excel.
e.g. I want to copy the top 10 holdings table for this ETF to an excel
Step 1: Open the Website and Capture the Table Image
Begin by opening your preferred web browser and navigating to the website containing the table you want to copy. Once on the website, locate the table that is presented as an image. Use a screenshot tool or the built-in screen capture function on your device to capture the image of the table. Ensure that the image is clear and legible.
Step 2: Open Excel and Activate the Data from Picture Function
Next, open Microsoft Excel on your computer. Create a new workbook or open an existing one where you want to paste the table. Click on the “Data” tab in Excel’s menu bar. Look for the “From Picture” option, which is usually located in the “Get & Transform Data” section. Click on the “From Picture” button to activate the Data from Picture function.
Step 3: Verify and Convert the Table into Excel Format
Once you are satisfied with the table recognition, verify that all the data in the table is correctly identified. Ensure that each column is labeled correctly, and the data is accurately assigned to the corresponding cells. If any errors are detected, make the necessary adjustments using Excel’s editing tools. Once the table is verified and error-free, click on the “Insert Data” button to convert the recognized table into an Excel format.
In this case, the red cell means that it requires reviewing.
You can choose to edit or accept the values.
You can also choose to insert without reviewing the data by clicking on Insert Data -> Insert Anyway.
Step 4: Save and Store Your Excel Workbook
Once you have successfully copied the table from the website image and formatted it in Excel, it’s crucial to save your workbook. Click on the “File” tab in Excel’s menu bar and choose the “Save” or “Save As” option to save your file to a specific location on your computer or cloud storage. Remember to provide a meaningful name for the workbook and select a suitable file format, such as .xlsx, for compatibility and future accessibility.
In conclusion, the Data from Picture function in Excel is a valuable feature that allows you to extract and convert tables from website images into an Excel format