Import a lookup from a CSV or Excel file
Import a CSV or Excel file so a value on a document is replaced by the one your system uses.
Import the table
Open Flows, then Lookups under the list (or press Ctrl K and choose Open Lookups), and select Import a table. Choose your file.
Check the rows
Look through the rows and change anything needed. Changes save as you type. A row with the same From as one above it, or with a To and no From, says so and is not saved until you fix it.
Use it in a file
Open the file on the flow's We send step (until a file uses it, the lookup's page links to each of your flows). Under More options: file type, when to send, separator, lookups, choose the lookup beside the column you want to swap. Then choose what to do with a value that is not in it: Keep the value or Leave it blank. The change saves. Once the setup is saved, it waits until you use your changes.
Optional: let AI suggest matches
If Set up suggestions appears on the lookup's page, select it and choose a CSV file, with headings in the first row, under Import list (CSV). It saves by itself. Column 1 is the value, and the other columns become a note that helps pick it.
Then, when you preview a file and a value was not found, select Suggest matches. Nothing is added until you press Accept. See Lookups for what is sent and how to accept, edit or reject.
Take the rows out again
Select Export CSV on the lookup's page.