Fix Excel Column Width and Formatting Lost After Saving
Question details
The user needs to preserve column widths, font colors, and other formatting when saving an Excel workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A formatted spreadsheet is saved and reopened.
- Observed behavior
- After the file is saved as CSV and reopened, the data appears without the original column widths, colors, and other formatting.
Check the file extension in the file name or under File > Save As. If it is .csv, look for an existing .xlsx or .xlsm version that may still contain the original formatting.
Save the formatted workbook as XLSX or XLSM
Use an Excel workbook format to retain formatting and column widths instead of saving only as CSV.
In Excel, open the copy that still displays the column widths, colors, and other formatting you want to keep.
Select File > Save As, choose a location, and select Excel Workbook (*.xlsx) as the file type. If the workbook contains macros you need to keep, select Excel Macro-Enabled Workbook (*.xlsm) instead.
Click Save, then reopen the saved .xlsx or .xlsm file to check that the formatting is present.

Reapply formatting when only a CSV copy remains
Use this approach if no formatted workbook or earlier version is available.
Preserve spreadsheet formatting with WPS Office
Open your spreadsheet in WPS Spreadsheets, adjust its formatting, and save it as an Excel workbook rather than CSV to retain the layout.
- 1. Open the spreadsheet: Launch WPS Spreadsheets and use Open to select your CSV or formatted Excel workbook.
- 2. Adjust the formatting: Drag the column boundaries to set widths and use the Home tab to change font colors or other formatting.
- 3. Save as an Excel workbook: Select Menu > Save As, choose Excel Workbook (*.xlsx), and click Save.
- 4. Check the saved file: Reopen the saved XLSX file in WPS Spreadsheets and confirm that the layout and formatting are present.

Frequently Asked Questions
Why did my column widths disappear when I reopened a CSV?
CSV stores plain text data, not column widths or other spreadsheet formatting. Save a formatted copy through File > Save As as an Excel Workbook (*.xlsx) to retain the layout.
Can I recover font colors from a CSV file?
No. CSV does not store font colors. Open an earlier formatted XLSX or XLSM copy if one exists, or reapply the colors using Excel's Home tab.
Should I save my workbook as XLSX or XLSM?
Choose Excel Workbook (*.xlsx) for a standard formatted spreadsheet. If the workbook contains macros you need to keep, choose Excel Macro-Enabled Workbook (*.xlsm) under File > Save As.
Will converting my CSV to XLSX restore the old formatting?
No. Converting the CSV to XLSX preserves formatting you add afterward, but it cannot recover column widths or colors that were never stored in the CSV.




