How it works
Sort distinct x knots, find the two surrounding knots for each query, and linearly interpolate y between them. Exact knots return their stored y.
Input definitions
- CSV: x,y
- Plain text; maximum 200,000 characters.
- Query x values
- Plain text; maximum 200,000 characters.
A worked example
- CSV: x,y
- x,y 0,0 1,10 2,30
- Query x values
- 0.5,1.5
Assumptions & limits
Entered-data numeric worksheet. Floating-point calculations are rounded for display. Statistical results describe the entered sample and depend on the stated model assumptions.
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 interpolation predict values outside the table?
No. Queries must fall within the entered x range. Interpolation assumes straight lines between adjacent knots; it does not fit a global curve or extrapolate.
How does Interpolate values from an XY table work?
Sort distinct x knots, find the two surrounding knots for each query, and linearly interpolate y between them. Exact knots return their stored y.
What are the limits of Interpolate values from an XY table?
Entered-data numeric worksheet. Floating-point calculations are rounded for display. Statistical results describe the entered sample and depend on the stated model assumptions.
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.