---
title: "How do I prepare a random sample of documents for QC?"
slug: "how-do-i-prepare-a-random-sample-of-documents-for-qc"
updated: 2025-07-05T15:45:26Z
published: 2025-07-10T15:06:14Z
canonical: "docs.revealdata.com/how-do-i-prepare-a-random-sample-of-documents-for-qc"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.revealdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How do I prepare a random sample of documents for QC?

Using Excel formulas to prepare a random sample set of documents

To create a random ordering of your data for quality control purposes, you will need to use Logikcull and a spreadsheet software like Excel or Google Sheets.

## In Logikcull:

1. Filter for the set of documents that you'd would like to create a random set within, e.g. documents tagged with "Responsive".

2. Download a CSV with the Logikcull ID as a Selected Field.

![](https://cdn.us.document360.io/3e21d801-ca9f-4c51-93db-9cbd32741f3d/Images/Documentation/how-do-i-prepare-a-random-sample-of-documents-for-qcnbsp-image-a9w4fa70.png)

![](https://cdn.us.document360.io/3e21d801-ca9f-4c51-93db-9cbd32741f3d/Images/Documentation/how-do-i-prepare-a-random-sample-of-documents-for-qcnbsp-image-yan0lfqd.png)

3. Download the CSV and open in your preferred spreadsheet software (such as Excel or Google Sheets). ![0_1](https://cdn.us.document360.io/3e21d801-ca9f-4c51-93db-9cbd32741f3d/Images/Documentation/0_1.png)

The next steps require the spreadsheet software:

1. Create a new column and label the header to indicate that this will be a random number, e.g. "random_number".

2. In the first cell underneath the new "random_number" column, type =RAND() 3. Double click on the fill handle on the bottom right corner of the cell where the formula was input to copy it to all the values in the column.

![](https://cdn.us.document360.io/3e21d801-ca9f-4c51-93db-9cbd32741f3d/Images/Documentation/how-do-i-prepare-a-random-sample-of-documents-for-qcnbsp-image-xi6w7zqe.png)

4. Create a new column and label the header to indicate that this will be input into the bulk keyword search, e.g. "bulk_keyword"

5. In the first cell underneath the new bulk_keyword column, type

=CONCATENATE("file_id:",A2)

6. Double-click on the fill handle on the bottom right corner to copy this formula to all the values in the column.

![](https://cdn.us.document360.io/3e21d801-ca9f-4c51-93db-9cbd32741f3d/Images/Documentation/how-do-i-prepare-a-random-sample-of-documents-for-qcnbsp-image-9ac0vc86.png)

7. Sort the records by the random_number column 8. Choose the first "x" cells from the bulk_keyword column (x being the number of documents that you want to sample).

9. Paste these values into the bulk keyword search feature, and hit "Search"!

![](https://cdn.us.document360.io/3e21d801-ca9f-4c51-93db-9cbd32741f3d/Images/Documentation/how-do-i-prepare-a-random-sample-of-documents-for-qcnbsp-image-joren8ob.png)

## How to Video

[How to Create a Random Sample for QC](https://cdn.us.document360.io/3e21d801-ca9f-4c51-93db-9cbd32741f3d/Images/Documentation/How%20to%20Create%20a%20Random%20Sample%20for%20QC.mp4)