Action Library > Documents

Find more ways to automate via our online community library. The library is constantly growing, expanded by both our verified users and by the team here at Parker Software. To add any new actions for your automations, use the “Custom actions” tab inside the ThinkAutomation Studio. Learn more

Insert CSV into XLS File (97 – 2003)

Type: Custom ActionAuthor: Sam Ainsworth

Inserts CSV data into a 97 - 2003 XLS sheet.

Requires a file to have already been created, and the worksheet name to be provided where the CSV will be inserted.

Please note:

  • A new header row will be created at the top of the worksheet or where data first occurs within the sheet.
  • If data is present within the first row, it will be overwritten. It is recommended to reserve the first row for headers and within cell A1 enter a placeholder value.
  • Having the XLS file open within another program at the same time may cause errors.

System Requirements

This custom action requires the "Microsoft.ACE.OLEDB.12.0" driver to function. This can be downloaded here

  • Common

  • Data

  • Outgoing

  • Documents

  • Office 365

  • General

  • Network

  • CRM

  • Xero

  • Web

  • Location

  • Twilio

  • Sentiment

  • Azure

  • System

  • Amazon

  • Azure Cognitive Services

  • Finance

  • Sample

  • Flow

  • Microsoft Graph

  • Talkyard

  • Virus Scanning

  • Password Managers

  • Dynamics On-Prem

  • Pipedrive

  • monday.com

  • Autotask

  • Tessitura

  • Testing

  • PayPal

  • Redis

  • SharePoint

  • WhosOn Helpers

  • QuickBooks

  • Email

  • Shopify

  • WooCommerce

  • Stripe

  • Download