Office 365 (Excel 2016 for Win) - How to Import and Remove Formatting from Text/CSV Files

This article details how to remove the automatic table formatting after you import a text/CSV file into an Excel spreadsheet.

1.) Go to the Data tab on the Ribbon in Excel and select Get Data on the far left.

2.)  Select From File, and then select From Text/CSV. 

3.) File Explorer will open and allow you to locate the file you want to import. Once you find your file, select Import

4.) After you have selected Import, an Excel window will appear. Make your selections on how you want the file to be imported by selecting Load or Edit. You can find more ways to personalize the import by selecting the carrot by Load. By pressing Load, you will automatically have your file imported into a new worksheet.

5.)  After your file has been imported successfully, highlight your entire table and make sure you are on the Design tab that has now appeared on the ribbon. Deselect the Header row (unless you want it), and then click Convert to Range. This will remove all table formatting and queries associated with the newly created table.

Tech Service Desk

Room A184, 217-353-3333

Fall/Spring: 7:30 a.m. - 6:00 p.m. M-Th. / 7:30 a.m. - 5:00 p.m. Fridays

Summer: 7:30 a.m. - 6:00 p.m. M-Th

Submit an IT Help Ticket via

Keywords:excel, formatting, office 2016, office 365, automatic table format   Doc ID:81661
Owner:Katherine N.Group:Parkland College
Created:2018-04-18 13:56 CSTUpdated:2018-04-19 14:42 CST
Sites:Parkland College
Feedback:  7   12