LogoHow To CSV

Fill Missing

Upload a dataset to begin

Supported formats: .csv,.xlsx,.xls,.xlsm,.xlsb,.tsv

Free users: Up to 1MB per file.
Sign in to upload files up to 10MB.
Upgrade for even larger files.

AboutFill Missing

Impute missing values using linear interpolation or defaults.Category: Cleaning & Preparation
Filling gaps in temperature sensor dataCompleting survey responsesPreparing datasets for machine learning
The Fill Missing tool is compatible with:Time SeriesSurvey DataSensor Logs.Run Data Health Check first to see exactly which columns have gaps, then apply Fill Missing with the strategy that fits each column, interpolation for sensor readings, defaults for categorical fields.
Missing data can break your analysis. This tool offers multiple intelligent strategies to fill gaps in your dataset: forward fill (use the last known value), backward fill, linear interpolation (estimate based on surrounding values), or fill with custom defaults like 0, "N/A", or column averages. Unlike simple "fill down" in Excel, this tool understands data types and applies context-appropriate filling. Essential for time-series data, survey responses, and sensor readings.

Frequently Asked Questions:

What filling methods are available?

Forward fill, backward fill, linear interpolation, mean/median filling, and custom default values.

Will this work for text columns?

Yes! For text columns, you can use forward/backward fill or specify custom default values.


Built for analysts and data scientists preparing time-series or survey data for modeling, where a stray blank cell can break the whole pipeline.