---
title: "Import from a Large CSV/Excel/Google Sheet Stuck"
description: "How to resolve infinite loading or errors caused by large files when creating editable wpDataTables"
url: https://help.wpdatatables.com/en/articles/44-import-from-a-large-csvexcelgoogle-sheet-stuck
collection: "Technical issues"
updated: 2026-09-25
language: en
---

# Import from a Large CSV/Excel/Google Sheet Stuck

How to resolve infinite loading or errors caused by large files when creating editable wpDataTables

**Why is my file not importing? It just keeps loading or throws an error.**

If you're trying to import a large file (CSV, Excel, or Google Sheet) with several thousand rows and encounter an **infinite loading animation** or an **error message**, this usually happens due to WordPress and server execution limits.

**How can I import large files into wpDataTables?**

You can bypass this limitation by importing the file directly into your database using a tool like **phpMyAdmin**.

**Before importing, make sure:**

-   The first row of your file contains **column headers**.
    
-   The table name does **not** contain spaces, dots, or special characters (e.g. use `table_1`).
    

**Once imported, how do I use it in wpDataTables?**

After the table is in your database, you can create a new **MySQL Query-based** wpDataTable with a query like:  
`SELECT * FROM table_1`