Skip to main content

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.

The rows are saved at once as a new lookup, named after the file, and it opens. A message says how many rows were saved. Undo in that message takes the import back.

If this fails

A message starting "Couldn't import" says why: we read CSV files and Excel .xlsx files, a lookup holds at most 20,000 rows, and a value can be at most 200 characters.

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.

Beside the name it says "Saved, edits save as you type".

If this fails

"Couldn't save" keeps what you typed. Select Try again.

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.

The file gets the swapped value. What the file looks like shows the result. Values the lookup did not find are listed under the preview.

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.

Accepted pairs join the lookup, and the preview updates.

If this fails

No Set up suggestions means AI suggestions are not switched on for your workspace.

Take the rows out again

Select Export CSV on the lookup's page.