Why are Usage Statistic reports cutting off and restricting data to a single cell when exported to Excel?
Applies to
- OCLC Usage Statistics
Answer
This is caused by either an unsupported character, an erroneous space, or an open quote (ex. "The Fox and the Hound) in the report data. These are usually going to be found in metadata titles. Opening the report in Notepad and correcting the data, saving it, then opening it in Excel should fix the issue.