How to Import CSV into an Existing Excel Worksheet Using Power Query
Question details
The user wants to import a CSV file into an existing worksheet using Power Query but encounters the 'Query results cannot overlap a table or XML mapping' error and finds legacy connection properties disabled.
- Product
- Excel 365
- Device & OS
- not provided
- Scenario
- Importing a CSV file into a specific cell on an existing worksheet instead of letting Excel create a new worksheet.
- Observed behavior
- Power Query defaults to loading the CSV data into a new worksheet, and attempting to redirect the load to an existing Excel Table triggers an overlap error. Additionally, legacy connection properties are grayed out.
Ensure that the destination cell and surrounding area in your existing worksheet are completely blank and not already formatted as an Excel Table.
Import a New CSV File Directly to an Existing Worksheet
Use the 'Load To' option during the initial data import to specify your exact destination cell rather than letting Excel automatically create a new sheet.
By default, Excel 365's Power Query 'Load' button creates a new worksheet. You must interrupt this process to choose your specific destination.
Go to the Data tab on the Excel ribbon, click Get Data, hover over From File, and select From Text/CSV.
Locate the CSV file on your computer, select it, and click Import to open the preview window.
At the bottom of the preview window, do not click the main Load button. Instead, click the small arrow next to Load and select Load To... from the drop-down menu.
In the Import Data dialog box, choose Table. Then, select Existing worksheet and click on the specific cell (e.g., =$A$1) where you want the data to start.
Click OK to load the CSV data directly into your chosen location.
Change the Destination of an Existing Power Query
If your query has already loaded into a new sheet, you can redirect it to an existing worksheet.
Fix the 'Query Results Cannot Overlap a Table' Error
Resolve the error that occurs when the target destination already contains an Excel Table or XML mapping.
Try WPS Office for Simple, Hassle-Free CSV Imports
If Excel's Power Query updates and overlap errors are complicating your workflow, try WPS Office. It offers a lightweight, highly compatible spreadsheet tool with straightforward data importing features—without complex query conflicts.
- 1. Open WPS Spreadsheet: Launch WPS Office and open a new or existing spreadsheet.
- 2. Import Data: Navigate to the Data tab, click Import Data, and select your CSV file.
- 3. Place Your Data: Follow the simple Text Import Wizard, then choose the exact cell in your existing worksheet to place the imported data.
Frequently Asked Questions
Why is the Properties button disabled for my CSV connection?
In modern Excel 365, CSV imports use Power Query (Get & Transform Data) instead of legacy text connections. You must manage these connections via the Queries & Connections pane rather than the old Connection Properties dialog.
How do I import multiple CSV files automatically?
You can automate multiple CSV imports by using the folder-based Power Query method. Go to Data > Get Data > From File > From Folder, select the directory containing your CSVs, and click Combine to merge them into a single table.
Do I need to delete my existing table before importing new CSV data?
Yes, if your destination range is already formatted as an Excel Table, Power Query will throw an overlap error. You must either convert the existing table to a normal range (Right-click > Table > Convert to Range) or select a completely blank destination cell.
What is the difference between Load and Load To in Power Query?
Clicking 'Load' automatically generates a brand new worksheet and loads the query data into a table there. Clicking 'Load To...' allows you to customize the destination, letting you choose an existing worksheet, a specific cell, or even just adding the data to the Data Model without creating a visible table.
