# XLSX S3 Batch Processor Batch process XLSX files in S3-compatible object storage with filtering/cleaning and upload processed outputs back > Canonical page: https://elysiatools.com/en/tools/xlsx-s3-batch-processor - **Category:** Format Conversion - **Keywords:** xlsx, s3, batch, object storage, clean, filter, etl ## Overview 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 ## Inputs - **S3 Endpoint (optional)** (text): https://s3.amazonaws.com - **Region** (text) - **Bucket** (text) - **Access Key ID** (text) - **Secret Access Key** (text) - **Session Token** (text) - **Object Keys (newline/comma)** (textarea): invoices/a.xlsx invoices/b.xlsx - **Sheet Name** (text): Sheet1 - **Header Row** (number) - **Filter Column** (text): status - **Filter Operator** (select) - **Filter Value** (text) - **Output Format** (select) - **CSV Delimiter** (text) - **Trim Whitespace** (checkbox) - **Remove Empty Rows** (checkbox) - **Upload Processed Files Back** (checkbox) - **Output Prefix** (text) ## 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. ## Frequently asked questions ### 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. ## Related tools - [CSV File Merger](https://elysiatools.com/en/tools/csv-merger): Merge multiple CSV files into a single file with options for header handling and deduplication - [Barcode Batch Generator](https://elysiatools.com/en/tools/barcode-batch-generator): Batch generate Code 128, EAN-13, UPC-A, ITF-14, QR Code, and Data Matrix outputs from CSV or multiline text - [XLSX Column Mapper](https://elysiatools.com/en/tools/xlsx-column-mapper): Rename, reorder, and drop Excel columns with alias matching and case/whitespace normalization - [XLSX CSV Batch Converter](https://elysiatools.com/en/tools/xlsx-csv-batch-converter): Batch convert CSV/TSV to XLSX or convert XLSX back to CSV/TSV with delimiter and encoding handling - [XLSX Sheet to CSV Pack](https://elysiatools.com/en/tools/xlsx-sheet-to-csv-pack): Export each Excel worksheet as an individual CSV file and include a manifest with schema/statistics - [CSV to Excel Converter](https://elysiatools.com/en/tools/csv-to-excel): Convert CSV data to Excel format with customizable parsing and formatting options - [Text to Excel Converter](https://elysiatools.com/en/tools/text-to-excel): Convert various text formats to Excel with customizable parsing and formatting options - [Time Series Anomaly Detector](https://elysiatools.com/en/tools/time-series-anomaly-detector): Upload CSV or JSON time series data, detect anomalies with Z-Score and IQR methods, and return a chart-backed report ## Samples - [XLSX Samples](https://elysiatools.com/en/samples/xlsx-samples): Sample XLSX spreadsheets for worksheet parsing and data extraction testing - [XLS Samples](https://elysiatools.com/en/samples/xls-samples): Sample legacy Excel (XLS) files for binary spreadsheet parsing and import tests - [CSV Samples](https://elysiatools.com/en/samples/csv-samples): Sample CSV files with various data types, sizes, and complexity levels - [Python Samples](https://elysiatools.com/en/samples/python): Essential Python code examples and Hello World demonstrations ## Related content - [XLSX ETL Ingestion and Warehouse Handoff](https://elysiatools.com/en/hubs/xlsx-etl-ingestion-workflows): Turn mixed workbook and CSV sources into traceable, schema-aware outputs for SQL loading, Parquet pipelines, and object-storage batch handoff.