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

Read and Write Excel Files from Drive, OneDrive, FTP

When you run it, Excel files are loaded from disk, Google Drive, OneDrive or FTP, converted to data items, and written back as spreadsheets.

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

Similar automations

Files & Cloud StorageWork with Excel Files from Drive, OneDrive and FTP28 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