How to troubleshoot and repair CSV files that generate an error
This document explains how to troubleshoot and repair CSV files that generate an error.
Document 3302 | Last updated: 10/05/2021 MJY
In rare instances, data exported from an MLS can contain issues in the Comma Separated Value (CSV) file — which causes the data to be misaligned with the appropriate field names, and ultimately causes problems when you try to import your data in QuickSource or Titan Analytics.
The most common cause for this is when one or more quotation marks ( " ) within the dataset aren't formatted properly. This is often found in fields such as Realtor Remarks, Public Remarks, or similar fields where comments or notes were manually entered and a quotation mark was entered unintentionally, or quotation marks were used to imply emphasis.
If you're encountering a problem or receiving an error when importing your CSV file, there are two ways you can resolve most issues:
In many cases, the quickest solution is to remove the remarks, comments, notes, and other similar fields from the custom export template you use on your MLS website. Then, export your data again without those fields, and try importing the new CSV file into QuickSource.
Improperly formatted quotation marks can appear in any field in a CSV file — not just commentary fields. So, if the first option doesn't correct the problem, or you're not sure which fields to remove, the second option is to manually correct the issue(s) in your CSV file:
You may need to click Find Next a few times before you find a cell that has a formatting problem. Formatting issues are often immediately apparent and stand out against the other cells in that column.