
Import Only the HubSpot Records You Actually Need
The HubSpot Importer now lets you filter records by date before anything is brought across, so you can move only the contacts, deals, companies and tasks that are still worth having. You set the filters on the Preview and import step and watch the record counts update before you commit. This keeps a migration small and clean instead of dragging years of dead records into your new database.
How do I filter records before importing from HubSpot?
The filters live on the Preview and import step, on each row of records. You open a row, choose a field, a condition and a value, then apply it and check the counts before starting the import.
- Go to Contacts, Companies or Opportunities and click Import.
- Choose Import from HubSpot and continue through the wizard to Preview and import.
- Click the pencil icon on a records row, for example Contacts records.
- Choose a field, a condition and a value.
- Click Apply filters, or Apply filters to all objects.
- Review the updated record counts and start the import.
Which records can I filter?
Contacts, Deals, Companies and Tasks each get their own filter. Because the filters are separate, you can be strict with one object and open with another, for example taking only the last six months of deals while bringing every contact across. Each object shows its own count so you can see the effect of each filter on its own.
Which dates can I filter on?
Two date fields are available: HubSpot Created Date and HubSpot Last Modified Date. Created Date is the one to use when you want records from a certain period, and Last Modified Date is the better choice for pulling only records someone has actually touched recently. Date filtering currently supports these two fields and no others.
- Relative ranges such as In the last 6 months or This quarter.
- Exact date conditions: On, Before, After and Between.
- A preview of the exact date range before you apply it, so you can confirm it covers what you expect.
Note that In the last excludes today.
Can I combine more than one condition?
Yes. Use Add nested filter to stack conditions, and combine them with AND or OR logic. AND narrows the set, so a record must satisfy every condition to come across, while OR widens it to records matching any one of them. This is how you build a rule like created in the last year or modified this quarter.
Do I have to set the same filter on every object?
No. Apply filters to all objects copies the conditions you have just built onto every selected object in one click. Use it when you want a single cut-off date across the whole migration, and set each object separately when their rules differ.
How do I know how many records will come in?
The counts update immediately each time you apply a filter, showing records found and records to be imported. Check them before starting so there are no surprises once the import is running. If a count looks wrong, adjust the condition and watch it change again.
What happens if I leave the filters empty?
Everything is imported. Filters are optional, so leaving them empty gives you the same full migration you would have had before. Add them only where you want to cut something out.
You will find this under Contacts, Companies or Opportunities, by clicking Import, choosing Import from HubSpot, and opening the Preview and import step.

