Excel to SharePoint List Importer Help Link

Introduction:

The Excel to SharePoint List Importer enables efficient import and update of data into SharePoint Lists using .xlsx and .csv files. It simplifies large-scale data handling by allowing users to map and upload Excel or CSV data directly to SharePoint Lists.

FAQs:

1. What is the purpose of the Excel to SharePoint List Importer?

The Excel to SharePoint List Importer allows users to upload and update large amounts of data in SharePoint Lists quickly and efficiently.

2. How do I set up the Excel to SharePoint List Importer in my environment?

  • Add the solution to your SharePoint tenant’s App Catalog.
  • Approve necessary permissions from SharePoint Admin Center > Advanced > API Access.
  • Deploy the solution to your desired SharePoint sites.
  • Use the web part interface to begin uploading files.

3. What types of files are supported for import?

The application supports .xlsx and .csv file formats.

4. How does the application handle duplicate records?

During upload:

  • The user selects a Unique ID column.
  • If the ID already exists in the list, the record is updated.
  • If it doesn’t exist, a new record is created.

5. Is column mapping automatic?

Yes. When uploading, columns from the file are automatically matched to SharePoint list columns based on their name and data type (e.g., Single Line, Number, Multi-line).

6. What is the ExcelImporter_Central_List

It is a metadata list created automatically to store column mapping and configuration details for each list created using the Excel to SharePoint List Importer.

7. How do I view the uploaded data?

Use the Dashboard section:

  • Select the target list from a dropdown.
  • View list data, apply filters, search, and export results.

8. Who can I contact for support?

For any issues, you can contact us at: https://ravi.span7.in/contact-us/

9. Are there any prerequisites before using the app?

  • SharePoint tenant must allow SPFx solution deployment.
  • Permissions should be granted for list access.
  • The SharePoint environment must support custom solutions.

Troubleshooting Tips

  • Ensure the file format is .xlsx or .csv.
  • Verify the Unique ID column is correctly selected.
  • If data isn’t saving, check for validation errors during upload.
  • Clear browser cache and refresh the page if the dashboard does not update.

Newsletters