Insert data in text from file

Use this function to insert data from separate Excel cells into the body text in your Word document and constantly refresh it at a click.

A detailed explanation of the individual steps

This is how you insert a data in text object directly from a file into Word with firesys:

1. In Excel, highlight the cell that you want to add to Word as a linked data object in the body text.

2. Give the selected cell a name as otherwise it cannot be imported.

3. Save the Excel file.

4. Repeat this procedure for each cell that you want to add to Word as a linked data object in body text.

5. Go to Word and position the cursor where you want to insert the data in the document.

6. On the “*Content” tab in the “Excel Data” group on the “Insert” menu and select “From file” from the “Data in text...” area.
   → A data selection dialogue opens..

7. Select the Excel file containing the worksheet with the cell you require (“data source”).
   → The linktext assistant opens

8. The linktext assistant opens.

9. Select the worksheet containing the required cell.

10. Select the cell using the name that you defined in Excel.

11. If applicable, check “Set absolute value” if you want to add a number as an absolute value.

12. Click on "OK".
    → The linktext assistant inserts the data from the selected Excel cell into your body text.

See also

An overview of inserting Excel contents
Insert a table directly from the selected Excel range
Insert data in text from a file
Insert data in text directly from the selected Excel cell
Insert data in text directly from the selected Excel cell with options

Further contents

→ firesys website
→ Customer area
→ YouTube