Excel Importing Help

[CherryxDarling]

Ok so I have a list of about 4,000 contacts that I need to put into an Excel spreadsheet. It was sent to me in a Word document in this format:

John Smith
123 Main St
Los Angeles, CA 90605
(555) 555-5555
name@email.com

So far I've just been typing them in 1 by 1, not realizing how many I actually have to do. Can anyone tell me a fast way to do this without having to type them in by hand? I have a scanner that will scan to PDF, as well as a NeatWorks scanner (which hasn't proven to be useful with anything except business cards).

 

[John_w]

Have you tried selecting all and copying in Word and pasting into Excel? That should put all the data in a single column in Excel. Then record a macro with relative reference to move each line to a separate column. This should work as long as each record has 5 lines as shown in your example, otherwise write a custom macro to tabulate the records.

 

[CherryxDarling]

Have you tried selecting all and copying in Word and pasting into Excel? That should put all the data in a single column in Excel. Then record a macro with relative reference to move each line to a separate column. This should work as long as each record has 5 lines as shown in your example, otherwise write a custom macro to tabulate the records.

Ok so how would I set up the macro? I've never used macros before and would greatly appreciate a tutorial of some kind. Thanks for your help!

 

[John_w]

Search for "Excel Macro Recorder". Get started by doing the manual steps to tabulate one record (contact) with the Macro Recorder running.

If all records (contacts) have the same number of lines (you haven't said), then a macro recorded with relative references (instead of absolute references) starting on the first row of one record and finishing on the first row of the next record will tabulate all records by repeatedly pressing the shortcut key assigned to the macro.