paste list into excel each word a column

My example uses the website IrishGenealogy.ie. I have discovered a magic way to separate those rows into separate columns. So then you get to spend the next hour or more copying the contents for each record into separate columns. The next record occupies A5, A6, A7, and A8. One name record might occupy 4 lines, cells A1, A2, A3, and A4. Yes, you can copy the results from your database search into Excel, but it will drop everything into Column A, with parts of each individual record on separate lines. I’ve explained how to do this on my blog at īut some websites have a “captcha” which foils the import using the Get External Data from Web feature.

With other websites, such as, you can use the “Get External Data from Web” feature on the data ribbon to import the data into Excel. Some websites such as FamilySearch will allow you to directly export from the website into a spreadsheet. Once you have the data in your spreadsheet you can sort and filter it to your heart’s content to crack it open and find the patterns that will help you breakdown your brick walls. It’s great to be able to do a search in a database and input the results into a spreadsheet for further analysis.

Paste list into excel each word a column