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.
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.
- Upload your CSV under Media > Add New and copy its file URL.
- Paste it into CSV File URL. The table fills in straight away.
- Publish the page.
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.
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 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 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.
