Where are Microsoft Lists stored?

Microsoft Lists is a new application that’s been added to Microsoft 365 to modernize the lists available in SharePoint and recently became available for consumer users with an MSA account.

With two different versions of Microsoft Lists it is important to know where the data gets store depending on the options that you choose when using the application.

Microsoft Lists Storage

Where are Microsoft Lists stored in Microsoft 365?

When using lists in Microsoft 365 with your corporate account, lists can get stored in two locations depending on the scope that you choose when creating the list.

If you are planning to create a list that will be used just by you, and you’ve selected My lists in the Save to option the list will be stored on your personal SharePoint site, the same site you access to open the files stored in OneDrive.

On the other hand, if you are planning to create a list that is shared by multiple users in SharePoint or Microsoft Teams, then the list gets stored in the SharePoint site collection where it was created.

Where are Microsoft Lists stored with MSA accounts?

If you are using Microsoft Lists with your personal Microsoft account, your list will be stored in your personal OneDrive, despite the different URL (https://lists.live.com).

Technically under the hood Microsoft Lists MSA is running the same old SharePoint but with a lot of engineering on top of it to be available to the consumer market.

If you want to know more about Microsoft Lists MSA I recommend you listen the Intrazone PodCast below with Mark Kashman and Miceile Barrett.


4 Responses to “Where are Microsoft Lists stored?”

  1. André

    November 12, 2023

    Hello João,

    thanks for this good blog post.
    Do you have a clue, if I can access lists stored in a MSA account via SharePoint connector in Power Automate?

    Thanks,
    André

    Reply
    • João Ferreira

      January 26, 2024

      Hi André,

      It is not possible, at least for now.

      Have a nice day

      Reply
  2. K

    February 20, 2024

    Hello Joao,

    Thank you for creating this Microsoft List. I’ve been utilising this, and it’s beneficial in managing and organising my tasks. I’ve been advocating the great experience to my teammates for a productive and collaborative output.

    Our questions are the following:
    When uploading the attachments via Microsoft List, where are these attachments being stored in One Drive / Sharepoint?
    And can the attachments be stored in a specific folder of every list file name?
    Can customised files be exported directly to Excel?

    Help us please to locate these files and organise them accordingly for a better experience and result.

    Thanks,
    K

    Reply
    • João Ferreira

      February 22, 2024

      Hi Kristine,

      I just wrote a post about Microsoft Lists attachments that answer to some of your questions.
      You can have a look in the link below:
      https://lists.handsontek.net/turn-off-attachments-microsoft-lists/

      Keep in mind that the attachments should not be used as document library, all the attachments will be stored in the SharePoint site where the List is.

      Let me know if you have any other question.

      Have a nice day 🙂

      Reply

Leave a Reply


I've been working with Microsoft Technologies over the last ten years, mainly focused on creating collaboration and productivity solutions that drive the adoption of Microsoft Modern Workplace.