How can be extracted and exported a list of all single values without duplicates from the column of an attribute table (e.g. "formations" column values of an attribute table of a vector geologic layer in order to have the list of formations without duplicates)?

  • 2
    Exported to where? What have you tried?
    – Erik
    Jul 14, 2023 at 9:37

2 Answers 2


The following tool will output a file containing all unique values in a column.

Vector > Analysis Tools > List unique values.

  1. Select the input layer
  2. Click the ellipsis within Target field(s). In the window that pops up, select your column of interest.
  3. Optional: Select Skip output
  4. Click Run

enter image description here

Voila! The output file containing the unique values is created.


To remove duplicates from any column, you can use the "Delete duplicates by attribute" tool from the Processing Toolbox.

Open the Processing Toolbox panel:

Open the Processing Toolbox panel.

Run the "Delete duplicates by attribute" tool:

Run the "Delete duplicates by attribute" tool:

As a result, you will get a layer where the column you selected does not contain duplicates. The column of the resulting layer can be exported to different formats, such as an ODS table.

Right click on the result layer: enter image description here

Select column export options: enter image description here

  • This approach will also preserve the geometry, which is barely required
    – Taras
    Jul 16, 2023 at 9:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.