How do I transfer info from Excel to Word?

[ShowOfHands]

I have a word document which is basically a large table and needs populating with around 200 pieces of information. This information is contained within an excel spreadsheet. It's not as simple as copying and pasting as the info needs to go into different rows within the table in word.

Google keeps suggesting I use mail merge but I can't fathom how to do it. It keeps asking for recipients.

Is there a simple way to do it without typing it all out?!

Do you just need to mirror the layout of the spreadsheet into the table?

What if you paste in a different format? So copy the data and then right click on the word doc and choose a different paste option.

Yes, Mail merge is what you need. Where it says recipients, this basically just means te data from the spreadsheet. So you navigate to the spreadsheet and workbook where the data is. Then word will give you the option to insert merge fields - ie you tell it what field from the spreadsheet goes where in your Word table. Then you can preview results, and when you are happy merge it out.

If you are keeping the same number of cells with the info in the same place it is easy. Just highlight the same number of cells in the word table as excel cells you are moving and select paste options overwrite cells.
Are you trying to do something more complex and reorder the info being moved?

When you right click on the table to paste the data in select the rightmost option with the capital A

I’d open a new tab on Excel, copy and paste the rows into the layout required for Word and then copy and paste into a word document.

I really don’t like copying excel into word as I always find the formatting a PITA to make it look how I want.

HTH

I'm not an expert so could be wrong, but you should be able to use mail merge.
When you get to the recipients choose the option to match the fields. So for example name will be whatever your first column is called, address 1 will be whatever your second column is called.
Then you can set up the address format to match the order in which you want the information displayed eg address 1/ name / address 2 etc
It'll be a pain in the butt though!

No expert, but having learned from necessity I insert a small spreadsheet into Word.

Word > Insert > Spreadsheet (not Table)

It then drops a spreadsheet in which is blank and about 6 columns wide by 6 rows down. You then go to original Excel doc and copy your data from there into the new Excel spreadsheet within your Word document. It copies formula etc across too. You may need to format column widths etc, but you now have a Word document with an Excel spreadsheet embedded with all its functionality.