'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Project for the Web Excel Export Missing Completed and Checklist Columns
Question details
Users are trying to generate project status reports but find that specific data columns are no longer included in the downloaded file.
- Product
- Microsoft Project for the Web
- Device & OS
- not provided
- Scenario
- Exporting project task data from Project for the Web to an Excel workbook for status reporting and tracking.
- Observed behavior
- The "Completed" and "Checklist Items" columns, which were present in earlier exports, are now missing from the generated Excel file.
Run a fresh test export from your Project for the Web dashboard to confirm whether the specific 'Completed' and 'Checklist Items' columns are consistently missing from the current Excel workbook.
Use Microsoft Planner Export as a Workaround
Since Project for the Web exports currently omit these fields, exporting comparable data from Microsoft Planner can provide the missing checklist and completion status.
Microsoft Planner is tightly integrated with Microsoft 365 groups and often shares task structures with lightweight projects. Its export functionality currently retains the columns that are missing from Project for the Web.
Navigate to Microsoft Planner via your Microsoft 365 dashboard and open the plan associated with your project tasks.
Click the three dots (...) at the top of the plan interface and select 'Export plan to Excel' from the dropdown menu.
Open the newly downloaded Excel file and verify that the 'Completed' and 'Checklist Items' data fields are present for your reporting.
Open a Microsoft Support Case
Report the missing fields directly to Microsoft Support to have the issue tracked, investigated, and potentially restored in future updates.
Manage Your Exported Project Data with WPS Office
While waiting for Microsoft to restore the missing project columns, you can seamlessly open, view, and analyze your available exported project data using WPS Office. It provides a lightweight, free alternative to Microsoft Office with high compatibility for all your spreadsheet needs.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your device.
- 2. Open WPS Spreadsheet: Launch the WPS Office suite and click on the 'Spreadsheet' module to open the Excel alternative.
- 3. Import Project Data: Click 'File' > 'Open' and select your downloaded Project or Planner export file to start formatting your status reports.
Frequently Asked Questions
Why did the 'Completed' and 'Checklist Items' columns disappear from my Project for the Web export?
Microsoft frequently rolls out background updates to its cloud services. These columns appear to have been removed or altered due to a recent update in Project for the Web's export functionality. It is recommended to report this via a Microsoft Support ticket so their engineering team can track it.
Can I get checklist items exported through Microsoft Planner instead?
Yes. If your project is linked to a Microsoft 365 group and accessible via Planner, exporting the plan directly from Microsoft Planner to Excel still includes the completion status and checklist details that are currently missing from Project for the Web.
Will Microsoft restore these missing columns in future updates?
Microsoft relies heavily on user feedback and support cases to identify bugs or missing features. Logging a formal support request via the Microsoft 365 Admin Center significantly increases the likelihood that the product team will investigate and restore these fields.
