1

How can I change the default text encoding in Excel 2019?

I already tried this hack/workaround using the registry editor https://superuser.com/a/1179248/1468612 ( based on this: http://www.lukemiller.org/journal/2005/03/changing-default-text-import-origin.html) but sadly it seems to not be working for Excel 2019.

My standard encoding is windows-1252 but I have to work with windows-1251 files a lot recently.

I am working with dozens of external Excel files each day so doing it for every single file is not a solution. It is driving me insane.

Edit :

I would like to change the standard encoding so when I open a file with double click the encoding would be already the correct one. Or at least the correct one would be already selected in the drop down menu of the text import wizard.

Improve this question
1
  • Which answer exactly didn’t work? Please edit your question instead of replying with a comment
    – Ramhound
    Commented Jul 20, 2021 at 22:08

1 Answer 1

Reset to default
1

For second link, the feature you can find from:

Data- Get Data- Legacy Wizards- From Text(Legacy): enter image description here

Then you can get this: enter image description here

Improve this answer
2
  • Thanks, this is how I am doing it atm. But I would like to change the standard encoding so when I open a file with double click the encoding would be already the correct one. Or at least the correct one would be already selected in the drop down menu.
    – Dan T
    Commented Jul 21, 2021 at 7:23
  • Maybe it's more related to orginal file?
    – Lee
    Commented Aug 4, 2021 at 9:33

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .