1. How is a new SharePoint list created?

Steps

  1. Go to your SharePoint site / M365 Lists
  2. Click New → List

Screenshot of App Launcher and Lists App in Microsoft 365.

3. Choose one option:

    • Blank list
    • From existing list
    • From Excel
    • Template

2. How is data entered?

Methods

Option 1 – Manual entry

  • Click + New item
  • Fill in the form
  • Save

Option 2 – Grid view 

  • Click Edit in grid view
  • Enter data like Excel (rows & columns)

Option 3 – Forms

  • Click Forms
  • Generate Forms

Key points

  • Each row = one record
  • Each column = one attribute
  • Grid view enables fast multi-line input

You can add items directly using “Add new item” or grid view editing

3. How can data from Excel be copied/saved into a SharePoint list?

Option 1 – Create list from Excel (recommended)

  1. Click New → List
  2. Select From Excel
  3. Upload file
  4. Select table
  5. Validate columns
  6. Create list

✔ Automatically creates structure + data

  

Option 2 – Copy / Paste

  1. Open Excel file
  2. Copy rows
  3. Open SharePoint list (grid view)
  4. Paste data

⚠ Requires matching columns

Copy/paste works for small volumes if structure matches between Excel and SharePoint