Table of Contents
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.
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.
|
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.
|