Workflow: Update Excel - Add Data
Build comprehensive historical records by appending new data from user inputs to an existing workbook. Perfect for continuously logging transactions, building accounting records, or accumulating data that can't be automatically fetched.
What It Does
The Update - Add Data workflow maintains a single Excel workbook and appends new data each time you run it. You provide inputs (files, data), and Viete adds this information to existing records without overwriting historical data.
How It Works
When to Use This Workflow
Update - Add Data workflows are ideal for building datasets that can't be automatically fetched but need to accumulate over time:
Bank Statement Processing
Upload monthly bank statement PDFs to continuously build complete transaction history and accounting records.
Example: Upload bank statement PDF each month. Workflow extracts transactions and appends them to master accounting workbook. Over time, builds complete year-to-date or multi-year transaction log with categorization and analysis.
Expense Report Logging
Process uploaded expense receipts (PDFs, images) and continuously append to employee expense tracking.
Example: Employees upload expense receipts periodically. Workflow extracts amounts, dates, categories via OCR and appends to expense log. Builds comprehensive expense history with running totals and budget tracking.
Document Archive Building
Extract data from uploaded documents and build cumulative archive for historical reference and analysis.
Example: Upload client meeting notes (DOCX) after each meeting. Workflow extracts key points, action items, decisions and appends to master client history workbook. Creates complete engagement timeline.
Manual Data Collection
Collect data that must be manually entered or uploaded, building historical datasets for analysis.
Example: Upload weekly performance metrics CSV from systems without APIs. Workflow appends new week's data each time, building comprehensive performance history for trend analysis and forecasting.
Invoice & Receipt Tracking
Upload invoices or receipts as they arrive and build complete financial transaction log over time.
Example: Upload vendor invoices as PDFs whenever received. Workflow extracts vendor, amount, date, items and appends to accounts payable tracker. Builds complete AP history with aging analysis and payment tracking.
Setup Process
Select Session to Update
Choose the workbook where data should be continuously appended:
- • Select existing Viete session with proper structure
- • Or upload Excel template to create new accumulation workbook
- • Ensure structure supports growing data (Excel tables recommended)
Define Input Variables
Specify what data users will provide to append:
- • Files: PDFs, images, CSVs to process and append
- • Text: Descriptions, notes, metadata
- • Dates: Transaction dates, period identifiers
- • Categories: Classification or grouping info
Configure Append Behavior
Define how new data should be added to existing records:
- • Specify which sheet(s) receive new data
- • Define append location (bottom of table, specific position)
- • Map input data to columns in the workbook
- • Configure duplicate detection if needed
Set Static Parameters
Configure parameters that remain constant:
- • Data extraction rules from uploaded files
- • Category mapping and classifications
- • Formula templates for new rows
- • Validation rules for appended data
Test and Activate
Verify append behavior works correctly:
- • Run test with sample data
- • Verify new data appends without overwriting
- • Check formulas extend to new rows
- • Confirm summary calculations update
- • Save workflow for repeated use
Real-World Examples
Accounting Transaction Log
Upload monthly bank statement PDFs. Workflow extracts transactions and appends to master accounting workbook, building complete transaction history with automatic categorization.
Input Variables:
- • Bank statement PDF
- • Statement month/year
- • Account name
Static Parameters:
- • Transaction categorization rules
- • Running balance formulas
- • Budget comparison logic
Appends: All transactions as new rows in transaction log
Employee Expense Tracker
Team members upload expense receipts (images/PDFs) as incurred. Workflow uses OCR to extract amounts, dates, vendors and appends to expense log with automatic totaling.
Input Variables:
- • Receipt image/PDF files
- • Employee name
- • Expense category
Static Parameters:
- • OCR extraction rules
- • Expense categories list
- • Approval workflow flags
Appends: New expense rows with extracted data
Client Project Log
Upload client deliverables, meeting notes, or project documents. Workflow extracts key information and appends to client history tracker for comprehensive engagement record.
Input Variables:
- • Document files (DOCX, PDF)
- • Document type (meeting notes, deliverable, etc.)
- • Date
Static Parameters:
- • Key information extraction rules
- • Client name (for this specific workbook)
- • Summary format templates
Appends: New rows with document metadata and extracted key points
Key Features
- Historical data preserved automatically
- New data appended without overwriting
- Formulas auto-extend to include new rows
- Manual trigger when data is available
- Perfect for data that can't be automated
- Builds comprehensive audit trails
Formula Best Practices
To ensure formulas work correctly as data grows:
Use Excel Tables (Recommended)
Excel tables automatically expand formulas when workflow appends new rows:
=SUM(TransactionTable[Amount])
=AVERAGE(ExpenseTable[Cost])
These structured references automatically include all rows as table grows.
Duplicate Prevention
When appending data from uploaded files, preventing duplicates is important:
- Configure workflow to check for duplicate entries before appending
- Use unique identifiers (transaction IDs, timestamps) for matching
- Set up validation rules to flag potential duplicates
- Review session logs to verify correct data was appended
- Consider manual review step for critical data
File Size Management
As data accumulates, workbook size will grow. Consider these strategies:
For Active Tracking
- • Archive old data annually/quarterly
- • Use summary sheets for long-term trends
- • Keep active workbook focused on recent data
For Complete Archives
- • Viete handles large files efficiently
- • Use filters and pivot tables for analysis
- • Consider separate workbooks for different years
Best Practices
- Use Excel tables for automatic formula expansion
- Include timestamp columns for tracking when data was added
- Test with various file formats to ensure robust extraction
- Document expected file formats for workflow users
- Set up data validation to catch extraction errors
- Regularly review accumulated data for quality
Explore Other Workflow Types
Create New Excel
Generate new workbooks for each workflow run
Update - Replace Data
Overwrite existing data with new uploads