Export to Excel option in OneDrive online

Jadhav, Jyoti 0 Reputation points


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?


Jyoti Jadhav

A Microsoft file hosting and synchronization service.
962 questions
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,249 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AllenXu-MSFT 18,206 Reputation points Microsoft Vendor

    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