Version History Issues

Export All Appended Text History from a SharePoint List

Bushra ParveenBushra Parveen Nov 22, 2026 868 views

Question details

The user needs to export the complete history of comments stored in an appended SharePoint text column.

How to Export All Appended Text History from a SharePoint List
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the list item

In the SharePoint list, locate the item containing the appended comments and open its menu using the three dots.

2
View its versions

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.

3
Copy the history

Copy each relevant comment into an Excel worksheet or another spreadsheet, along with the item ID and version date if needed.

4
Save the export

In the spreadsheet, use File > Save As to save the collected history as an XLSX or CSV file.

Copy appended comments from SharePoint version history
Only available versions can be recovered: Repeat the process for each item. Versions already removed by version limits or retention settings will not appear in version history.
Free Microsoft Office alternative

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.

Open and organize exported comment histories in a spreadsheet.Compatible with Microsoft Excel XLSX files and CSV exports.Familiar spreadsheet interface for a straightforward transition from Microsoft Office.Free and lightweight office suite.
microsoft office alternative - wps office

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.