Symptom: Error: "Line 1 cannot parsed using current delimiters" when importing from Microsoft Excel Spreadsheet or CSV
Product Details:
Product Family: Act!
Product: Act! Pro, Act! Premium
Version: v19.2 and later
Environment:
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. Swiftpage 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.
Product Details:
Product Family: Act!
Product: Act! Pro, Act! Premium
Version: v19.2 and later
Environment:
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. Swiftpage 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