Automate Excel Model Update - Add Data
Build comprehensive historical records by continuously appending new data to an existing Excel workbook. Perfect for cumulative tracking, trend analysis, and any scenario where you need to preserve and build upon previous data.
What It Does
The Update - Add Data automation maintains a single Excel workbook and appends new data each time it runs. Previous data remains intact while new rows or sections are added, creating a growing historical record.
How It Works
When to Use This Automation
Update - Add Data automation is ideal for building cumulative datasets where historical context matters:
Transaction Logging
Continuously append new transactions, sales, or events to build a complete activity log over time.
Example: Automatically append daily sales transactions to build a year-to-date sales log. Each day adds new rows while preserving all historical data for cumulative analysis.
Time-Series Analysis
Build datasets for trend analysis by adding periodic measurements or metrics that accumulate over months or years.
Example: Monthly revenue and expense data appended each month. After 12 months, you have a complete year for annual analysis. After 24 months, year-over-year comparisons become possible.
Accounting & Financial Records
Build comprehensive accounting records by continuously adding new entries from bank feeds, invoices, or receipts.
Example: Budget model that automatically appends actual expenses from bank feeds at regular intervals, building complete expense tracking alongside budget projections.
Performance Tracking
Track KPIs, metrics, or performance indicators over time by adding periodic snapshots that build a historical performance record.
Example: Weekly team performance metrics appended every Monday. Over months, this builds a complete dataset showing performance trends, seasonal patterns, and long-term progress.
Inventory Movements
Log all inventory changes, shipments, and adjustments to maintain a complete audit trail of stock movements.
Example: Append daily inventory adjustments from warehouse system. Creates complete movement history for auditing, trend analysis, and forecasting.
Setup Process
Setting up an Update - Add Data automation requires defining how new data should integrate with existing records:
Select the Session to Update
Choose which existing Viete session/workbook should receive appended data:
- • Select from your existing Viete sessions
- • The chosen workbook becomes the base that grows over time
- • Ensure the initial structure supports appending (proper headers, formulas)
Note: This requires an existing session. If starting from scratch, create the initial workbook with proper structure first, then set up append automation on it.
Configure Data Sources & Prompt
Specify where new data should come from and how to append it:
- • Connect to data sources via MCP servers (optional)
- • Write a prompt describing what new data to fetch and how to append it
- • Specify "append" mode to add data without overwriting
- • Define which sections should receive new rows/entries
- • AI intelligently determines where and how to add data based on existing structure
Set Schedule
Determine when new data should be appended:
- • Use Excel tables for automatic formula extension
- • Use structured references that grow with data
- • Set up summary formulas that calculate across all data
- • Configure charts to include new data automatically
Set Schedule
Determine when new data should be appended:
- • Choose append frequency: hourly, daily, weekly, monthly, or custom (cron)
- • Set start date and specific time for first append
- • All schedules use Norwegian time (Europe/Oslo timezone)
- • Next append is automatically calculated based on frequency
Test and Activate
Verify behavior before activating:
- • Save as draft initially
- • Optionally run a manual test to verify append behavior
- • Check that formulas extend correctly with new data
- • Activate the automation to begin scheduled appending
- • Monitor first few runs to confirm correct data accumulation
Key Features
- Historical data preserved automatically
- New data appended without overwriting
- Formulas auto-expand to include new rows
- Charts and visualizations grow with data
- Perfect for cumulative tracking and trends
- Builds comprehensive audit trails
Real-World Examples
Year-to-Date Sales Tracking
Daily sales transactions automatically appended each morning from the e-commerce platform. Builds complete YTD sales data with running totals, monthly summaries, and trend analysis.
Frequency: Daily, 8 AM
Data Sources: Shopify API, payment processor
Appends: Daily transaction rows with date, amount, product, customer
Monthly Financial Actuals
Budget vs. actuals model updated monthly with new expense and revenue data. Appends each month's actuals alongside budget, building 12-month rolling comparison with variance analysis.
Frequency: Monthly, 2nd day at 9 AM
Data Sources: Accounting system API
Appends: New month column with actuals for all budget categories
Customer Activity Log
Weekly append of customer engagement metrics from CRM. Builds comprehensive customer activity history for cohort analysis, churn prediction, and lifetime value calculations.
Frequency: Weekly, Sunday 11 PM
Data Sources: CRM API, email platform, support tickets
Appends: Weekly customer metrics (logins, purchases, support contacts)
Formula Best Practices
To ensure formulas work correctly as data grows, follow these patterns:
Use Excel Tables (Recommended)
Excel tables automatically expand formulas when new rows are added:
=SUM(SalesTable[Amount])
=AVERAGE(SalesTable[Quantity])
These references automatically include all rows as the table grows.
Dynamic Named Ranges (Alternative)
Create named ranges using OFFSET or INDEX that adjust to data size:
=OFFSET(A2,0,0,COUNTA(A:A)-1,1)
This creates a range that grows as more data is added to column A.
Duplicate Prevention
When appending data, it's important to avoid adding the same records multiple times:
- Use date filters to fetch only new data since last run
- Configure incremental data fetching from sources
- Set up unique identifier checks before appending
- Use Viete's built-in duplicate detection
- Review automation logs to verify correct data ranges
Best Practices
- Use Excel tables for automatic formula expansion
- Set up summary sheets that calculate across all data
- Include date/timestamp columns for time-based analysis
- Archive old data periodically if files grow too large
- Test append behavior with sample data before activating
- Monitor file size and performance as data accumulates
Explore Other Automation Types
Create New Model
Generate separate workbooks for each time period
Update - Replace Data
Overwrite existing data to show current period only