Why do multiline cells in my CSV file appear with a question mark at the end of each line in Excel?
- by Chris Lindsay
I'm currently working on a project where we'd like to allow a user to export their data to CSV. Some of the data we present has multiple values for a single cell, and so we use the standard CSV method of putting each value on its own line:
Column A, Column B, Column C
Value A, "Value B1
Value B2", Value C
Most of the time this works fine, but some people are reporting seeing a small question mark in a box character appear at the end of each line when they load the file in Excel. Why is this happening?