Symptoms
After exporting metadata to excel, you see this error message:
The value of the column 'text' was truncated because its length exceeded the limit for an Excel cell value.
Error code
|
Details
When exporting metadata you are offered two formats : Excel files (.xlsx) or CSV files (.csv)
Both can be opened with Excel. This error occurs when exporting .xlsx files containing cells with more that 32k characters.
Excel has a limitation on the number a characters that a single cell can handle, so when opening either file format with Excel, cells with more than 32k characters will be truncated. This means you will only see the first 32k characters in Excel, though the cell itself can still contain more than 32k characters.
Sharegate has the same limitation as Excel, and cannot export cells with more than 32k characters without truncating them. However data loss will only occurs for .xlsx files; .csv can be exported with cells containing more than 32k characters without losing data.
Solution
We recommend exporting to .csv and not .xlsx to avoid any data loss.
Note: You can use excel to edit a .csv file with truncated cells, but we recommend only editing non-truncated cells. If you edit a truncated cell you will lose the truncated data.