Applies ToProject Online Desktop Client Project Standard 2024 Project Professional 2021 Project Standard 2021 Project Professional 2019 Project Standard 2019 Project Professional 2016 Project Standard 2016 Project Professional 2013 Project Standard 2013

You can insert data from Excel into Project as a linked object that will be updated dynamically by changes made in the source file. You can also embed the data independent of its original file.

  1. In Excel, select the data (such as fields, cells, records, or rows) that you want to link or embed, and then choose Copy.

  2. In Project, on the View tab, choose the view that you want.

    To use another view, select the arrow on Other Views, then select More Views. From the list in the More Views dialog, select the view that you want, and then click Apply.

  3. In Project, select the location where you want to insert the data.

  4. Right-click to select Paste Special.

  5. Do one of the following:

    • To paste the data without a link to the source document, choose Paste.

    • To link the inserted data to the data in the source document, choose Paste Link.

  6. From the list, select Text Data, and then choose OK.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.