Creating connections to import CSV files into excel 365

Microsoft has changed the way importing and connecting CSV files works in newer versions of Excel. Instead of the older "Connections" method, Excel 365 now heavily relies on Power Query (Get & Transform Data), which can be more powerful but also more confusing.

How to Import CSV Files into an Existing Worksheet in Excel 365

To import CSV data into an existing sheet instead of creating a new one, follow these steps:

1. Use Power Query to Import CSV Data to a Specific Sheet

• Open your Excel workbook and select the existing sheet where you want to import the data.
• Click on Data → Get Data → From File → From Text/CSV.
• Browse and select your CSV file. Click Import.
• A preview window will appear. Click Load To (not just "Load").
• In the next window, choose "Existing worksheet" and select the specific cell where you want the data to go.
• Click OK, and Excel will import the data into the existing sheet.

2. If Power Query Keeps Creating a New Sheet Instead

If Power Query keeps sending the data to a new sheet, do this:

• After importing, go to Queries & Connections (on the Data tab).
• Right-click your query and choose Load To...
• Select "Existing worksheet" and point to where you want the data.

4. Why is the "Properties" Button Greyed Out?

The "Properties" button for connections is usually greyed out because:

• The connection is a Power Query connection (not a traditional legacy connection).
• Excel 365 now stores queries in the Power Query Editor, so you'll need to manage them there.

To edit properties:

• Go to Data → Queries & Connections
• Right-click the query → Select Edit.
• This will open Power Query, where you can modify the source, refresh settings, etc.

5. Automating Multiple CSV Imports

If you need to import multiple CSVs at once into different locations in the same sheet, you might need VBA or a Power Query folder import method.

All comments possibilities and steps are take it from the AI.

My answers are voluntary and without guarantee!

Hope this will help you.