Share via

How do you import a excel file (or CSV) into the MS 365 Lists? I see Export but no Import.

Anonymous
2023-04-18T16:50:16+00:00

I went to MS Office>Apps>Lists> to move a excel spreadsheet onto a New List so several of us could access the List and add to the spreadsheet. My buddy already has a similar List and would actually like to clone his format and then add my data. I can add columns okay - just need the import function.

Microsoft 365 and Office | SharePoint | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-08-07T17:43:17+00:00

    This is Microsoft 365 inside a browser, right clicking brings up the native browser right-click menu.

    50+ people found this answer helpful.
    0 comments
  2. Anonymous
    2023-04-19T13:43:16+00:00

    Thanks for your reply, however, I do not see a "List" tab in the ribbon.

    All I see in the ribbon is, " +Add new Item, Exit grid view, Undo, Share and Export" and at the far right, "Manage access"

    Is this a paid subscription issue? I pay for MS 365 Family currently.

    Thanks Dave

    20+ people found this answer helpful.
    0 comments
  3. Anonymous
    2023-04-18T18:22:23+00:00

    Hi

    I'm Taiwo and I'd happily help you with your question. In this Forum, We are Microsoft consumers just like yourself.

    You can use the "Import Spreadsheet" option in the "List" tab of the ribbon to import data from an Excel file or CSV file into a Microsoft 365 list. Here are the steps to do that:

    1. Open the Microsoft 365 list you want to import data into.
    2. Click on the "List" tab in the ribbon at the top of the page.
    3. Click on the "Import Spreadsheet" button in the "Connect & Export" section of the ribbon.
    4. In the "Import Spreadsheet" dialogue box, browse and select the Excel or CSV file containing the data you want to import.
    5. Click on "Import" to start the import process.
    6. In the "Import to List" dialogue box, select the Microsoft 365 list where you want to import the data.
    7. Map the columns in the Excel file or CSV file to the columns in the Microsoft 365 list.
    8. Click on "Import" to import the data into the list.

    I hope this helps ;-), let me know if this is contrary to what you need, I would still be helpful to answer more of your questions.

    Best Regards, Thank You.

    5 people found this answer helpful.
    0 comments
  4. Anonymous
    2023-04-19T21:43:01+00:00

    The List tab may only be visible in certain views, such as the "All Items" view or the "Current View" view. Check that you're in the right view by selecting the "View" tab in the ribbon and choosing the appropriate view.

    It's possible that the List tab has been hidden or removed from the ribbon. To customize the ribbon, right-click anywhere on the ribbon and select "Customize the Ribbon". Look for the "List" tab in the right-hand column and make sure it's checked. You can also drag the "List" tab to a different location on the ribbon if you prefer.

    3 people found this answer helpful.
    0 comments