Delete Rows from Excel - Cleanup for Make

PDF4me Delete Rows from Excel module removes single rows, multiple rows, and ranges using simple comma-separated syntax (e.g., "1-5,10,15-20") with safe bottom-to-top processing to avoid index shifting.

Authenticating Your API Request

To access the PDF4me Web API through Make, every request must include proper authentication credentials. Authentication ensures secure communication and validates your identity as an authorized user, enabling seamless integration between your Make scenarios and PDF4me's Excel row deletion services.

Get your API Key

Key Features

• Flexible Range Syntax: Single rows, ranges, or mixed combinations
• Multiple Range Support: Process many ranges at once
• Safe Deletion Order: Bottom-to-top to prevent shifting issues
• Worksheet Targeting: Name or default first sheet

Parameters

Complete list of parameters for the Delete Rows from Excel module. Configure these parameters to control row deletion behavior.

Important: Parameters marked with an asterisk (***) are required and must be provided for the module to function correctly. Rows are processed bottom-to-top to avoid index shifting.

Parameter	Type	Description	Example
File Name***	String	Excel Document Name • Filename with .xlsx or .xls extension • Used for output identification • Supports dynamic naming from scenario variables	data.xlsx
Document***	Buffer	Excel File Content • Map from previous module (Drive/Dropbox/HTTP) • Binary Excel document for row deletion • Workbook structure preserved except deleted rows	[Buffer]
Row Ranges***	String	Deletion Range Specification • Comma-separated list of row numbers and ranges • Single rows: "5,10,15" deletes rows 5, 10, and 15 • Ranges: "1-5" deletes rows 1 through 5 inclusive • Mixed: "1-5,10,15-20" combines ranges and singles • 1-based indexing: Row 1 is the first row • Processed bottom-to-top automatically	1-5,10,15-20
Worksheet Name	String	Target Worksheet Name • Name of worksheet to delete rows from • Default: First worksheet if not specified • Must match worksheet name exactly (case-sensitive)	Sheet1

Output

Table

Table View

Parameter	Type	Description
Name	String	Output Excel filename
Doc Data	Buffer	Excel with rows deleted

JSON

JSON Response Format

The raw JSON response from the module:

{
  "Name": "data.xlsx",
  "Doc Data": "[Buffer Data]"
}

Scenario Integration

Make Scenario Usage

Use Excel with deleted rows in subsequent modules:

• Report Cleanup: Remove unnecessary header/footer/note rows before distribution
• Data Archival: Delete outdated rows beyond retention period
• Template Preparation: Remove sample/example rows from templates
• Client Distribution: Clean internal-only rows before external sharing

Scenario Examples

The PDF4me Delete Rows from Excel module in Make provides comprehensive scenario templates designed for real-world data cleanup needs:

Report Cleanup

Automated Report Row Cleanup Workflow

Prepare client-ready reports by removing internal rows automatically:

Complete Scenario Steps:

1. Trigger: Weekly report generation completion event
2. Get Internal Report: Retrieve full report with notes from Google Drive
3. Identify Internal Rows: Rows 1-3 (title/internal notes), row 25 (calculation notes)
4. Delete Internal Rows: Remove "1-3,25" using comma-separated syntax
5. Preserve Data Rows: Deletion processed bottom-to-top (row 25 first, then 1-3)
6. Target Correct Sheet: Worksheet Name = "Report" for specific targeting
7. Upload Clean Report: Save client-ready version to Google Drive client folder
8. Email Client: Send notification with clean report download link
9. Archive Original: Store full internal version in archive folder
10. Log Cleanup: Record cleanup event with timestamp and row counts

Business Benefits:

• Cleans 52 weekly reports automatically per year
• Removes internal notes and calculations before client distribution
• Bottom-to-top processing prevents row number shifting errors
• Eliminates manual row deletion saving 10 minutes per report

Create Scenario

Data Archival

Automated Data Retention Cleanup Workflow

Maintain data retention policies by deleting outdated rows automatically:

Complete Scenario Steps:

1. Trigger: Monthly data retention cleanup scheduled on first of month
2. Get Master Log: Retrieve transaction log Excel from SharePoint
3. Identify Old Rows: Query which row numbers contain data older than 24 months
4. Build Row Range: Dynamically build row range string (e.g., "5-150")
5. Delete Old Rows: Remove outdated rows using dynamic range
6. Preserve Headers: Ensure row 1 (headers) not included in deletion
7. Upload Updated Log: Save trimmed log back to SharePoint
8. Archive Deleted Data: Store deleted rows in separate archive workbook
9. Email Compliance: Send retention cleanup report to compliance officer
10. Update Retention Log: Record cleanup event in retention audit log

Business Benefits:

• Maintains data retention policy compliance automatically
• Deletes 2000+ outdated transaction rows monthly
• Reduces file size and improves performance
• Eliminates manual retention cleanup saving 2 hours monthly

Create Scenario

Template Cleanup

Automated Template Sample Row Removal Workflow

Prepare distribution-ready templates by removing sample data automatically:

Complete Scenario Steps:

1. Trigger: Template marked ready for distribution in content management
2. Get Master Template: Retrieve template with sample rows from template library
3. Identify Sample Rows: Rows 2-10 contain sample/example data
4. Delete Sample Rows: Remove "2-10" to clean template
5. Preserve Template Structure: Headers (row 1) and formulas preserved
6. Apply to Multiple Sheets: Repeat for each worksheet if needed
7. Upload Clean Template: Save distribution-ready template to public folder
8. Email Users: Notify team of new clean template availability
9. Archive Sample Version: Store template with samples in archive
10. Update Template Registry: Mark template as distributed in registry

Business Benefits:

• Prepares 20+ templates monthly for distribution automatically
• Removes sample data preventing user confusion
• Preserves formulas and formatting while cleaning
• Saves 15 minutes per template in manual cleanup

Create Scenario

Industry Use Cases & Applications

Finance & Accounting

• Client Report Cleanup: Remove internal note rows (1-3) and calculation rows before external distribution
• Data Retention Compliance: Delete transaction rows older than 7 years per retention policy
• Audit Trail Trimming: Remove test/sample entries from audit logs before archival
• Budget Template Preparation: Delete previous year's data rows from budget templates for new cycle
• Reconciliation Cleanup: Remove resolved discrepancy rows from monthly reconciliation workbooks

Sales & Marketing

• Campaign Result Cleanup: Delete test campaign rows before final performance reporting
• CRM Export Trimming: Remove inactive/deleted lead rows from CRM exports
• Pricing Sheet Updates: Delete outdated product rows from pricing sheets for clients
• Sales Report Finalization: Remove internal calculation rows before management distribution
• Forecast Cleanup: Delete historical forecast rows beyond 12-month rolling window

Human Resources

• Template Sample Removal: Delete example employee rows from HR templates before distribution
• Terminated Employee Cleanup: Remove separated employee rows from active roster spreadsheets
• Training Log Trimming: Delete completed training session rows older than 3 years
• Payroll Archive Preparation: Remove test payroll rows before quarterly payroll archival
• Benefits Enrollment Cleanup: Delete previous year's enrollment rows from new enrollment templates

Operations

• Production Log Retention: Delete production run rows older than retention period
• Equipment Log Trimming: Remove old maintenance event rows from equipment logs
• Quality Control Cleanup: Delete test/calibration rows from QC inspection logs
• Inventory History Trimming: Remove transaction rows older than 24 months from inventory logs
• Shift Report Finalization: Delete internal supervisor note rows before operations review distribution

Get Help

Make IntegrationGet your API KeyMake Documentation