"The File Must be in Unicode Text Format (*.txt) or CSV Format (*.csv). Please Change the Format and Resubmit."

This error message appears when using the bulk add/edit function and the file is not recognized as a Unicode Text (*.txt) or CSV (*.csv) format.

Activity Log Error: The file must be in Unicode Text Format (*.txt) or CSV format (*.csv) Please change the format and resubmit.

Why Does This Issue Occurred?

This error occurs when the application cannot process bulk upload files in formats other than Unicode Text and CSV.

How To Fix The Issue

Steps for transforming the bulk sheet file format to an acceptable format for upload in the application.

  1. Open your bulk sheet in Excel.
  2. Click Save As.
  3. Select a folder that you will easily remember where to retrieve your file.
  4. Name your file.
  5. In the drop down menu underneath the filename field, select Unicode Text or CSV (Comma Delimited). Unicode Text is recommended.
  6. Click Save. Large files may also be compressed as a *.zip file after saving as a Unicode Text or CSV file.
  7. In the application, click on the appropriate Bulk Add/Edit link and upload the file. 

You should now be able to submit and process your bulk upload sheet without any Activity Log error.

Written by Marketing @ Marin Software

Last published at: June 30th, 2023