I have several hundred records that I would like to paste/import into Excel. Currently the records are listed vertically in Word, each with what will become the column headings and a colon, then the unique data. I have pasted a sample below, with the column headings in bold (each of the records includes the same column headings, even if there is no unique data for the record)
~Company: XYZ Company
Structure: Sole Proprietor
Owners: XYZ Jones
Primary Contact: John Jones
Email: jjones@jones.com
Alt. Email:
Business Phone: 1111111111
Cell Phone:
Home Phone:
Fax:
Address: 1234 Main St
Great City, ST 09876
United States
Description: XYX Description. XYX Description. XYX Description. XYX Description. XYX Description. XYX Description.
Website: www.jjonescompany.com
~Company: XYZ Company2
Structure: Sole Proprietor2
Owners: XYZ Jones2
Primary Contact: John Jone2
Email: jjones2@jones.com
Alt. Email:
Business Phone: 2222222222
Cell Phone:
Home Phone:
Fax:
Address: 1234 Main St
Great City, ST 09876
United States
Description: XYX Description. XYX Description. XYX Description. XYX Description. XYX Description. XYX Description.
Website: www.jjonescompany2.com
I have attached a sample file with the columns identified.
What is the easiest way to get all of the records in Excel?
Bookmarks