In sharepoint how can I choose the app to open the document

Nancy DEMERS 41 Reputation points
2023-07-31T19:59:38.87+00:00

Good day,

I'm trying to open a .csv from SharePoint but it always Excel that is the default app and I would like it to open in an othe app. It works if I have the document on my desktop but not when I'm in SharePoint online.

many thanks

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,196 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,214 questions
0 comments No comments
{count} votes

Accepted answer
  1. Ling Zhou_MSFT 11,775 Reputation points Microsoft Vendor
    2023-08-02T02:26:26.8066667+00:00

    Hi @Nancy DEMERS,

    Thank you for your reply.

    Of course, you can set files on SharePoint to open with office apps by default. You can set this setting to apply to files in a document library or to files on all sites in a site collection.

    1.Setting all files in a document library to open with office software by default. To set this up, make sure you have full control over the document library.

    Please go to Site contents->click the document library which you want to set up ->Settings.

    User's image

    In Settings page, please select Advanced settings->Opening Documents in the Browser. Setting up to open in the client application.

    User's image

    2.Setting all files on all sites in a site collection to open with office apps by default. To set this up, make sure you are the site collection administrator.

    Please go to Site contents->click the Site Settings->Site Collection Administration-> Go to top level site settings. (If you are already on the top-level site of the site collection, then you can just go to Site contents->click the Site Settings->Site Collection Administration).

    User's image

    User's image

    Please go to Site Collection Administration->Site collection features->Active the "Open Documents in Client Applications by Default" feature.

    User's image

    User's image

    If you can't see the Site collection features option, then you are not an administrator of the site collection. You can view or set up the site collection administrator based on this article:

    Site Collection Administrator in SharePoint Online – A Comprehensive Guide!

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link. 

    In my test, the .csv files will be opened in Excel by default.

    User's image


    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.


2 additional answers

Sort by: Most helpful
  1. Ling Zhou_MSFT 11,775 Reputation points Microsoft Vendor
    2023-08-01T05:07:37.5833333+00:00

    Hi @Nancy DEMERS,

    Thank you for posting in this community.

    First, I would like to confirm with you on your question: are you trying to use non-Office apps to open the form file?

    If yes, then I feel regretful to inform you that currently SharePoint Online does not support non-Office apps to open excel files. The opening of .csv files using Excel is handled by SharePoint, this is by design, and we can't change it for now.

    Perhaps the only way to do this at the moment is to download the file to your local computer and then open it using other apps.

    Please accept my sincerely apologize for any inconvenience this may cause.

    If I misunderstand something, please let me know. We will do our best to help you.


    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

  2. Nancy DEMERS 41 Reputation points
    2023-08-01T15:35:17.26+00:00

    then if I'm on Mac and I use Parallels can I force it open on the Excel on windows?

    0 comments No comments