Data Import & Export

SharePoint List Row Limits for VBA Imports and Excel Exports

Adam Davis Oct 1, 2026 869 views

Question details

Users need to understand the maximum row limits and thresholds when importing to or exporting from SharePoint lists using Excel and VBA.

SharePoint List Row Limits for VBA Imports and Excel Exports

Product: SharePoint and Microsoft Excel
Device & OS: not provided
Scenario: Managing and transferring large datasets between SharePoint lists and Excel using VBA scripts or built-in export features.
Observed behavior: Operations may fail, time out, or get throttled when exceeding SharePoint's 5,000-item list view threshold, the 30,000-row export limit, or the 20,000-row VBA import limit.

Before you start

Ensure you have the necessary permissions to modify SharePoint list settings, create indexed columns, and run VBA macros in your workbook.

Solution 1Recommended

Bypass the 5,000-Item List View Threshold with Indexed Columns

Use indexed columns and filtered views to prevent threshold errors when querying large SharePoint lists for export.

While a SharePoint list can hold millions of items, Microsoft enforces a 5,000-item List View Threshold to maintain database performance. To work around this during exports, you must index your columns and filter your views.

Navigate to List Settings

Open your SharePoint list in a web browser, click the gear icon in the top right corner, and select 'List settings'.

Create an Indexed Column

Scroll down to the Columns section and click 'Indexed columns'. Click 'Create a new index' and select the column you will use to filter your data.

Filter the View

Return to your list, edit the current view, and apply a filter using the indexed column so that the total items displayed are strictly under 5,000.

Bypass the 5,000-Item List View Threshold with Indexed Columns

Indexing Timing: It is highly recommended to create indexed columns before your SharePoint list exceeds the 5,000-item limit, as indexing a larger list may be blocked by the server.

Solution 2

Exporting Large SharePoint Lists in Batches

Handle the 30,000-row CSV export limit by splitting your data into manageable views.

Solution 3

Batch Processing for VBA Excel Imports

Prevent VBA timeout errors by splitting large import operations into smaller chunks.

Free Microsoft Office alternative

Manage Massive Exported Spreadsheets Efficiently with WPS Office

After exporting large datasets from SharePoint, processing heavy CSV or XLSX files locally can slow down standard spreadsheet tools. WPS Office provides a lightweight, highly compatible alternative for analyzing and organizing your large-scale data without lagging.

1. Download and Install: Get WPS Office for free from the official website and install it on your device.
2. Open Your Exported Data: Launch WPS Spreadsheets and open the heavy CSV or XLSX files you exported from SharePoint.
3. Analyze and Consolidate: Use WPS Spreadsheets' advanced data tools to merge your exported batches and perform your analysis.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Lightweight architecture handles large exported datasets smoothly and quicklyFamiliar user interface requires no learning curveRobust data filtering and sorting tools to organize batches easily

microsoft office alternative - wps office

Frequently Asked Questions

How many records can a SharePoint list contain in total?

A single SharePoint list can technically store up to 30 million items. However, to maintain server performance, list views and queries are restricted by the 5,000-item threshold.

What is the maximum number of rows I can export from SharePoint to Excel?

When exporting a SharePoint list to a CSV file, the maximum limit is generally 30,000 rows per export operation. For lists exceeding this number, you must filter the data and export it in multiple batches.

Can I update more than 20,000 records in one VBA operation?

It is highly recommended to cap a single Excel VBA import or update operation at roughly 20,000 rows. Exceeding this limit often leads to server timeouts or incomplete data transfers. Splitting updates into smaller, incremental batches is the safest method.

Excel & Data Problems