How to Turn a Screenshot Into Excel Data

Working with information successful Microsoft Excel tin beryllium time-consuming, particularly if you're manually copying information into your spreadsheet from different source. This is wherever the program's quality to import information from a screenshot comes successful handy. Here's however to usage this invaluable tool.

Step 1: Take and Copy a Screenshot

Let's accidental you person been sent the PDF below—a scan of a array containing assorted characters' names and addresses—and you privation to import and edit the information successful Microsoft Excel.

Because the record is simply a scanned PDF, you can't simply prime and transcript the text, arsenic the contented is stored arsenic representation information alternatively than "real text" data. You mightiness besides look the aforesaid contented erstwhile copying information from a website—if it was uploaded arsenic an image, determination wouldn't beryllium immoderate existent substance for you to transcript and paste.

Instead, you tin take a screenshot of the information and import it into your Excel worksheet. With the PDF, image, web page, oregon different root open, property PrtScn connected your Windows keyboard. If you don't person a PrtScn key, property Win+Shift+S, oregon if you're utilizing a Mac, property Shift+Cmd+4.

Then, click and resistance the crosshair to seizure the country you privation to copy.

The last portion of measurement 1 involves locating the screenshot you conscionable took, and copying the representation to your clipboard. In my case, I'm utilizing the default Windows 11 screenshot editor—Snipping Tool—and the transcript icon is successful the top-right corner.

Now, with the screenshot saved to your clipboard, you're acceptable to caput to Excel.

Step 2: Import the Image arsenic Data

Open the Microsoft Excel record wherever you privation the information to go. This tin beryllium a caller workbook oregon tab, oregon a worksheet that already contains data.

Then, with the copied information inactive connected your clipboard, unfastened the "Data" tab connected the ribbon, and click "Get Data." From there, hover implicit "From Other Sources" and "From Picture," and past click "Picture From Clipboard."

At this point, Excel analyzes the information you selected arsenic the root successful the Data From Picture sidebar. This tin instrumentality a fewer other seconds if the screenshot contains tons of data, but adjacent then, the process shouldn't instrumentality excessively long.

Step 3: Address Issues and Insert the Data

Once Excel has finished optimizing your imported screenshot successful the Data From Picture sidebar, it volition item immoderate imaginable issues wherever it isn't rather definite whether it has copied the information correctly. This is much apt to hap if the representation you captured contains unclear substance oregon breached lines.

Click "Review" to code the archetypal issue, and if you request to marque immoderate changes, prime the applicable compartment successful the sidebar, and edit the substance tract that appears. When you're blessed with this alteration (or if nary changes are necessary), click "Accept," and determination to the adjacent query by clicking the close arrow.

Once you've reviewed each the issues, the Review fastener turns gray, and the information is acceptable to beryllium inserted into your spreadsheet. To trigger this process, aft selecting the compartment successful your worksheet wherever you privation the upper-left compartment of the copied information to go, click "Insert Data."

Step 4: Format and Use the Data

At this point, the data-importing process is complete!

It's present up to you to determine however you usage this data. Personally, the archetypal happening I ever bash astatine this signifier is format the information arsenic an Excel table, truthful that I tin easy filter the accusation and use the file names successful formulas. You could besides alteration the cells' fig formatting, truthful that Excel recognizes numbers arsenic numbers, dates arsenic dates, substance arsenic text, and truthful on.

Points to Note When Converting Screenshots to Excel Data

Before you spell up and person screenshots to Excel information utilizing this method, instrumentality a infinitesimal to enactment these last pointers:

1. Data imported into Excel from a screenshot adopts immoderate formatting you person already applied to the applicable cells of your spreadsheet.
2. When I tested this method successful assorted scenarios, I recovered that the process works champion erstwhile the copied information has disposable borders betwixt each cell.
3. Any cells successful the copied representation containing information that runs implicit 1 enactment wrong the aforesaid compartment volition person into a continuous enactment successful Excel. To hole this, usage the TEXTSPLIT function oregon Excel's Text To Columns tool.
4. If the root array is formatted arsenic text, specified arsenic successful a PDF saved done Microsoft Word, usage your rodent to prime the information you privation to copy, and property Ctrl+C to transcript it. Then, successful Excel, property Ctrl+Alt+V if you're utilizing a Windows computer, oregon Ctrl+Cmd+V if you're connected a Mac, and click "Text" successful the Paste As Special dialog box.
5. Always cheque copyright restrictions oregon referencing requirements earlier copying different people's work.

---

Another mode to import tables from an online source to Microsoft Excel is to click "From Web" successful the Get And Transform Data radical of the Data tab. Then, you tin use Excel's Power Query Editor to negociate and alteration the imported data, and acceptable it to automatically refresh to accommodate to changes successful the source.