Tech Tip – Convert Picture Of A Data Table To A Usable One In Excel

Microsoft Excel is still one of the world\’s most widely used data tools and a new feature (for desktop), \’Data from Picture\’, means that you can now import a picture of a data table and convert it into a usable one within Excel. Here’s how:

– Save a cropped-down screenshot of an excel data table.

– Open Excel and go to the ‘Data’ tab (top menu).

– Select the (new) \’From Picture\’ option (top menu).

– From the drop-down options choose \’Picture from file\’.

– Select and click \’insert\’. Right hand side of the screen will show as collecting and preparing data.

– Click \’Review\’ or \’Insert Anyway\’ if happy you’re happy that the table produced is accurate.