OpenAI CLI Data Preparation Tool Supported File Formats

AI-102 By islever Editorial Last updated

Short answer

E You can upload File1.tsv and File4.xlsx to the OpenAI CLI data preparation tool.

Question

You have a custom Azure OpenAI model. You have the files shown in the following table. You need to prepare training data for the model by using the OpenAI CLI data preparation tool. Which files can you upload to the tool? - Exhibit: OpenAI CLI Data Preparation Tool Supported File Formats
  1. File1.tsv only
  2. File2.xml only
  3. File3.pdf only
  4. File4.xlsx only
  5. File1.tsv and File4.xslx only Correct Answer

Key Takeaways

The question tests knowledge of supported file formats for the OpenAI CLI data preparation tool; the common trap is assuming only JSONL or CSV are accepted.

The OpenAI CLI data preparation tool supports specific file formats for converting training data into JSONL for fine-tuning. This page confirms that TSV and XLSX files are valid formats for upload to the tool.

Common mistake: Choosing File1.tsv only (Option A) because learners might forget or be unaware that Microsoft Excel (XLSX) workbooks are also supported by the data preparation tool.

Expert Analysis

Why the Answer Is Correct

The OpenAI CLI data preparation tool is designed to help format and validate training data for fine-tuning. According to official Microsoft documentation, the tool accepts several file formats as long as they contain a prompt and completion column/key. These formats include Tab-separated values (TSV) and Microsoft Excel workbooks (XLSX), making Option E correct.

Why the Other Options Are Wrong

Options A, B, C, and D are incorrect because they either exclude a valid format (XLSX in Option A) or include invalid formats. The tool does not support XML (File2.xml) or PDF (File3.pdf) files, as these cannot be directly parsed into the required prompt-completion pairs without prior conversion.

Community Comment Notes

Commenters debated whether only TSV/CSV are supported or if XLSX is also allowed. As Retep noted, the tool accepts "Tab-separated values (TSV) Microsoft Excel workbook (XLSX)" among others. Some users incorrectly claimed "tsv or csv only", overlooking the documented XLSX support.

Official Reference

https://learn.microsoft.com/en-us/azure/ai-services/openai/how-to/fine-tuning?tabs=azure-openai%2Ccompletionfinetuning%2Cpython-new&pivots=programming-language-studio#openai-cli-data-preparation-tool

This link opens the official vendor documentation in a new tab.

Exam Strategy

When asked about the OpenAI CLI data preparation tool, remember it supports a wider range of tabular formats (CSV, TSV, XLSX) and JSON/JSONL, not just JSONL. Always eliminate proprietary document formats like PDF or markup like XML unless explicitly stated.

Community Votes

E
59%
A
41%

59% of anonymous learners picked answer E. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 8 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 8

  1. Retep 👍 4 Answered E
    This tool accepts files in the following data formats, if they contain a prompt and a completion column/key: Comma-separated values (CSV) Tab-separated values (TSV) Microsoft Excel workbook (XLSX) JavaScript Object Notation (JSON) JSON Lines (JSONL) https://learn.microsoft.com/en-us/azure/ai-services/openai/how-to/fine-tuning?tabs=azure-openai%2Ccompletionfinetuning%2Cpython-new&pivots=programming-language-studio#openai-cli-data-preparation-tool
  2. pabsinaz 👍 3 Answered E
    Option E https://learn.microsoft.com/en-us/azure/ai-services/openai/how-to/fine-tuning?tabs=azure-openai%2Ccompletionfinetuning%2Cpython-new&pivots=programming-language-studio#openai-cli-data-preparation-tool
  3. a8da4af 👍 3 Answered E
    Answer is E, File 1 and 4, according to this link, file format (whether a CSV, JSON, XLSX, TSV or JSONL) is allowed as long as it's represented as a JSONL training example of a prompt-completion pair.
  4. e41f7aa 👍 2
    Answer is A. The OpenAI CLI data preparation tool currently supports the following file formats: JSONL: This is the preferred format for fine-tuning data. Each line in the file should be a valid JSON object representing a training example. CSV: Comma-separated values files can be used, but they might require some preprocessing to convert them into the correct JSONL format. TXT: Plain text files can be used, but they will likely need significant preprocessing to extract the relevant information and structure it as JSONL. Therefore, the answer is A. File1.tsv only.
  5. Turst 👍 2
    Data must be in JSONL format. The OpenAI CLI data preparation tool helps to convert the data. It's clearly A and E => https://learn.microsoft.com/en-us/azure/ai-services/openai/how-to/fine-tuning?tabs=azure-openai%2Ccompletionfinetuning%2Cpython-new&pivots=programming-language-studio#openai-cli-data-preparation-tool
Show 3 more comments
  1. syupwsh 👍 1 Answered E
    https://stackoverflow.com/questions/75559672/openai-gpt-3-api-which-file-formats-can-be-used-for-fine-tuning Answer is E
  2. jafaca 👍 9 Answered A
    tsv or csv only
  3. pabsinaz 👍 2 Answered E
    Option E

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Minimizing Dev Effort for Stream Anomaly Alerts

S-grade

Indexing Large OneDrive Files with Azure Video Indexer

S-grade

Maximizing Azure OpenAI Chatbot Response Accuracy

S-grade

Which LUIS Custom Entity Minimizes Training Utterances for Airport Names?

S-grade

← Back to AI-102 Study Guide