Share via

Transform CSV to change file origin

Anonymous
2018-09-12T17:27:25+00:00

I have a bunch of files that have special characters rendering incorrectly when I open them. I used the text from CSV option to transform the data to UTF-8. All of the files were fixed, but they have all reverted back to their original origin. Now when I try to use the text from CSV option, they either don't import (nothing happens when I click "get data"), or the data is all misaligned.

Is there a reason the files reverted, or a reason why I can no longer change the file origin correctly? It won't even work if I re-save the original files. Any thoughts would be appreciated!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-09-15T12:42:00+00:00

    I think you will obtain your best help by uploading a copy of the original csv file (with sensitive information removed), to some sharing site (eg. OneDrive, DropBox, etc) and then posting a link here.  Also indicated the version of Excel being used.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-09-15T09:59:11+00:00

    Hi Rebecca,

    Would you please provide the information above?

    Regards,

    Tisky

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-09-13T03:58:35+00:00

    Hi Rebecca,

    To help us better understand your situation, we'd like to confirm some information first.

    1. Would you please provide some screenshots of the symptom with us?
    2. Does this problem happen to all the CSV files you have? Please try creating a new one and check the result.
    3. You said that the CSV files are all reverted back to their original origin. We'd like to confirm whether the CSV files are missing in the current path after you get the data, or you can provide more details to help us confirm the situation.
    4. We also want to confirm your excel version, you can check it in Excel > About Microsoft Excel.

    Regards,

    Tisky

    Was this answer helpful?

    0 comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more