Current location - Education and Training Encyclopedia - Resume - How to fill the data in EXCEL into the table of WORD in batches?
How to fill the data in EXCEL into the table of WORD in batches?
1. After opening a text document, make a table first, and then find the "Tools" button in the toolbar in the document.

2. After clicking, a command menu will pop up, where you can find the mail merge toolbar. Click the mail merge toolbar, and the toolbar as shown in Figure 2 will appear.

3. Find the icon shown below in this toolbar, and then click Open Data Source.

4. Then a selection box will appear, select the excel file of the data source to be imported, and click OK.

5. Then click the cell in the data document table to be imported as shown below, so that the cursor keeps flashing in this cell, and then click the icon "Insert Merge Field" in the second picture.

6. Then select the item to be input, click OK, and you will see the name appear in the cell of the second picture. Date of birth and gender can also be entered in the same way.

7. Then click "Merge to New Document", as shown in the following figure. Select the starting line and ending line of the data to be imported in the "Merge to New Document" setting, and click "OK".

8. Then you will find that all the data in excel are imported into the document table.