Symptom: Error: "Line 1 cannot parsed using current delimiters" when importing from Microsoft Excel Spreadsheet or CSV
Product Family: Act!
Product: Act! Pro, Act! Premium
Version: v19.2 and later
Third Party: Microsoft Excel
Cause: This can occur due to invalid data delimiter formatting in the source data. Microsoft Excel allows you to split a single cell content into multiple cells based on a delimiter, which can be a tab, space, or a comma. For more information on delimiters, refer to the following Microsoft documentation:
Split a column of text (Power Query)
Solution: You will need to analyze your data and find the problematic formatting.
Note: This information is provided as a convenience. Act! does not provide support for Microsoft products or formatting your data for import into Act!. If you require assistance, it is recommended that you speak to an IT professional.
- Analyze the data to locate and correct invalid formatting
- Test the import again