How it works
For each input row with enough observations, average that row and its previous window−1 values. Preserve the entered row order.
Input definitions
- CSV: period,value
- Plain text; maximum 200,000 characters.
- Trailing window size
- Enter the value in the labeled unit.
A worked example
- CSV: period,value
- period,value Jan,10 Feb,20 Mar,30 Apr,40
- Trailing window size
- 3
Assumptions & limits
Two-column ordered CSV, at most 1,000 rows. No missing numeric values, weighting or centered windows.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Does a moving average predict the next observation?
No. A trailing moving average smooths the values already present in the window. It lags changes and does not itself supply a forecast or causal explanation.
How does Moving average time-series worksheet work?
For each input row with enough observations, average that row and its previous window−1 values. Preserve the entered row order.
What are the limits of Moving average time-series worksheet?
Two-column ordered CSV, at most 1,000 rows. No missing numeric values, weighting or centered windows.
How do I keep the full worksheet?
Run the tool and choose Download file. The on-page table is a preview and may show only the first 20 rows; the downloaded file contains the full result. CSV downloads escape spreadsheet formula prefixes. Inputs and files are processed on your device.