Skip to content
FileMyLove

Blank columns disappear from Excel to CSV: check the table boundary

Check missing trailing columns, keep required field names and distinguish empty values from absent fields before importing a CSV.

By FileMyLove Team2 min read

A delivery template has empty columns reserved for later use, but the CSV looks narrower. Check whether those columns contain any text, including headers. Do not add invented values simply to make the export look wider.

Know which boundary the tool exports

FileMyLove builds CSV rows from cell text. It removes empty rows at the end and trims columns beyond the last nonempty text value anywhere in the exported sheet. Formatting alone is not a field name. Empty cells inside the retained rectangle remain empty values.

For example, a sheet with headings ID, Name, Status keeps the Status column even when every status value is empty. An entirely empty column after Status is outside that text boundary. This is behavior of this converter, not a rule that every CSV exporter follows.

Match the receiving schema

RFC 4180 describes an optional header and recommends consistent field counts. It does not define your recipient's required column names or the meaning of missing data. Obtain those requirements before preparing the workbook.

Situation Suggested action
Required field with no values yet Keep its genuine header in the required position
Decorative blank space after the table Do not treat it as a data field
Headerless fixed-column import Validate the actual field count; use another export workflow if necessary
Blank value with a special meaning Agree that meaning with the recipient

Inspect a small delivery first

  1. Preserve the original workbook.
  2. Compare the required headers and column order with your sheet.
  3. Use Excel to CSV.
  4. Open the actual output with a CSV-aware viewer or the destination's import preview.
  5. Check the first and last fields in several records before importing everything.

Do not count commas manually when fields can contain quoted commas. See quoted CSV fields and line breaks.

Keep missing data honest

A blank value, zero and the text N/A are not interchangeable delivery choices. Our recommendation is to use only the recipient's agreed convention, never a dummy number to force a column to appear. The converter has no fixed-column-count control.

If gaps occur inside merged headings instead of at the table edge, follow merged cells and blank CSV values. Validate structure separately from whether the values themselves are correct.