Fill Incomplete CSV Records

Fill in missing values in your CSV data with default values, carry-forward logic, or custom fill rules. Replace empty fields to create a complete dataset ready for import or analysis.

Input CSV

Options

Input CSV FormatDefine delimiter and quote characters used in the input CSV.

Fill Missing Data

Fill on the Left

Fill on the Right

Add new values to the start or end of incomplete rows.

Fill Empty Data

Fill Empty Values

Replace empty fields with the value below.

Empty Lines and Comments

Remove Empty Lines

Drop blank rows before filling columns.

Remove Comment Lines

Comments beginning with the symbol below are skipped.

Output CSV

What It Does

Fill in missing values in your CSV data with default values, carry-forward logic, or custom fill rules. Replace empty fields to create a complete dataset ready for import or analysis.

How It Works

Fill Incomplete CSV Records applies a focused transformation to the input so you can compare the before and after without writing a custom script for a one-off task.

Unexpected output usually comes from one of three places: the wrong unit of transformation, hidden formatting in the source, or an option that changes the rule being applied.

All processing happens in your browser, so your input stays on your device during the transformation.

Common Use Cases

Fill missing country fields with a default value for domestic datasets
Replace empty numeric fields with 0 for spreadsheet calculations
Apply carry-forward filling for time-series data with gaps
Set default status values for records missing a status column
Replace blanks with 'N/A' or 'Unknown' for reporting completeness

How to Use

Paste your CSV data into the input.
Specify the fill value (a default value for empty fields).
Choose which columns to fill or apply to all.
Click Fill and copy the completed CSV.

Features

Fill empty fields with a static default value
Apply different defaults to different columns
Fill only specific columns while leaving others empty
Handles whitespace-only fields as empty
Preserves all populated field values

Examples

Below is a representative input and output so you can see the transformation clearly.

Input

name,age,city
Ada,36,London
Lin,29

Output

name,age,city
Ada,36,London
Lin,29,

Edge Cases

Very large inputs can still stress the browser, especially when the tool is working across many rows. Split huge jobs into smaller batches if the page becomes sluggish.
Empty or whitespace-only input is technically valid but may produce unchanged output, which can look like a failure at first glance.
If the output looks wrong, compare the exact input and option values first, because Fill Incomplete CSV Records should be repeatable with the same settings.

Troubleshooting

Unexpected output often means the input is being split or interpreted at the wrong unit. For Fill Incomplete CSV Records, that unit is usually rows.
If a previous run looked different, check for hidden whitespace, changed separators, or a setting that was toggled accidentally.
If nothing changes, confirm that the input actually contains the pattern or structure this tool operates on.
If the page feels slow, reduce the input size and test a smaller sample first.

Tips

Use distinct fill values for different field types: 0 for missing numbers, 'Unknown' for missing text, and a past date like '1900-01-01' for missing dates. This makes it clear downstream that these are filled-in defaults, not real data.

Why Fill Missing CSV Values

Many tools choke on empty fields. Statistical functions return errors when they encounter blanks in numeric columns. Database imports may reject rows with NULL values in NOT NULL columns. Visualization tools may omit data points or display gaps in charts. Filling missing values with appropriate defaults keeps the data flowing through your pipeline without interruptions.

Choosing Fill Values

The right fill value depends on context. For numeric data, zero is common but can be misleading — average calculations will be skewed downward. For categorical data, a placeholder like "Unknown" or "Not Specified" preserves the record while clearly flagging the gap. For date fields, using a sentinel value like '1900-01-01' makes filled records easy to identify and filter.

Column-Specific Filling

Different columns need different defaults. The "country" column might default to "US" for a domestic dataset, while the "phone" column defaults to empty (since a bad phone number is worse than no phone number). This tool lets you specify different fill values per column.

Fill Strategies

Beyond static defaults, some datasets benefit from forward-fill (carry the last known value down) or backward-fill. These strategies are common in time-series data where a reading might be missing but the previous reading is a reasonable approximation. Use static fills for categorical and ID fields, and consider forward-fill for sequential measurements.

Frequently Asked Questions

Does filling change populated field values?

No. Only empty fields receive the fill value. All existing data remains unchanged.

Can I fill different columns with different values?

Yes. Specify a fill value per column. Columns not mentioned in your configuration are left as-is.

How are whitespace-only fields handled?

Fields containing only spaces or tabs are treated as empty and will be filled. Trim your data first if you want whitespace-only fields to be preserved.

Can I fill with the value from the row above (forward fill)?

Some configurations support forward-fill mode, where empty cells receive the last non-empty value from the same column. This is particularly useful for time-series data.

Is there a way to fill only rows that meet certain criteria?

This tool fills based on empty field detection, not on other field values. For conditional filling, use a spreadsheet or script with IF logic.

What if I want to fill with an empty string that is NOT treated as blank?

Once a field is filled, it contains the fill value and is no longer blank. If your fill value is itself an empty string, no visible change occurs.