Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Files & Cloud Storage

Files & Cloud Storage

Work with Excel Files from Drive, OneDrive and FTP

When you run it, it loads spreadsheets from local files, Google Drive, OneDrive or FTP, converts them, and calculates ages in the data.

Import it free Sign in to open it

What it does

## Working with Excel files 1. Load the spreadsheet file into the workflow (.xls, .xlsx, .csv). 2. Convert the file with Spreadsheet File node. This allows other nodes to access the data. 3. Transform and manipulate the spreadsheet data as needed 4. [Optional] Convert back to a spreadsheet file 5. [Optional] Save file locally or upload to a server ℹ️ This template shows how to work with spreadsheet files themselves. Use the Microsoft Excel 365 node to interact with the Microsoft Office 365 cloud platform.

The steps

  1. Read Binary File
  2. On clicking 'execute'
  3. Write Binary File
  4. Download from Google Drive
  5. Download from Microsoft OneDrive
  6. Download Excel File
  7. Work out Age
  8. Upload to SFTP
  9. Upload to Google Drive
  10. Upload to Microsoft OneDrive
  11. Read Spreadsheet File
  12. Write Spreadsheet File
  13. Error Handler
  14. Error Handler for 92b8375b

28 steps in total.

Similar automations

Files & Cloud StorageRead and Write Excel Files from Drive, OneDrive, FTP12 stepsFiles & Cloud StorageDownload and Upload a File over FTP4 stepsData Sync & ETLSync Finance CSV Files from OneDrive to Excel Tables12 stepsForms & SurveysLog Conference Feedback Forms to Excel on OneDrive10 steps