XLSX S3 Batch Processor

Batch process XLSX files in S3-compatible object storage with filtering/cleaning and upload processed outputs back

Read XLSX objects from S3, transform rows, and return processed outputs.

  • Batch fetch by object key list
  • Optional row filtering by column/operator/value
  • Data cleaning (trim strings, drop empty rows)
  • Output as XLSX/CSV/JSON
  • Optionally upload processed files back to object storage

Example Results

1 examples

Batch Clean and Filter XLSX Objects

Read multiple xlsx files from object storage, clean rows, filter by column, and return zip manifest

xlsx-s3-batch-processor-example1.zip View File
View input parameters
{ "region": "us-east-1", "bucket": "my-data-bucket", "objectKeys": "input/a.xlsx\ninput/b.xlsx", "filterColumn": "status", "filterOperator": "equals", "filterValue": "paid", "outputFormat": "xlsx" }

Key Facts

Category
Conversion & Encoding
Input Types
text, textarea, number, select, checkbox
Output Type
file
Sample Coverage
4
API Ready
Yes

Overview

The XLSX S3 Batch Processor allows you to efficiently clean, filter, and transform multiple Excel files stored in S3-compatible object storage, streamlining your data preparation workflows without manual downloads.

When to Use

  • •When you need to perform bulk data cleaning or filtering across multiple XLSX files stored in an S3 bucket.
  • •When you need to convert large sets of Excel files into standardized CSV or JSON formats for downstream processing.
  • •When you want to automate the extraction of specific data subsets from cloud-hosted spreadsheets and save the results back to your storage.

How It Works

  • •Connect to your S3-compatible storage using your credentials and specify the object keys for the files you wish to process.
  • •Define your cleaning preferences, such as trimming whitespace and removing empty rows, to ensure data consistency.
  • •Apply optional filters by column and operator to isolate specific records, then select your preferred output format (XLSX, CSV, or JSON).
  • •Optionally enable the upload-back feature to automatically save your processed files directly to your S3 bucket with a custom prefix.

Use Cases

Automating the consolidation and cleaning of monthly financial reports stored in cloud buckets.
Filtering large customer databases to extract specific segments for marketing analysis.
Converting legacy Excel data into JSON format for integration with web applications or APIs.

Examples

1. Batch Filtering Paid Invoices

Data Analyst
Background
A company stores thousands of individual invoice files in an S3 bucket, and the analyst needs to extract only the 'paid' invoices for a quarterly audit.
Problem
Manually downloading and filtering each file is inefficient and prone to error.
How to Use
Input the list of invoice object keys, set the filter column to 'status', the operator to 'equals', and the value to 'paid'.
Example Config
filterColumn: status, filterOperator: equals, filterValue: paid, outputFormat: csv
Outcome
The tool generates a consolidated CSV file containing only the paid invoice records, ready for audit.

2. Cleaning and Standardizing Data Exports

System Administrator
Background
Raw data exports from a legacy system often contain inconsistent whitespace and empty rows that break downstream database imports.
Problem
The data requires consistent cleaning before it can be ingested into the new system.
How to Use
Configure the tool to process the raw files with 'Trim Whitespace' and 'Remove Empty Rows' enabled, then save the cleaned files back to a 'processed/' folder.
Example Config
trimWhitespace: true, removeEmptyRows: true, uploadBack: true, outputPrefix: processed/
Outcome
Cleaned, standardized files are automatically saved back to the S3 bucket, ready for immediate database import.

Try with Samples

csv, xlsx, xls
Duplicate Line Samples
Sample files with various types of duplicate lines for testing duplicate removal tools
preferred input family csv
csv
Regex Replace Samples
Collection of common and useful regex replacement patterns for text transformation and data cleaning
preferred input family csv
csv
XLSX Samples
Sample XLSX spreadsheets for worksheet parsing and data extraction testing
title token xlsx
xlsx, xls
Windows String Processing - C# Samples
Comprehensive C# string processing examples for Windows platform including string manipulation, splitting, joining, regex operations, and text analysis
preferred input family csv
csv

Related Hubs

CSV Export and Table Conversion Tools
Compare CSV to Excel, JSON, HTML, Markdown, XML, and text conversion tools in one hub for tabular export and interchange workflows.
Video-to-Audio and Animation Conversion Tools
Compare tools that turn video into audio, extract video streams, and convert between short-form video and animated image formats in one hub.
Video Preview, Extraction, and Subtitle Tools
Compare video preview generation, stream extraction, audio extraction, subtitle translation, and quick flip tools in one hub for lightweight video prep workflows.
CSV Cleanup and Table Reshaping Tools
Compare CSV cleanup, filtering, sorting, grouping, merging, splitting, and table reshaping tools in one hub for spreadsheet and import/export workflows.

FAQ

Can I process files from non-AWS S3-compatible storage?

Yes, you can provide a custom S3 endpoint URL to connect to other S3-compatible storage services.

What output formats are supported?

The tool supports exporting processed data as XLSX, CSV, or JSON files.

Does this tool modify my original files?

No, the tool reads your original files and creates new processed versions. If you enable the upload-back feature, the new files are saved as separate objects.

How do I filter data within the files?

You can specify a column name, select a comparison operator (like equals, greater than, or contains), and provide a filter value to extract only the rows that meet your criteria.

Is it possible to process multiple files at once?

Yes, you can provide a list of object keys separated by newlines or commas to process multiple files in a single batch operation.

API Documentation

Request Endpoint

POST /en/api/tools/xlsx-s3-batch-processor

Request Parameters

Parameter Name Type Required Description
endpoint text No -
region text No -
bucket text Yes -
accessKeyId text Yes -
secretAccessKey text Yes -
sessionToken text No -
objectKeys textarea Yes -
sheetName text No -
headerRow number No -
filterColumn text No -
filterOperator select No -
filterValue text No -
outputFormat select No -
csvDelimiter text No -
trimWhitespace checkbox No -
removeEmptyRows checkbox No -
uploadBack checkbox No -
outputPrefix text No -

Response Format

{
  "filePath": "/public/processing/randomid.ext",
  "fileName": "output.ext",
  "contentType": "application/octet-stream",
  "size": 1024,
  "metadata": {
    "key": "value"
  },
  "error": "Error message (optional)",
  "message": "Notification message (optional)"
}
File: File

AI MCP Documentation

Add this tool to your MCP server configuration: 

{
  "mcpServers": {
    "elysiatools-xlsx-s3-batch-processor": {
      "name": "xlsx-s3-batch-processor",
      "description": "Batch process XLSX files in S3-compatible object storage with filtering/cleaning and upload processed outputs back",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=xlsx-s3-batch-processor",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

If you encounter any issues, please contact us at [email protected]