# HubSpot Import Checker: Find CSV Errors Free | Dedupely > Upload the CSV you plan to import into HubSpot. See the rows it skips, the values it imports empty and the duplicates it creates, then download a fixed file. - URL: https://dedupe.ly/tools/hubspot-import-checker - Section: tools - Site index: https://dedupe.ly/llms.txt - Any page: append `.md` to its URL for this plain-text form --- ## HubSpot import checker See which rows HubSpot rejects before you upload. [Use in Claude](https://claude.ai/customize/connectors?modal=add-custom-connector&connectorName=Dedupely%20free%20tools&connectorUrl=https%3A%2F%2Fdedupe.ly%2Ftools%2Fmcp) CSV file Or paste rows here First row is a header Check the file Free for 10 runs a day. ### Rows HubSpot refuses An email without a domain fails validation. A company with no name and no domain has nothing to match on. HubSpot skips the row and moves on. **This checker reads every row the way HubSpot does and fixes what it can.** ### Start from the columns HubSpot maps A header HubSpot does not know gets dropped. A dropdown value it does not know imports empty. A date in the wrong order reads the wrong way round. **The HubSpot templates use the property names its importer maps on its own.** ### The HubSpot import template #### HubSpot contacts template 16 columns, in the order the template downloads. | Column | What goes in it | Required | | --- | --- | --- | | Email | An email address | Matches records | | First Name | Text | | | Last Name | Text | | | Phone Number | Plus sign, country code and number | | | Mobile Phone Number | Plus sign, country code and number | | | Company Name | Text | | | Job Title | Text | | | Website URL | A web address | | | Street Address | Text | | | City | Text | | | State/Region | Text | | | Postal Code | Text | | | Country/Region | Text | | | Lifecycle Stage | One of the options in the CRM | | | Lead Status | One of the options in the CRM | | | Contact Owner | The user’s email | | #### HubSpot companies template 14 columns, in the order the template downloads. | Column | What goes in it | Required | | --- | --- | --- | | Company name | Text | One of these | | Company Domain Name | A domain such as example.com | One of these | | Phone Number | Plus sign, country code and number | | | Type | One of the options in the CRM | | | Number of Employees | A number, no currency signs | | | Annual Revenue | A number, no currency signs | | | Street Address | Text | | | City | Text | | | State/Region | Text | | | Postal Code | Text | | | Country/Region | Text | | | Lifecycle Stage | One of the options in the CRM | | | Company owner | The user’s email | | | LinkedIn Company Page | A web address | | ### Use it from a script or an AI agent [Use in Claude](https://claude.ai/customize/connectors?modal=add-custom-connector&connectorName=Dedupely%20free%20tools&connectorUrl=https%3A%2F%2Fdedupe.ly%2Ftools%2Fmcp) MCP https://dedupe.ly/tools/mcp every free tool in one connector (this one: check_crm_import) POST https://dedupe.ly/tools/api/import-checker { "crm": "hubspot", "csv": "..." } Docs https://dedupe.ly/tools/api/openapi.json [OpenAPI document](https://dedupe.ly/tools/api/openapi.json) · [API index](https://dedupe.ly/tools/api) · [llms.txt](https://dedupe.ly/llms.txt) ### Questions about HubSpot imports Why did my HubSpot import fail? A row is skipped when its email is not valid, a required field is missing, or its email matches more than one existing contact. Most other problems import the row and leave that field empty. Why are some fields empty after my import? HubSpot imports the row but drops a value it cannot read: a date in the wrong order, a number with letters in it, or a dropdown value that is not one of the property’s options. Does HubSpot not check the file itself? HubSpot reports errors from the first 1,000 rows of a file. This checker reads all of them. What date format does HubSpot accept? Day-month-year, month-day-year or year-month-day, with slashes, hyphens or dots. Pick the matching format in the importer. The fixed file writes every date as year-month-day. Does HubSpot remove duplicates on import? It matches contacts on email and companies on domain. A contact with no email or a company with no domain becomes a new record every time, and the same email twice in one file imports only one row. How do I format phone numbers for HubSpot? As a plus sign, the country code and the number, such as +12125550123. The checker rewrites numbers that way. ### More free tools [CSV dedupe](https://dedupe.ly/tools/csv-dedupe) [Name splitter](https://dedupe.ly/tools/name-splitter) [Email normalizer](https://dedupe.ly/tools/email-normalizer) [List merger](https://dedupe.ly/tools/list-merger) [Domain extractor](https://dedupe.ly/tools/domain-extractor) [Company normalizer](https://dedupe.ly/tools/company-normalizer) [Test data generator](https://dedupe.ly/tools/test-data-generator) [CRM import checker](https://dedupe.ly/tools/import-checker) [Phone number formatter](https://dedupe.ly/tools/phone-number-formatter) [Job title normalizer](https://dedupe.ly/tools/job-title-normalizer) [Fake contact generator](https://dedupe.ly/tools/fake-contact-generator) [Duplicate cost calculator](https://dedupe.ly/tools/duplicate-cost-calculator) [CSV to Excel](https://dedupe.ly/tools/csv-to-excel) [Excel to CSV](https://dedupe.ly/tools/excel-to-csv) [CSV validator](https://dedupe.ly/tools/csv-validator) [VCF to CSV](https://dedupe.ly/tools/vcf-to-csv) [CSV to VCF](https://dedupe.ly/tools/csv-to-vcf) [CSV to chart](https://dedupe.ly/tools/csv-to-chart) ### Get started for free 20 free trial merges and as much free support as you need to get your duplicates under control. [Talk to sales](https://meetings.dedupe.ly/meetings/hampus-isaksson/dedupely-zoom-schedule)[Try for free](https://v2.app.dedupe.ly/signup) [Or sign up with Google](https://v2.app.dedupe.ly/signup/google) Running CRM cleanup for clients? [See the Partner Program](https://dedupe.ly/become-a-partner) Skip to content