How to Fix an Excel Template with Collapsed ColumnsFollow
To rectify an excel template that has been saved incorrectly and has collapsed to a single column.
- Click Data tab at the top menu
- Click Text to Column
- Check Delimited on the window popup
- Click Next
- Check Comma as delimiters
- Review the preview data
- Click Finish
The file can sometimes be separated by semicolons depending on what the customer saved. In this case, review the data and select the delimiter to be semicolons.