HubSpot website URL import format

A Website URL format problem means a value in the mapped Website column is not shaped like a usable URL, or it has extra spaces that should be trimmed before export. HubSpot may store bad website text as-is or reject it depending on the property and import flow.

Use consistent values such as https://example.com or example.com, and avoid notes, placeholders, pasted sentences, or broken URL fragments in the Website column.

Website data often comes from forms, enrichment tools, or hand-edited spreadsheets. That creates extra spaces, copied labels, missing domains, and text that is not a website at all.

• Leading or trailing spaces can hide from view in spreadsheet cells.
• Values such as not a url are clearly not website addresses.
• Placeholders such as n/a should not be treated as real websites.
• Some malformed-looking values can still pass a basic URL parser, so final human review matters.

1. Trim spaces around every Website value.
2. Remove placeholders, notes, and values that are not websites.
3. Use a consistent domain or full URL format across the column.
4. Spot-check suspicious schemes, copied punctuation, and values from enrichment tools.
5. Review the mapped Website column in HubSpot before committing the import.

ReadyCSV suggests a safe trim cleanup as url_cleanup when the mapped Website value has leading or trailing whitespace. That finding is info-level and has canAutoApply enabled for the trimmed value.

ReadyCSV flags clearly invalid Website values as malformed_website warnings. Those findings are review signals with needs_review, not automatic URL rewrites.

Important limitation: ReadyCSV does not perform exhaustive URL validation. The current URL check catches values like not a url, but a typo'd scheme such as htp://example.com can still pass the local parser and should be reviewed manually.

For the wider file checklist, use how to format a CSV for HubSpot import and the CSV column format guide.