Take a screenshot of the table, then click Data > From Picture > Picture From Clipboard. If necessary, crop the image.Īvoid images that depict data from an angle - the perspective should be head-on and focused. The image should only depict the data you want to import. There are two methods:Ĭlick Data > From Picture > Picture From File. In this case, you could parse the data using Excel substrings.Īs you see, this conversion process is a bit more complex than a straight mail merge using Excel and Word, but sometimes you need to take an alternate path when data isn’t in the optimal format.Important: Data from Picture in Excel for Windows is only supported on Windows 11 or Windows 10 version >=1903 (must have Microsoft Edge WebView2 Runtime installed).Ĭapture your data from an image. This example is different because you have multiple spaces. In addition, you might want to split Column B into Street Number and Street. Then, you could do a similar extraction process to separate the city. The easiest way is to use Excel to convert text to columns.

Excel offers several functions to parse text.įor example, you might want to split Column A into two fields representing First Name and Last Name.

However, you may want to adjust the results to suit your needs. In this example, our contact records were pretty uniform. Pasted address entries from Word Tweaking the Excel Addresses

In cell A1, press Ctrl + V and paste your data.

To get your data into Excel, highlight the table and press Ctrl + C.

If you don’t want the borders to show, you can go to Table Design and choose No borders.

Keep the default entry for Separate text at Paragraphs.

If you have a blank line between records, add 1.

In the Number of columns: field, select the number of lines that make one record.

From Word’s Table menu, select Convert Text to Table….Copy and paste the contacts or text you need to convert to a new document.Excel tables are a special feature that provides additional benefits. I should mention that although the word “table” is in both Microsoft programs, we’re not copying the data to an Excel Table. The Word table we’ll create has one row for each contact.

The reason we opted for a Word table is that the format is similar to an Excel spreadsheet.

How to copy word table to excel