How to Stop Excel from Creating Column1 Headers When Importing CSV Files
Question details
Users need to stop Microsoft Excel 365 from automatically creating generic Column1, Column2, and Column3 headers during recurring CSV file imports.

- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Recurring CSV imports in Excel 365 where the same file structure is used and the generated headers must remain consistent or be avoided.
- Observed behavior
- Excel automatically assigns generated column names such as Column1, Column2, and Column3 during CSV import.
Confirm the CSV delimiter and whether the first row contains field names, then open Excel and make sure the Power Query Editor is available under Data > Get Data.
Create a Reusable Power Query Connection with the Correct Header Setting
Use this approach when you import the same CSV layout repeatedly in Excel 365 and want to refresh the query instead of repeating the import settings.
Excel 365 does not provide a global toggle to suppress Column1, Column2, or Column3 headers for every CSV import. Saving a Power Query connection lets you define the header row behavior once and apply it to future files.
In Excel 365, click Data > Get Data > From File > From Text/CSV, choose your CSV file, and then click Import.
In the preview dialog, click Transform Data to open the Power Query Editor instead of loading the data immediately.
In the Power Query Editor, go to Home > Use First Row as Headers and select the correct option: use it to promote the actual header row, or clear it and use Use Headers as First Row if your first row is data and you plan to rename columns manually.
Click Home > Close & Load > Close & Load To, choose Table and a destination, then click OK. The query is saved in your workbook under Queries & Connections.
When you receive a new CSV file, replace the source file in the query or import the new file through the same connection, then right-click the query in Queries & Connections and click Refresh.

Batch Import Recurring CSV Files with the From Folder Connector
Use this method when your recurring CSV files are stored in the same folder and share the same column structure.
Use WPS Office as a Free Excel Alternative for Cleaner CSV Imports
WPS Office is a free, lightweight Microsoft Office alternative that opens and imports CSV files with familiar tools, supports Microsoft Office formats such as .xlsx, .xls, and .csv, and helps you avoid complex Power Query setup for recurring imports.
- 1. Download WPS Office: Get WPS Office from the official WPS website and install it on your Windows, macOS, Linux, Android, or iOS device.
- 2. Open your CSV file: Launch WPS Spreadsheet, click Menu > Open, and select your CSV file to see the import preview.
- 3. Choose header settings before loading: Use the import dialog to select the delimiter and specify whether the first row contains headers before loading the data.

Frequently Asked Questions
Can I permanently disable Column1, Column2, and Column3 headers for all CSV imports in Excel?
No. Excel has no universal setting to disable these generated headers for every CSV import. Create a Power Query connection with the correct header settings and refresh it for future files.
Where is the Use First Row as Headers option in Excel 365?
In the Power Query Editor, go to Home > Use First Row as Headers. You can also find related options under the Transform tab.
Does the From Folder connector work with different CSV file structures?
It works best when the CSV files in the folder share the same structure. If the files have different columns or header layouts, create separate queries for each structure.
Will WPS Office create Column1 headers when opening a CSV file?
WPS Spreadsheet lets you choose the delimiter and specify whether the first row contains headers during import, so you can avoid unexpected generated column names.
Can I refresh a Power Query connection after adding new CSV files to a folder?
Yes. If you used the From Folder connector, refresh the query and the newly added CSV files with the same structure will be processed automatically.




