About the File Formats

File Types

When you use RANDOM.ORG's File Generation Service, each file your create will be made available in a number of formats. If your file contains many values, we'll only generate the file formats that support as many values as the file contains.

Plain Text (TXT)

The plain text format is the simplest possible format we support. Each value appears on a separate line. No quoting is used around the values. There are no column headings and no index column, simply your values one on each line.

This format is the easies to use if you want to process your file with a program.

Max values supported: 20,000,000

TXT Example
AAAAA BBBBB CCCCC
Comma-Separated Values (CSV)

In this format, there are two columns. In the first column are indices that indicate the number of each random value. In the second column are the random values themselves. The two columns as are separated by a comma. If your random values are strings or integers in a different base than 10, then they will be quoted. The first row contains headings for the two columns. If your values are quoted, then the headings will be quoted too.

This format will open in most spreadsheet applications.

Max values supported: 20,000,000

CSV Example
"Index","Random" 1,"AAAAA" 2,"BBBBB" 3,"CCCCC"
Tab-Separated Values (TSV)

This format is exactly like the CSV format, except that the two columns are separated with tab characters instead of commas.

This format will open in most spreadsheet applications, but you might have to import it rather than just clicking on the file.

Max values supported: 20,000,000

TSV Example
"Index" "Random" 1 "AAAAA" 2 "BBBBB" 3 "CCCCC"
Excel 97 (XLS)

This is a proprietary format for use with old versions of Microsoft Excel. It is quite limited in the number of values it supports, so if your file is large, we won't generate it in this format.

Max values supported: 65,535

Excel 2003 (XLSX)

This is a proprietary format for use with newer versions of Microsoft Excel. It will also open in most other spreadsheet applications.

Max values supported: 1,048,575

Quoting and Newlines

When quoting is used (as mentioned above), we use double quotes ("). If your random values are strings and can contain double quotes as one of the random characters, these will be converted to pairs of double quotes ("") in your file. This is the convention for CSV and TSV files. Despite the fact such a quoted quote is two characters, it is considered as one and will open that way in a typical spreadsheet application.

The file formats that are fundamentally text files (TXT, CSV and TSV) use CRLF newlines, i.e., the types used on Windows PCs. If this is a problem for you, let us know and we'll consider making a conversion tool to convert the files to Mac OS or Linux style newlines.