{% extends 'portal.html' %} {% load static %} {% block breadcrumbs %} {% endblock breadcrumbs %} {% block main_content %}

Saving Unicode exports in Excel

Special Unicode characters such as ♂ or ♀ are allowed to be used throughout HAWC, including data visualizations. However, when importing data from existing spreadsheets, the input file must be saved in a compatible format to display these characters. When using Excel, a spreadsheet with data for export could be structured in the following way:

Excel File Example, with Unicode characters for sex specification.

To export for HAWC, in the Save-As dialog, select "Unicode Text":

Excel 2010 Save As Dialog Box. Select the "Unicode Text" option for exporting data for use in HAWC.

The data can now be imported for use in HAWC.

{% endblock %}