Sorting a contact view by two columns

Smart CRM & Sales Hub CRM
1

I would like to sort two columns, in Contact view. One by Company name (bespoke property) and then by surname. Like you can do this in Excel, can you do it in Hubspot

2

Hi @JGray30,

This is unfortunately not possible at this stage. However, other users have requested this before: https://community.hubspot.com/t5/HubSpot-Ideas/Sort-Deals-by-more-than-one-column/idi-p/811678

These requests submitted to the HubSpot Ideas section of the community are reviewed by the HubSpot product team, based on their popularity and the assumed demand. I’d recommend commenting and upvoting.

You can also help other HubSpot users find this request more easily (and drive traction) by accepting my reply as a solution. I’d appreciate it, too.

Have a great day!

3

Hello @JGray30 ,

At the moment, HubSpot only allows sorting by one column at a time in contact views. Unlike Excel, multi-level sorting (e.g., by Company and then Last Name) isn’t natively supported in the UI.

A simple workaround is to export the list to Excel or Google Sheets and sort it there.
As @karstenkoehler mentioned, you can also upvote the existing idea in the HubSpot Community to help push for this feature.

4

Yeah, this one tripped me up too when I first switched to HubSpot. Quick q: is your Company name a custom property or pulled from the associated Company object? HubSpot only lets you sort by one column at a time, so here’s what I usually do: Export the contact list with both fields (Company and Last name) Sort in Excel the way you want; Company first, then Last name If I need to act on that sorted list inside HubSpot, I add a temporary custom property like “Sort Batch A” and re-import Not ideal, but it works when you need a fast multi-level sort :slightly_smiling_face:

5

This still isn’t available. So unfortunately, you can’t natively apply a “sort by Company, then by Last Name” the same way you can in Excel or Google Sheets.

Workarounds:

  1. Export & Sort in Sheets/Excel

    • Export the view to Excel or Google Sheets.
    • There you can apply multi-level sorting (Company name first, then Last Name).

  2. Custom Property Approach

    • Create a calculated property that concatenates Company + Last Name into one field.
    • Sort by this combined property in HubSpot.
    • It’s a bit hacky, but it achieves a similar effect inside HubSpot without exports.

  3. Automated Reporting with Coefficient (easier option)

    • Use Coefficient’s certified 2-way sync between HubSpot and Google Sheets/Excel.
    • Pull your contacts (with Company name and Last Name) directly into a spreadsheet.
    • Apply the multi-level sort there — you can even keep it live on a refresh schedule (hourly, daily, etc.).
    • If you want to keep the view inside HubSpot, you can embed your sorted sheet back into a HubSpot dashboard so it looks and feels native, but with the flexibility you’re missing.

Note: I do work at Coefficient, so happy to answer any questions you have! I use it for tons of ops and reporting myself.