2

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.

Dan T
  • 21
  • 2
  • Which answer exactly didn’t work? Please [edit] your question instead of replying with a comment – Ramhound Jul 20 '21 at 22:08
  • Give me 8 to 9 hours to figure out which answer your talking about. Clicking on the link brings you to the question but difficult to know which answer your talking about when you also see 3 answers all in a row. I can also see the 3 deleted answers. – Ramhound Jul 21 '21 at 00:11

1 Answers1

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

Lee
  • 2,923
  • 1
  • 6
  • 8
  • 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 Jul 21 '21 at 07:23
  • Maybe it's more related to orginal file? – Lee Aug 04 '21 at 09:33