Clean up "USA", "US" and "United States" in Attio without losing data.
In Attio, deleting a select option also wipes that value from every record that has it, and there is no way to merge two options. This page moves the records from the options you want gone to the one you keep, then archives the old ones.
Nothing is deleted. You see every change before it happens, and every run can be undone.
Merge select options
1 Paste your Attio token
The token stays in this tab's memory and goes only to api.attio.com. Our server never sees it. Close the tab and it is gone. How to make one (it needs object_configuration:read-write and record_permission:read-write).
2 Pick the select attribute
Single and multi-select attributes are listed. Status attributes work differently in Attio and are not.
3 Choose what to merge
Options that look alike are grouped for you: same letters in a different case, extra spaces or dots, and a few common synonyms like US and United States. In each group, pick the option to keep. The others move into it.
Other options
Show the records
How it works
- Paste a token from your Attio workspace settings.
- Pick an object and a select attribute, for example Companies and Country. The page counts how many records hold each option.
- Check the groups. Look-alike options are grouped for you. Pick the one to keep in each group, take an option out of a group, or add one by hand.
- Preview. You get one line per option, like "26 records will move from USA to United States". Nothing changes in Attio until you press Apply.
- Apply. Each record is moved to the option you keep. Then the old options are archived, if you left that box ticked. An option is only archived once every record that had it has moved.
- Undo if you need to. The last run is kept in this browser, and you can download it as an undo CSV. Undo restores the old options first, then puts each record back.
What it changes in Attio
- The value of the one select attribute you picked, on the records that hold a merged option.
- On a multi-select, only the merged option is swapped. Every other value on the record stays. A record that had both "Partner" and "partners" ends up with one "Partner".
- The merged options are archived (optional). Nothing is ever deleted: not an option, not a record, not a value.
Making the token
You need to be an admin of the Attio workspace, or ask one to do this:
- In Attio, open the menu next to your workspace name and click Workspace settings.
- Open the Developers tab and click + New access token.
- Give it a name, for example "Option merger".
- Set two scopes:
object_configuration:read-write(to list objects, attributes and options, and to archive options) andrecord_permission:read-write(to read and update records). Leave the rest off. - Copy the token and paste it in step 1 above.
Attio tokens do not expire. When you are done, you can delete it on the same Developers page.
Pricing
Free
$0
Counting and the preview are always free. Your first 100 record changes are free, per Attio workspace. Undoing them, or changing the same records again, stays free.
Merge Pass
$19 one payment
As many records and attributes as you like for 30 days, in one Attio workspace. No subscription, nothing renews.
Your licence key (keep it):
Prices in USD. Local VAT/GST is included or added at checkout by Paddle depending on your country. If it does not do the job for you, ask for a full refund within 14 days, see the terms.
Questions
Is my token stored?
No. It stays in this tab's memory and is sent only to api.attio.com, straight from your browser. It never reaches our server and is not saved in the browser either. Close the tab and it is gone.
Why not just delete the extra options in Attio?
Because Attio deletes the value on every record that uses a deleted option. Delete "USA" and the 25 companies set to USA end up with no country at all. Moving those records to "United States" first is the step this page does for you.
Does it work with multi-select attributes?
Yes. Each record is read again just before it is changed, the merged option is swapped for the one you keep, and every other value on it stays. Attio's own "update" call adds multi-select values instead of replacing them, so the page uses the call that writes the full list for that one attribute.
What does "archived" mean here?
An archived option is hidden from the pickers in Attio but still exists. You can restore it in the attribute's settings, and Undo on this page restores it for you. The page never deletes anything.
Can I undo a run?
Yes. Press Undo this run, or keep the undo CSV and drop it into the page later. The undo shows what it will change first. It restores the archived options, then puts each record back, but only records still set to what the run wrote. If someone changed a record since, it is left alone.
Which options get grouped?
Options that are the same once case, spaces, dots, dashes and accents are ignored ("usa", "USA", "U.S.A."), plural and singular ("Partner", "partners"), and a short list of synonyms, mostly country names and codes like US, UK and Deutschland. The groups are only a suggestion. You choose the option to keep and can change any group before the preview.
What do you keep on your server?
Only what the free count needs: your Attio workspace id and the ids of the records changed for free, kept for 365 days. With a Merge Pass, the workspace id it is tied to. Never the token, record names or values. In this browser: the undo record of your last run (record ids, names and option ids) and your licence key if you bought one. A small cookie (ats_src) remembers which site sent you here, for our own sales counts.
How fast is it?
Attio allows 25 writes a second. The page stays under that and waits when Attio asks it to slow down, so about 1,000 records take two or three minutes. Keep the tab open until it says done.