---
title: "How to Import Data From CSV in WordPress Table?"
url: https://nexterwp.com/docs/import-data-from-csv-in-wordpress-table/
date: 2023-04-11
modified: 2026-09-14
lang: en
author: "Aditya Sharma"
description: "Retyping a spreadsheet into a table is slow, and every retyped row is a chance to introduce a mistake. The Data Table block can read the rows straight out of..."
image: https://nexterwp.com/wp-content/uploads/2024/05/import-data-from-csv-in-wordpress-table-1024x519.jpg
word_count: 470
---

# How to Import Data From CSV in WordPress Table?

## Key Takeaways

- Data Table block reads rows straight out of a CSV file in the Media Library when Type is set to CSV File, and the table fills in straight away after the CSV File URL is pasted.
- Nexter Blocks Pro is required for CSV import, while the free plugin renders an empty table for the CSV File type.
- Semicolon-separated CSV is required because the importer splits columns on semicolons (;), not commas, and the first line becomes the heading row while every line after it becomes a data row.

Retyping a spreadsheet into a table is slow, and every retyped row is a chance to introduce a mistake.

The Data Table block can read the rows straight out of a CSV file in your Media Library.

*For every Data Table setting in one place, see the [Data Table block guide](https://nexterwp.com/docs/add-data-table-in-wordpress/).*

[LIVE BLOCK LINK](https://nexterwp.com/nexter-blocks/blocks/wordpress-data-table/)

## Before You Start

- **Edition:** **Pro** — CSV import needs Nexter Blocks Pro.- **Block to enable:** Data Table, switched on under **Nexter > Blocks** in your WordPress dashboard.- **A semicolon separated CSV:** the importer splits columns on semicolons (**;**), not commas. Most spreadsheet tools offer this when you export.- **The file uploaded to your Media Library**, so it has a URL you can paste.

## Steps

- Add the **Data Table** block to your page and click **Design from Scratch**.

- In the **Table** panel, set **Type** to **CSV File**.

![The Table panel with Type set to CSV File](https://nexterwp.com/wp-content/uploads/2026/09/data-table-type.webp)

- Upload your CSV under **Media > Add New** and copy its file URL.

- Paste it into **CSV File URL**. The table fills in straight away.

![The CSV File URL field with the table rendered from the file](https://nexterwp.com/wp-content/uploads/2026/09/data-table-csv-url.webp)

- Publish the page.

![A table built from a semicolon separated CSV file](https://nexterwp.com/wp-content/uploads/2026/09/data-table-fe-csv.webp)

## Your File Must Use Semicolons

This is the one thing that catches people out. The importer treats a semicolon as the column separator, so a normal comma separated export ends up as a single column with every value crammed into one cell, heading included.

![The same data as a comma separated file, collapsed into one column](https://nexterwp.com/wp-content/uploads/2026/09/data-table-fe-csv-comma.webp)

Most spreadsheet tools can export with semicolons: in Excel it is the *CSV (semicolon delimited)* option, and Google Sheets can do it by downloading as CSV and replacing the commas, or by using [the Google Sheet import](https://nexterwp.com/docs/import-data-from-google-sheets-in-wordpress-table/) instead.

## How It Behaves

- The first line of the file becomes the heading row and every line after it becomes a data row.- The file is read when the page is built, so updating the file updates the table without touching the page.- The **Table Header** and **Table Body** panels disappear under this Type, because the rows now come from the file.- Your typed rows are not lost — switching back to **Standard** brings them back.

## Limitations

- **Pro only.** With the free plugin the CSV File type renders an empty table.- Semicolons only. A comma separated file will import as one column.- The file must be reachable over the web — a file on your computer will not do.- Cells arrive as plain text, so buttons, links and images cannot come from the CSV. Use [a Standard table](https://nexterwp.com/docs/add-button-in-wordpress-table/) for those.

## Troubleshooting

### Everything landed in one column

The file is comma separated. Re-export it with semicolons and the columns split correctly.

### The editor shows “you didn't enter CSV file”

The URL is empty or cannot be reached. Paste the full file URL from the Media Library, including **https://**.

### The table is empty on the front end

Check that Nexter Blocks Pro is active, and open the CSV URL in a browser tab to confirm the file is publicly readable.

## Related Docs

- [Import from Google Sheets](https://nexterwp.com/docs/import-data-from-google-sheets-in-wordpress-table/)- [Data Table block: all settings](https://nexterwp.com/docs/add-data-table-in-wordpress/)- [Enable column sorting](https://nexterwp.com/docs/enable-sorting-in-wordpress-tables/)