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.