DATATABLES AND SPREADSHEETS

Do you wish you could prepare your tables and charts online?

Convert2Web makes dealing with tables, charts and data management easy. We are already tasked and trusted to do this job by our numerous customers, both companies and individuals. We can bring your financial, scientific, statistical, commercial and other data to life online.

Online Datatables and Spreadsheets

Convert2Web produce your tables and charts online; this will enable you to manipulate and interact with your data with ease and speed and accuracy. You will easily and rapidly be able to produce tables and spreadsheets on a website, also pages with interactive tables and charts. Numerous features will be at your fingertips; this will make it a breeze for you to make use of multi-criteria filtering, sorting, or exporting to PDF from multiple data sources such as MySQL query, Google Spreadsheet, PHP array, Excel file, CSV file, JSON and XML input sources. Tables and charts could be built from tables or reports without predefined source files and MySQL databases manipulated with no prior knowledge of SQL!

How Does It Work?

Your charts and tables are produced online by Convert2Web, allowing you to manipulate and interact with your data with ease, swiftness and accuracy. Tables, spreadsheets and pages with interactive tables and charts can be swiftly produced by you on a website with no hassles. Countless features will be at your disposal; Utilizing multi-criteria filtering, sorting, or exporting to PDF from numerous data sources such as MySQL query, Google Spreadsheet, PHP array, Excel file, CSV file, JSON and XML input sources will be made easy for you. Tables and charts could be built from tables or reports with no predefined source files and MySQL databases manipulated with no prior knowledge of SQL!

Link the Table Data Directly to the Data Source

Sometimes, the data you want isn't available in your Excel workbook – it could be in a database, an XML file, on the web, in a text file, or in numerous other places. It would be awesome to have the data to work with right in your workbook, but you'd rather not have to import it repeatedly to ensure that it's current. It’s easy to ensure the data you’re working with is up to date always by creating a lasting connection from your workbook to the data source.

Tables can be constructed using links to numerous other sources including excel files, Google Spreadsheets and CSV files. This means that on every page load, the tables will be extracted directly from the data source. This will make adjusting the table easy and effortless. Immediately you alter something in the source data, the table will be automatically updated without you having to make extra moves or slow the upload down.

We can create tables based on:

  • Excel files
  • XML feeds
  • Google Spreadsheets
  • Serialized PHP arrays
  • JSON feeds
  • CSV files
  • MySQL queries
  • "Lazy load" server-side processing which takes care of oversized MySQL tables

Website and data integration

At times, you need to integrate data in various sources and make available a unified view of these data. This process becomes important in a variety of situations, including commercial and scientific domains.

Clients, most times, have the need to display additional information and content in the area around tables and charts, for example on a website. Where this is necessary, we will make it possible for you to integrate your tables and charts with your website effortlessly.



Requesting the addition of tables and charts

Tables can be added by going to the client section and making a request, by describing the table structure. There is no need to pre-define the data source. In the client section you can attach CSV, Excel or Google Spreadsheets which define your structure and data. It’s also possible that your table data already has online editing features. We can deal with this too. We will store tables of this sort in the database. The table will be able to use the benefits of server-side processing and always be editable.

In addition, Convert2Web can accept dynamic chart requests as well as requests for tables. At present 3 rendering engines are supported, namely: Google Charts, Highcharts (which provides a standalone license for commercial usage), and Chart.js. All the charts that we produce are based on your data sources. We can make table filtering and sorting which dynamically redraws in the front-end possible, a useful feature if you want to be able to manipulate numeric data.

Advanced features

We are happy to help where certain more advanced features are necessary. We are fully capable to help you with features such as:

  • Conditional Formatting
  • Responsive Design
  • Row Grouping
  • Multi-criteria filtering
  • Sorting
  • Table layout, word wrap
  • Site integration
  • Pre-filtering tables thru URL
  • Table export tools
  • Calculating totals for columns

Organize Your Data Files

Do you keep countless versions of your data files and get confused when you are trying to keep track of where your files are? We can help make things more manageable for you with a system that works. We also take care of keeping systems up to date so that you are always using the latest version.