How to excel sharedstrings.xml too large: how to find and fix it
- Step 1Run Weight Analyzer — Upload your file — the analyzer reports sharedStrings.xml size in the category breakdown.
- Step 2Identify the large-text columns — Look for sheets with many unique long text values — product descriptions, URLs, free-text fields.
- Step 3Truncate or remove verbose text columns — If descriptions or URLs are needed only for reference, consider keeping them in a separate lookup file rather than in the main workbook.
- Step 4Convert text IDs to numbers — If a column contains numeric-looking text IDs (stored as text), convert them to numbers to move them out of the shared string table.
Frequently asked questions
Does Excel always use the shared string table?+
Numbers, dates, and booleans are stored inline in the XML (not in sharedStrings.xml). Only text strings go into the shared string table.
Does deleting rows reduce sharedStrings.xml size?+
Only if you save after deleting — and even then, orphaned string entries may linger until the workbook is fully recalculated and re-saved.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.