How to save a tab-delimited, UTF-8 encoded file in Excel

Asset Bank's metadata import requires the data file to be tab-delimited and encoded in UTF-8. It is often easy to edit the data file in Excel, but you must save it as tab-delimited, encoded as UTF-8 - otherwise Asset Bank may not be able to import it, or you may see strange characters (e.g. question marks) in the place of non-ASCI characters.

To save a text file as tab-delimited, UTF-8 encoded in Excel:

  • Choose File->Save as from the menu.
  • In the 'Save as type' dropdown > select 'Text (Tab delimited) (*.txt)'
  • Select 'Web Options' in the 'Tools...' dropdown at the bottom of the dialog box.
  • Select the 'Encoding' tab.
  • In the 'Save this document as:' dropdown, select 'Unicode (UTF-8)'

See also https://help.surveygizmo.com/help/article/link/encode-an-excel-file-to-utf-8-or-utf-16


Was this article helpful?

Yes No

Thanks for your feedback!