Confluence Retirement

In an effort to consolidate USGS hosted Wikis, myUSGS’ Confluence service is scheduled for retirement on January 27th, 2023. The official USGS Wiki and collaboration space is now SharePoint. Please migrate existing spaces and content to the SharePoint platform and remove it from Confluence at your earliest convenience. If you need any additional information or have any concerns about this change, please contact Thank you for your prompt attention to this matter.

Quick Links

Child pages
  • Saving files in a Unicode file format for international character support
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Table of Contents

Unicode tab-delimited

In order to preserve accented and international characters in taxonomic fields, the uploaded lab result file must be saved in a Unicode file format; UTF-8, UTF-16, and UTF-32 are all acceptable. This page highlights the steps to save a Unicode-formatted tab-delimited file in the popular applications Microsoft Excel and Microsoft Access.


Microsoft Excel

To obtain a Unicode-formatted tab-delimited file from Excel, you must select "Unicode Text" (Windows) or "UTF-16 Unicode Text" (Mac) for the "Save as type"/"Format" option in the "Save As" dialog. The correct selection for each platform is shown in the screenshots below.


Microsoft Access

To obtain a Unicode-formatted tab-delimited file from Access, you must open the "Advanced" dialog in the "Export Text File" wizard. Once there, select {tab} as the "Field Delimiter" and "Unicode (UTF-8)" or just plain "Unicode" as the "Code Page". Examples are shown in the screenshots below.

  • No labels