Clay Icon

Issue with Gaps in CSV Import from Google Sheets to Clay

ยท
ยท

I need to understand why this keeps happening. I exported a lead sheet from google, and when I put it into clay as a CSV, I keep getting these weird gaps here is the link: https://app.clay.com/workspaces/263887/tables/t_UWGaxDgtvjJJ/views/gv_8UKu9WbQHSr4 If you check 10899, I have a huge gap, and I don't know why it is happening. It happens for other leadsheets as well... It messes up my data pretty bad

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    When importing CSV data into Clay, blank fields or gaps can appear for a couple of reasons:1. Object fields (like import context from HubSpot) won't display their raw data values. 2. Integration fields showing "run condition not met" in Clay will appear as blank spaces in the CSV.To minimize these gaps and create cleaner data sets, you can:1. Create a dedicated "CSV Export View" 2. Hide or remove unnecessary columns 3. Focus on including only the essential raw valuesAfter importing, you can leverage Clay's data cleaning and AI-powered formatting features to standardize your information and fill in any gaps. Sources: Import CSV [Clay 101] - Clay University Download as a CSV [Clay 101] - Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.