

Get in touch

Download Plugin Now
  • Follow
  • Follow
WP Data Access
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
    • Tool Guide
    • App Builder
    • Data Explorer
    • SQL Query Builder
    • Plugin Settings
    • Legacy Tools
    • Remote Connections
a
M
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
    • Tool Guide
    • App Builder
    • Data Explorer
    • SQL Query Builder
    • Plugin Settings
    • Legacy Tools
    • Remote Connections
Download Plugin Now

Remote Databases

  • MySQL | MariaDB
  • Heterogeneous Connections
  • Using ODBC | JDBC
  • Connect to SQL Server
  • WordPress user ID in SQL

Premium Data Services

  • Remote wizard
  • START HERE
  • Errors and messages
  • Limitations
  • Tutorials
  • Remote Databases
    • Overview
    • SQL Server
    • PostgreSQL
    • Oracle
    • MariaDB | MySQL
  • Remote Data Files
    • Overview
    • CSV files
    • JSON files
    • MS Access
    • XML files
    • Public URL
    • Synchronization
  • Advanced features
    • Performance
    • Indexes
View Categories

CSV files

This feature is great for WordPress users who prefer to manage their tables with a spreadsheet program and publish them as professional responsive tables supporting several filter methods, sorting, styling and export formats. WP Data Access loads your CSV file into a database table and updates the table at configurable intervals, while you continue to maintain your table with your favourite spreadsheet program.
To use the remote connection wizard, you first have to enable our premium data service on your WordPress server.

PREPARATION #

Make sure your CSV file is available from a public URL before you start the remote connection wizard. Test your public URL. Your URL should return the CSV file content only. (read more…)

  • Use this feature to sync your Google Sheets

CREATION #

  • Start the Data Explorer
  • Click the Connect icon to open the remote connection wizard
  • Select the CSV file from the Connection type drop-down list
  • Enter the public URL (see preparation) of your data file in the field File path
  • Define an Update interval or leave blank if automatic updates are not required
  • If your CSV file contains a header row these values will be used as column names, otherwise columns will be named: COL001, COL002, and so on
  • You can change the default field delimiter if necessary
  • Enter a Table name
  • Click the Create button
PDS - CSV Files

USAGE #

  • Use Data Tables to publish your table data
  • Arrange your publication elements, enable interactive filtering and add export buttons
  • Of course you can use this table in all other plugin tools as well

CSV Sample #

Empno,Name,Job,Mgr,Hiredate,Sal,Comm,Deptno
7369,"SMITH","CLERK",7902,"1981-09-18",1600.97,10,20
7499,"ALLEN","SALESMAN",7698,"1981-02-21",1680.98,30,30
7521,"WARD","SALESMAN",7698,"1981-01-23",1250.00,500,30
7566,"JONES","MANAGER",7839,"1981-04-01",2975.00,,20
7654,"MARTIN","SALESMAN",7698,"1981-09-28",1250.00,1400,30
7698,"BLAKE","MANAGER",7839,"1981-05-01",2850.00,,30
7782,"CLARK","MANAGER",7839,"1981-06-09",2450.00,,10
7788,"SCOTT","ANALYST",7566,"1982-12-09",3000.00,,20
7839,"KING","PRESIDENT",,"1981-11-17",5000.00,,10
7844,"TURNER","SALESMAN",7698,"1981-09-08",1500.00,,30
7876,"ADAMS","CLERK",7788,"1983-01-12",1100.00,,20
7900,"JAMES","CLERK",7698,"1981-12-03",950.00,,30
7902,"FORD","ANALYST",7566,"1981-12-03",3000.00,,20
7934,"MILLER","CLERK",7782,"1982-01-23",1300.00,,10
Share This Article :
  • Facebook
  • X
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on 2025-02-07

Submit a Comment Cancel reply

Your email address will not be published. Required fields are marked *

Table of Contents
  • PREPARATION
  • CREATION
  • USAGE
    • CSV Sample
WP Data Access
  • Follow
  • Follow
Links
$

Imprint

$

Privacy policy

$

Cookie policy

Get in touch
$

Contact us

$

Free support forum

$

Premium support

Resources


WordPress plugin directory



YouTube tutorials

Copyright © 2025 | All Right Reserves

Manage Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}