When importing sheet materials into MaxCut via a CSV file, you may encounter this error:

This happens when MaxCut cannot convert a value into the expected type—e.g., a number, boolean (true/false), or string—because the value is missing or formatted unexpectedly.

Example: a blank cell where MaxCut expected a boolean (true or false).

Common Causes

1. Delimiter/Separator Changed

   CSV values are separated by a delimiter (commonly a comma , or a semicolon ;). Some editors (and some regional settings) may change this automatically. If the delimiter in your file doesn’t match the delimiter you select during import, columns won’t align and conversions will fail.
   
   

2. Text Qualifier Changed

   Editors like Excel can remove or alter the text qualifier (commonly double quotes ") around text fields. If MaxCut expects quoted text but the quotes are missing (or changed to a different character), values containing commas, semicolons, or line breaks may be parsed incorrectly.

How to Fix

1. Open your CSV in a plain text editor (e.g., Notepad).

2. Identify the delimiter/separator in the file: look for the character between values (e.g., , or ;).

3. Identify the text qualifier: typically double quotes " wrapping text values.

4. In the MaxCut import dialog, select the same delimiter and same text qualifier you observed in the file.

5. Ensure required fields are present and correctly formatted (e.g., booleans must be true or false, not blank).

6. Save the file as CSV again. If you use non-English characters, consider saving as CSV UTF-8 to avoid encoding issues.

Tips to Prevent This Error

• Keep the same delimiter and text qualifier throughout the file.

• Avoid removing quotes around text fields that contain commas or semicolons.

• Double-check that boolean columns never contain blanks or unexpected text.

• Be mindful that some Excel regional settings default to semicolons as the delimiter.

Need Help?

If you need any assistance, please reach out to our support team at support@maxcutsoftware.com. We’re happy to help troubleshoot your CSV.