Export to Excel option in OneDrive online

Jadhav, Jyoti 0 Reputation points
2024-06-12T14:45:11.8866667+00:00

Hi,

In OneDrive we are exporting the data using Export to excel option but when we open the query in excel. In the File/Folder name column, we are getting some records with actual name and some are with the whole URL as seen in below image
User's image

Can you please let me know why it is happening and how to get only file/folder name?

Regards,

Jyoti Jadhav

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

1 answer

Sort by: Most helpful
  1. AllenXu-MSFT 24,951 Reputation points Moderator
    2024-06-13T06:33:11.6433333+00:00

    Hi @Jadhav, Jyoti,

    I tried the "Export to Excel" feature in my several OneDrive Online folders but I didn't reproduce this issue in my end. I'm afraid this is not a common issue but there may be something wrong in this backend which normal users have no access to.

    I suggest you create a service request with Microsoft. MS experts will help you check from the backend and give you instant help.


    If the answer is helpful, please click "Accept as 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.