Forum Discussion

Andre Siregar's avatar
Andre Siregar
Brass Contributor
Sep 22, 2020

Microsoft Lists - how to move?

Is there a way to move a List, e.g. from my personal space to an Office365 Group? There does not seem to be a way to do this other than using workaround of export & import to Excel.   However,...
microsoft 365 apps
office 365
jb_r3d's avatar
jb_r3d
Copper Contributor
Feb 05, 2021

Andre Siregar 
It seems that you can download the lists as indicated in this post https://answers.microsoft.com/en-us/msoffice/forum/msoffice_sharepoint/sharepoint-lists-how-to-move-them-from-one-site-to/197ed452-f83d-47a8-b8bd-96f7e6788a30, but it is unclear to me how you can upload them again to the SharePoint site. What is your Excel workaround?

  • M365Specialist's avatar
    M365Specialist
    Brass Contributor
    Mar 05, 2023

    Hi jb_r3d 
    When I need to upload a list to SPO from an excel spreadsheet, I use the 'Export to SharePoint' feature in Excel. Here's how:

    • Download the list and open it in Excel.
    • Select the entire table.
    • Click the 'Table Design' tab.
    • In the Export section of the tab, select 'Export Table to SharePoint'
    • Enter a name for your list and provide the URL of the SPO site contents you want to send the list to.

    If you don't have the Export section in the Table properties yet, you'll need to customise your Excel ribbon. This information from Microsoft should help with that. https://support.microsoft.com/en-us/office/video-customize-the-ribbon-9ce81e05-ecc1-4142-a3e3-1298b37a59c6

    This is the best solutions I've found so far, I hope it helps you too.

    • Txikiting's avatar
      Txikiting
      Copper Contributor
      Mar 13, 2023

      M365Specialist , if the list has any customization like controlling when a field is hidden or shown, with your process you'll lose it, all custom's will be gone.

       

      This is mentioned above many times.

       

      But thanks anyway.

  • bryandibben's avatar
    bryandibben
    Copper Contributor
    Mar 18, 2021

    As previously mentioned the 'Export to Excel' seems the only option.

     

    For anyone else, this is how I did it

     

    1. In Microsoft Lists export to Excel (it will be an .iqy file extension)

    In Microsoft Lists Export to Excel

     

     

    2. In Sharepoint site page click new list

    In Sharepoint site page click new list

     

     

    3. Upload your excel file 

    Create a new list from excel (and upload your excel file)

     

    To finish

    Check the column types and choose a new type if the current selection is incorrect.

    Check the column types

     

    -----

     

    I hope this helps

     

    • KatjavK's avatar
      KatjavK
      Copper Contributor
      Mar 12, 2022

      bryandibben I followed your recommendation however when I tried to import the excel file I received the following error message. Help is much appreciated.

       

      • HelloBenTeoh's avatar
        HelloBenTeoh
        Bronze Contributor
        Aug 22, 2022
        When you do the Export to Excel option, it saves it as a .csv
        Before you add it to MS Lists, you'll need to:
        - Format the data as a table with headers (open CSV, highlight data, click 'Format as Table' and select 'My table has headers)
        - Save as .xls

        Create the new list from your .xls file. You'll be prompted to match up the field types

Resources