Process and Transform Spreadsheet Files
detail.loadingPreview
A workflow template for loading, processing, and saving spreadsheet files (XLS, XLSX, CSV) using n8n.
About This Workflow
This workflow demonstrates how to handle spreadsheet files within n8n. It covers loading data from various sources, converting it into a processable format, performing transformations, and optionally saving or uploading the processed data back into spreadsheet format.
Key Features
- Load spreadsheet files from local storage, public URLs, Google Drive, or Microsoft OneDrive.
- Convert spreadsheet files to a structured format (like JSON) for manipulation.
- Transform spreadsheet data using n8n nodes (e.g., calculating age based on dates).
- Convert processed data back into spreadsheet format (XLSX).
- Save processed files to local filesystem or upload to SFTP, Google Drive, or Microsoft OneDrive.
How To Use
- Load File into Workflow: Choose one of the '1.' sub-options to load your spreadsheet.
- 1A. From a public URL: Use the
Download Excel Filenode to fetch from a URL. - 1B. From the local filesystem: Use the
Read Binary Filenode (ensure it's enabled). - 1C. From a cloud platform: Use
Download from Google DriveorDownload from Microsoft OneDrive(ensure they are enabled and configured).
- 1A. From a public URL: Use the
- Convert the file into JSON format: Connect the file loading node to the
Read Spreadsheet Filenode. This node will parse the spreadsheet data. - Manipulate or transform your spreadsheet data: Connect
Read Spreadsheet Fileto nodes likeWork out Agefor data processing. You can add more nodes here for complex transformations. - [Optional] Convert node data back to .xls file: Connect your transformation nodes to the
Write Spreadsheet Filenode to save the data back into an XLSX format. - [Optional] Save file locally or upload to a server: Connect
Write Spreadsheet Fileto one or more of the upload nodes:- 4A. To a local filesystem: Use
Write Binary File. - 4B. To a webserver via (S)FTP: Use
Upload to SFTP(ensure it's enabled). - 4C. To a cloud service: Use
Upload to Google DriveorUpload to Microsoft OneDrive(ensure they are enabled and configured).
- 4A. To a local filesystem: Use
Apps Used
Workflow JSON
{
"id": "13b73699-911e-4aea-99c6-4845474e5206",
"name": "Process and Transform Spreadsheet Files",
"nodes": 5,
"category": "Data Transformation",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 13b73699-911e...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
CSV to JSON Converter with Multilingual Metadata Generation
A workflow to convert CSV data to JSON and generate structured metadata in both English and Chinese.