Export All Appended Text History from a SharePoint List
Question details
The user needs to export the complete history of comments stored in an appended SharePoint text column.

- Product
- Microsoft SharePoint Lists
- Device & OS
- not provided
- Scenario
- A multiple-lines-of-text column uses Append Changes to Existing Text to record customer interactions.
- Observed behavior
- A standard list export returns the latest appended value rather than the complete history stored across item versions.
Confirm that list versioning is enabled in Settings > List settings > Versioning settings, and check whether retention or version limits have removed older entries. You also need permission to view the affected items and their version history.
Copy appended comments from SharePoint version history
Use this method for a small number of items when you can review and copy their histories manually.
In the SharePoint list, locate the item containing the appended comments and open its menu using the three dots.
Select Version history, then open the versions that contain the comments you need. Depending on the SharePoint interface, appended entries may also appear in the item details.
Copy each relevant comment into an Excel worksheet or another spreadsheet, along with the item ID and version date if needed.
In the spreadsheet, use File > Save As to save the collected history as an XLSX or CSV file.

Export item versions with a custom SharePoint script
Use a developer-built export when the list contains too many items to review manually.
Capture future comments in a separate SharePoint list
Use a workflow to make new comments easier to export; this does not recover existing history.
Review Exported SharePoint Comments in WPS Spreadsheets
WPS Office is a free, lightweight alternative for reviewing and organizing exported SharePoint comments. Its familiar interface and support for Microsoft Office formats make it easy to move existing spreadsheets into WPS. It does not retrieve SharePoint version history itself.

Frequently Asked Questions
Why does the SharePoint list export show only the latest comment?
With Append Changes to Existing Text enabled, SharePoint stores appended entries through item versions. A standard list export typically returns the latest field value instead of combining values from all versions.
Where can I find an item's previous comments?
In the SharePoint list, open the item's three-dot menu and select Version history. Open the available versions to review their values.
Can I recover comments after old versions have been deleted?
The version history export can retrieve only versions that remain available. Check your organization's retention and recovery options with a SharePoint administrator if older versions are missing.
Does turning off Append Changes to Existing Text delete old comments?
Turning off the setting does not automatically delete previous item versions. Check Settings > List settings > Versioning settings and your organization's retention policies before making the change.
Will a new Power Automate flow export previous comments?
A flow that copies new comments to a separate list captures entries going forward. Retrieve existing comments from item version history or use a custom version export.




