Excel Automatically split text to columns. How do I turn that off?

Question

When opening a CSV file, excel automatically splits text to columns. However, Since I work in an international environment, the delimiter is not always the same. Meaning sometimes it goes well, but many times excel screws up the document to a point where it gets completely unusable.

Is there a way to turn this functionality completely off. I rather use the function manually, so I can select the correct delimiters myself.

Answer 1

If you have concerns about how Excel will open your file, don't double-click it to open it. Instead, use Data>Get & Transform Data>From Text/CSV.

In that wizard, you can select the delimiter you prefer to use for that file.