We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #1949834
Importing data from Excel but some cells are formulas
Closed

Comments

  • Lucas Daniel Flores started the conversation
    March 26, 2019 at 8:36pm

    I want to create a table using imported data from an Excel, but my question of what if some cells has formulas instead of plain numbers? Will that import work? How can be done? Any documentation to read?

  •  472
    Isidora replied
    March 27, 2019 at 10:10am

    Hi Lucas,
    Thank you for your interest in wpdatatables.

    When working with Excel-based tables, please note 2 things:

    1. Formulas and merged cells are not supported,
    2. They generally work slower than CSV-files, or even Google Spreadsheets; so if your table is large, it is much better to port it to a different format, or – even better – to MySQL table (you can use “Create a table by importing data from data source” to import your Excel file to MySQL).

    What we have is Formula (calculated) columns.

    We have Lite version of wpdatatables which you can try for free.

    wpDataTables Lite is a basic version of a popular best-selling WordPress table plugin. While some premium features are reduced, wpDataTables Lite is still quite a handy tool that allows you to quickly create tables in WordPress from different sources. You can download it from this link.

    Also, you can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin premium features.

    All useful information about all wpdatatables features that are explained (video and text) you can find in our DOCUMENTATION.

    Best regards.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables