To directly save an external file as a CSV in MS Power Query Editor

경환 사 0 Reputation points
2023-05-24T11:51:47.0033333+00:00

How to save edited query result data in MS Power Query editor to external file as csv file directly?

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AllenXu-MSFT 24,941 Reputation points Moderator
    2023-05-25T06:41:52.7066667+00:00

    Hi @경환 사 ,

    No out-of-box interface available to save result data in Power Query Editor to .csv files directly. The workaround is save the result data and load to a worksheet. Then use the Move or Copy function to save one worksheet as a separate file and save as .csv file.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.