File Format & Compatibility

Fix Excel Column Width and Formatting Lost After Saving

Huma Ashraf ChHuma Ashraf Ch Nov 18, 2026 870 views

Question details

The user needs to preserve column widths, font colors, and other formatting when saving an Excel workbook.

Fix Excel Column Width and Formatting Lost After Saving
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the formatted workbook

In Excel, open the copy that still displays the column widths, colors, and other formatting you want to keep.

2
Choose a workbook format

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.

3
Save and verify

Click Save, then reopen the saved .xlsx or .xlsm file to check that the formatting is present.

Save the formatted workbook as XLSX or XLSM
Keep CSV as a separate copy: CSV stores plain text data, not column widths, font colors, or other spreadsheet formatting. If you need a CSV for another system, keep the formatted Excel workbook as well.
Format and save spreadsheets with WPS

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. 1. Open the spreadsheet: Launch WPS Spreadsheets and use Open to select your CSV or formatted Excel workbook.
  2. 2. Adjust the formatting: Drag the column boundaries to set widths and use the Home tab to change font colors or other formatting.
  3. 3. Save as an Excel workbook: Select Menu > Save As, choose Excel Workbook (*.xlsx), and click Save.
  4. 4. Check the saved file: Reopen the saved XLSX file in WPS Spreadsheets and confirm that the layout and formatting are present.
Save column widths, font colors, and other formatting in an XLSX workbookOpen and save Microsoft Excel XLSX filesUse familiar spreadsheet formatting controlsWork with spreadsheets using a free, easy-to-use office suite
microsoft office alternative - wps office

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.