Prospect List Upload Issues

Learn how to troubleshoot common issues like "Missing Data" errors or oversized lists for smooth prospect list uploads.

Prospect List Upload Issues
Adam Palicz
Jun 6, 2024

Uploading prospect lists is a critical part of setting up your campaigns, but several common issues can interfere with the process. Here’s how to navigate and resolve them:

1. Missing Data

  • Issue: A "Missing Data" error message may appear if the format is incorrect, multiple email addresses are included in one field, or the list contains unsupported special characters.
  • Solution: Ensure that your list is correctly formatted, with each email address in a separate field and free of unsupported special characters.

2. List Size Too Large

  • Issue: Uploading a list that requires over 2,000 credits for a single operation will cause an error.
  • Solution: We recommend uploading approximately 100, but no more than 200 leads at a time.

3. Hints for a Smooth Upload

  • Use a Template: If you're creating the list manually, use our template to ensure it meets the required format.
  • Avoid Common Issues: Ensure files have the correct characters and format to avoid upload failures. Remove any cell coloring, bolding, or other formatting.
  • Use CSV format instead of XLSX: Before uploading your prospect list to AI Piping, ensure it is in CSV format rather than XLSX.
    Here’s how to export your data from Excel as a CSV:
    1. Open your Excel file.
    2. Click on “File” in the top left corner.
    3. Select “Save As”.
    4. Choose the location where you want to save the file.
    5. In the “Save as type” dropdown menu, select “CSV (Comma delimited) (*.csv)”.
    6. Click “Save”.

This guideline covers the most common issues with prospect list uploads and how to solve them, but feel free to reach out to our team at info@aipiping.com for further assistance.