How to import data into Excel without automatic connections?

Question

I know this might be a simple question but is there an easier way to import a CSV into Excel without it automatically generating a data connection?

I know you can do it by:

• Importing the csv then deleting the connections
• Opening the csv and copying it into your spreadsheet

But I was hoping that there was an easier way to do this.

Note: I want to import it directly into the worksheet at cursor position(much like when you import via data connections) instead of opening another file(where it opens a new worksheet)

Answer 1

You can open a CSV file with "File -> Open" menu in excel. That doesn't open a data connection to CSV.

Answer 2

On Excel 2016 and 365, you just have to delete the connection once your import is completed. This will remove the refreshable possibilities, but not the data. I find it simpler than doing copy-paste even if it is not a one-click operation.

Answer 3

In excel 2010 click on the "Data Ribbon". Select the "From Text". Choose you file and click through the text import wizard using settings you'd like. Finally on the "import data" windows click "properties...".

This is the key. Uncheck "Save Query Definition". Click "OK" to accept and then "ok" again on the import data window to import. To check that you didn't make a connection, or delete one that was accidently made, check the "connections" button under the "Data Ribbon". It's a tiny button next to the larger "Refresh All" button.