How To Fix /PRA/CHECK_INPUT086 - Save the file in csv format;System supports only csv format during upload

SAP Error Message - Details

• Message type: E = Error

• Message class: /PRA/CHECK_INPUT -

• Message number: 086

• Message text: Save the file in csv format;System supports only csv format during upload

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message /PRA/CHECK_INPUT086 - Save the file in csv format;System supports only csv format during upload ?

  The SAP error message /PRA/CHECK_INPUT086 indicates that the system is expecting a file in CSV (Comma-Separated Values) format during an upload process, but the file provided is in a different format. This error typically occurs in scenarios where data is being imported into SAP, such as during data migration or when uploading master data.
  Cause:
  
  Incorrect File Format: The file you are trying to upload is not in CSV format. It might be in Excel format (XLS/XLSX), TXT, or another unsupported format.
  File Extension: The file may have a .csv extension but is not actually formatted as a CSV file. For example, it could be saved as a text file with commas but not properly structured.
  Encoding Issues: The file might be encoded in a format that SAP does not support, such as UTF-16 instead of UTF-8.
  
  Solution:
  
  
  Convert the File to CSV:
  
  Open the file in a spreadsheet application like Microsoft Excel or Google Sheets.
  Choose "Save As" or "Download As" and select the CSV format.
  Ensure that you select the correct CSV format (e.g., CSV UTF-8) if prompted.
  
  
  
  Check the Content:
  
  Open the CSV file in a text editor (like Notepad) to ensure that the data is properly formatted. Each line should represent a record, and fields should be separated by commas.
  Ensure there are no extra commas, quotes, or special characters that could disrupt the format.
  
  
  
  Verify Encoding:
  
  Make sure the file is saved with the correct encoding. If using Excel, you can choose "CSV UTF-8" when saving.
  If using a text editor, you can usually select the encoding when saving the file.
  
  
  
  Test the Upload:
  
  After converting and verifying the file, attempt the upload again in SAP.
  
  
  
  Related Information:
  
  SAP Documentation: Refer to SAP's official documentation for guidelines on data uploads and supported file formats.
  Data Format Requirements: Check if there are specific requirements for the data structure in the CSV file, such as mandatory fields, data types, and delimiters.
  Error Logs: If the error persists, check SAP's error logs for more detailed information about the upload process and any additional issues that may be present.
  
  By ensuring that the file is correctly formatted as a CSV and meets all necessary requirements, you should be able to resolve the error and successfully upload your data into SAP.