Forum Discussion

Gordon35's avatar
Gordon35
Copper Contributor
Sep 21, 2023

How to add "from Csv"-Button when creating SharePoint Lists?

Hi all,

 

there seems to be a feature when creating a new List in SharePoint Online that allows you to import directly from CSV Files. But when trying to create a new List it's only showing "empty List", "from existing List" or "from Excel". There should be a fourth Button "from CSV" (I have seen it in a different tenant". I do not find the feature to let the Button appear. Does anybody happen to know how to make this Button visible? 

Thanks!

SharePoint Online
  • LeonPavesic's avatar
    LeonPavesic
    Silver Contributor
    Sep 21, 2023

    Hi Gordon35,

    The "From CSV" button when creating SharePoint lists is a feature that is still in preview. It is not yet available to all tenants.

    To check if the feature is available to you, you can try the following:

    1. Go to the SharePoint Online site where you want to create the new list.
    2. Click the + button to create a new list.
    3. Under Create a list, click From existing list.
    4. In the Select a list dialog box, click Import from CSV.

    If you do not see the "Import from CSV" option, then the feature is not yet available to you.

    To request access to the preview feature, you can contact Microsoft support.

    If you need to create a list from a CSV file now, you can use a workaround:

    1. Create a blank list.
    2. Click the Export to CSV button.
    3. Open the CSV file in Excel.
    4. Add your data to the CSV file.
    5. Save the CSV file.
    6. Click the Import from CSV button.
    7. Select the CSV file that you created.
    8. Click Next.
    9. Map the columns in the CSV file to the columns in the list.
    10. Click Import.

    This will create a new list with the data from the CSV file.

    How to create a Microsoft list from CSV file ? - YouTube

    Please click Mark as Best Response & Like if my post helped you to solve your issue.
    This will help others to find the correct solution easily. It also closes the item.


    If the post was useful in other ways, please consider giving it Like.


    Kindest regards,


    Leon Pavesic

Resources