Information
  • Author: Appian Corporation
  • Type: Plug-in (Function & Smart Service)
  • Support: This is an Appian supported plug-in. To the extent that this plug-in does not conform to its documentation, please submit a ticket to Appian Technical Support. Appian does not support customer-created customizations or outdated versions of the plug-in.
  • Industry: All Industries
  • Compatible Version(s): 24.2
  • First Released:
  • Last Updated:
  • Cost: Free - Appian Supported
Resources
Share
Home » AppMarket » Excel Tools

Excel Tools

Overview

Provides several smart services and functions for handling data in Excel and CSV formats.

Key Features & Functionality

Smart Services included are:

  • Import CSV to Database
  • Import Excel to Database
  • Merge Excel Documents
  • Load CSV to Database
  • Convert HTML to CSV
  • Convert Excel to CSV
  • Encrypt Excel with Password

Functions included are:

  • Read Excel File Paged
  • Read Excel Cell by Name
  • Read Excel Cell by Number
  • Read Excel By Headers
  • Query Appian Logs
  • Export Datasubset to Base64
  • Validate Document Headers
Anonymous

  • Is this plugin compatible with Appian 20.1?

  • in reply to Ze-Yang

    Hi , free apps on the AppMarket are developed and supported by Community contributors. You can comment on AppMarket listings with feedback or contact appmarket@appian.com for more information. If you have a patch, you can request permission to update another person's app and if granted submit the new version through our AppMarket Submissions site

    AppMarket FAQ

    AppMarket Submissions

  • May I know where to report the bug or provide a patch

  • Observe a bug, when import excel file failure, this tool still occupy database and block other database operation

  • When import a excel sheet with empty cell (in database this column is a integer type), get

    Problem:  An error occurred in executing an Activity Class.
    Details:  ???Incorrect integer value: '' for column 'CONTACT1' at row 1???

    May I know this tool do not allow null value for integer? I test my database schema, column with integer type can be null

  • in reply to Bhargav Solanki

    Hi Bhargav,

    Is this plugin not compatible with 19.4 yet? I'm trying to use it in 19.4. When I executes the process, it completes successfully, but data doesn't seem to import into DB.

    I tried both 'Import Excel to database' and 'Import CSV to database' with no success.

    Not sure if anyone facing similar issues.

  • in reply to Mike Schmitt

    Hi,

    The latest version of excel tools is now live on the App market
    Release notes are as follows:
    2.2.7 Release Notes

    Functionality Updates:
    • The “Import Excel to DB” smart service no longer errors if no value is passed for the inputs “New
    • Columns” and “New Columns Values”
    • The “Import CSV to DB” smart service now returns a readable error message if there are extra blank
    • columns in the CSV file
    • The “Query Appian Logs” function no longer skips the first row of data is the input “hasHeader” is passed
    • as false
    • The “Convert Excel To CSV” smart service has been updated to utilize the inputs
    • “numberOfColumnsToReadInRow” and “rowNumberToReadFrom”
    Documentation updates:
    • Documentation has been re-added to the AppMarket listing
    • For “Import Excel to DB”, the accepted formats for dates and date times in the sheet are now clearly
    • documented
    • For “Import CSV to DB” and “Import Excel to DB”, the descriptions and example values for the smart
    • service inputs have been updated
    • For “Query Appian Logs”, the passing of inputs by order is explained and an example function call has
    • been added
  • in reply to johnh0008

    Hi,

    The latest version of excel tools is now live on the App market
    Release notes are as follows:
    2.2.7 Release Notes

    Functionality Updates:
    • The “Import Excel to DB” smart service no longer errors if no value is passed for the inputs “New
    • Columns” and “New Columns Values”
    • The “Import CSV to DB” smart service now returns a readable error message if there are extra blank
    • columns in the CSV file
    • The “Query Appian Logs” function no longer skips the first row of data is the input “hasHeader” is passed
    • as false
    • The “Convert Excel To CSV” smart service has been updated to utilize the inputs
    • “numberOfColumnsToReadInRow” and “rowNumberToReadFrom”
    Documentation updates:
    • Documentation has been re-added to the AppMarket listing
    • For “Import Excel to DB”, the accepted formats for dates and date times in the sheet are now clearly
    • documented
    • For “Import CSV to DB” and “Import Excel to DB”, the descriptions and example values for the smart
    • service inputs have been updated
    • For “Query Appian Logs”, the passing of inputs by order is explained and an example function call has
    • been added
  • in reply to Sidhant Behura

    Hi,

    The latest version of excel tools is now live on the App market
    Release notes are as follows:
    2.2.7 Release Notes

    Functionality Updates:
    • The “Import Excel to DB” smart service no longer errors if no value is passed for the inputs “New
    • Columns” and “New Columns Values”
    • The “Import CSV to DB” smart service now returns a readable error message if there are extra blank
    • columns in the CSV file
    • The “Query Appian Logs” function no longer skips the first row of data is the input “hasHeader” is passed
    • as false
    • The “Convert Excel To CSV” smart service has been updated to utilize the inputs
    • “numberOfColumnsToReadInRow” and “rowNumberToReadFrom”
    Documentation updates:
    • Documentation has been re-added to the AppMarket listing
    • For “Import Excel to DB”, the accepted formats for dates and date times in the sheet are now clearly
    • documented
    • For “Import CSV to DB” and “Import Excel to DB”, the descriptions and example values for the smart
    • service inputs have been updated
    • For “Query Appian Logs”, the passing of inputs by order is explained and an example function call has
    • been added
  • in reply to Steven Miccile

    Thanks for confirming - as far as I remember, I'd tried it both ways (i figured dictionary syntax wouldn't work but also didn't produce specific errors).  

    Also as a side note, Community doesn't seem to send any sort of notification of a reply here even though you had replied directly to me (this seems to hold true for any sort of comment activity within the App Market space).

© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.