Do you want to add data from a CSV file to a WordPress table? If you’re running an e-commerce site, a directory, or any website that involves displaying a lot of data in a table format, you may have experienced the time-consuming and error-prone task of manually entering large amounts of data into WordPress tables.
Fortunately, the Data Table block from The Plus Addons for Block Editor lets you easily import data from a CSV file into a WordPress Table.
To check the complete feature overview documentation of The Plus Addons for Block Editor Data Table block, click here.
Requirement – This block is a part of The Plus Blocks for Block Editor, make sure its installed & activated to enjoy all its powers.
To do this, add the block on the page, then in the Table tab, select CSV File from the Type dropdown.
In the CSV File URL field, add your CSV file URL.
Note: Your CSV file must be hosted online and use a semicolon (;) to separate columns. You can use this tool to convert your CSV file to semicolon separated CSV. For Excel CSV specifically check this guide and for Google Sheets you can use this addon.
Once done, you can see your data in a beautiful, organised table.
Also, check How to Import Data From Google Sheets in WordPress Table.