You are here: Encoding > Resources
Short URL: https://scripts.sil.org/excelunicodedata

Unicode Character Properties Excel and LibreOffice Calc spreadsheet

Peter Constable, Bob Hallissy, and Bobby de Vos, 2022-10-04

Updated 2022-10-04

Unicode 15.0.0 spreadsheet is now available

Introduction
1. Current
2. Old
Unicode Terms of Use
Downloads

Introduction

Current

For the update to Unicode 14.0 and later, a new layout of the spreadsheet was used. Previously, as described below, different tabs showed different files from the Unicode Character Database (UCD). Now, all the data is on one tab, and additional properties (as compared to previous versions) are shown.

Old

We have taken various files from the Unicode Character Database (UCD) and put them into an Excel workbook. The files in the UCD have been designed to be machine-readable. One result of this is that they are not as readable to humans. This is especially true of the original UCD file, UnicodeData.txt. By putting the content into an Excel workbook, the information can be presented in a much more readable way. Moreover, Excel provides some useful functionality that isn't available when reading the files in a text editor. In particular, by using Excel's AutoFilter feature, it becomes easy to do things such as showing only characters with compatibility decompositions, or characters with a canonical combining class of 220, or characters that have "WITH HOOK" in their name.

The content of different files have been placed into separate sheets in the workbook. There are also sheets that provide documentation such as the meanings of various codes used for certain properties (for instance, the values used in the General Category field of UnicodeData).

For some of the files, some minor changes have been made in how the content is organised as an aid to readability. For instance, a column for representative glyphs has been added to UnicodeData. None of the property values has been changed, however.

We have added representative glyphs to the sheet for the UnicodeData file. You will need to find appropriate fonts with which to format the cells containing each character. In some cases, leading spaces may have been added so that combining marks would be more likely to display.

For Unicode 6.1, Blocks.txt was added.

For Unicode 4.1, Scripts.txt was added.

For Unicode 4.0 and later, the contents of the following UCD files are included:

UnicodeData.txt
ArabicShaping.txt
BidiMirroring.txt
CompositionExclusions.txt
LineBreak.txt
DerivedAge.txt

For Unicode 3.2 and earlier version, only the contents of UnicodeData.txt is included.

Unicode Terms of Use

From Terms of Use

UNICODE, INC. LICENSE AGREEMENT - DATA FILES AND SOFTWARE

Unicode Data Files include all data files under the directories http://www.unicode.org/Public/, http://www.unicode.org/reports/, and http://www.unicode.org/cldr/data/. Unicode Data Files do not include PDF online code charts under the directory http://www.unicode.org/Public/. Software includes any source code published in the Unicode Standard or under the directories http://www.unicode.org/Public/, http://www.unicode.org/reports/ and http://www.unicode.org/cldr/data/.

NOTICE TO USER: Carefully read the following legal agreement. BY DOWNLOADING, INSTALLING, COPYING OR OTHERWISE USING UNICODE INC.'S DATA FILES ("DATA FILES"), AND/OR SOFTWARE ("SOFTWARE"), YOU UNEQUIVOCALLY ACCEPT, AND AGREE TO BE BOUND BY, ALL OF THE TERMS AND CONDITIONS OF THIS AGREEMENT. IF YOU DO NOT AGREE, DO NOT DOWNLOAD, INSTALL, COPY, DISTRIBUTE OR USE THE DATA FILES OR SOFTWARE.

Permission is hereby granted, free of charge, to any person obtaining a copy of the Unicode data files and any associated documentation (the "Data Files") or Unicode software and any associated documentation (the "Software") to deal in the Data Files or Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, and/or sell copies of the Data Files or Software, and to permit persons to whom the Data Files or Software are furnished to do so, provided that (a) the above copyright notice(s) and this permission notice appear with all copies of the Data Files or Software, (b) both the above copyright notice(s) and this permission notice appear in associated documentation, and (c) there is clear notice in each modified Data File or in the Software as well as in the documentation associated with the Data File(s) or Software that the data or software has been modified.

THE DATA FILES AND SOFTWARE ARE PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT OF THIRD PARTY RIGHTS. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR HOLDERS INCLUDED IN THIS NOTICE BE LIABLE FOR ANY CLAIM, OR ANY SPECIAL INDIRECT OR CONSEQUENTIAL DAMAGES, OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THE DATA FILES OR SOFTWARE.

Except as contained in this notice, the name of a copyright holder shall not be used in advertising or otherwise to promote the sale, use or other dealings in these Data Files or Software without prior written authorization of the copyright holder.

Downloads

Unicode 15.0.0
Bobby de Vos, 2022-10-04
Download "Unicode-15-0-0-UCD.zip", ZIP archive, 4MB [498 downloads]

Unicode 14.0
Bobby de Vos, 2021-12-14
Download "Unicode-14-0-UCD.zip", ZIP archive, 3MB [488 downloads]

Unicode 7.0
Bob Hallissy, 2015-04-26
Download "Unicode70UCD_Excel.zip", ZIP archive, 2MB [6381 downloads]

Unicode 6.1
Bob Hallissy, 2012-02-10
Download "Unicode61UCD_Excel.zip", ZIP archive, 2MB [9390 downloads]

Unicode 6.0
Bob Hallissy, 2010-11-29
Download "Unicode60UCD_Excel.zip", ZIP archive, 1MB [5255 downloads]

(with Corrigendum #8)

Unicode 5.2
Bob Hallissy, 2009-10-10
Download "Unicode52UCD_Excel.zip", ZIP archive, 2MB [4695 downloads]

Unicode 5.1
Bob Hallissy, 2008-04-05
Download "Unicode51UCD_Excel.zip", ZIP archive, 1MB [4957 downloads]

Unicode 5.0
Bob Hallissy, 2007-07-16
Download "Unicode50UCD_Excel.zip", ZIP archive, 1MB [5214 downloads]

Unicode 4.1
Peter Constable, 2005-04-29
Download "Unicode41UCD_Excel.zip", ZIP archive, 1MB [6764 downloads]

Unicode 4.0
Peter Constable, 2003-05-01
Download "Unicode4UCD_Excel.zip", ZIP archive, 1015KB [5863 downloads]

Unicode 3.2
Peter Constable, 2003-04-24
Download "Unicode32UCD_Excel.zip", ZIP archive, 605KB [4785 downloads]

Unicode 3.1
Peter Constable, 2003-04-24
Download "Unicode31UCD_Excel.zip", ZIP archive, 551KB [4246 downloads]

Unicode 3.0.1
Peter Constable, 2003-04-24
Download "Unicode301UCD_Excel.zip", ZIP archive, 454KB [3932 downloads]

Unicode 3.0
Peter Constable, 2003-04-24
Download "Unicode30UCD_Excel.zip", ZIP archive, 451KB [4214 downloads]

Unicode 2.0
Peter Constable, 2003-04-24
Download "Unicode20UCD_Excel.zip", ZIP archive, 351KB [4362 downloads]

© 2003-2023 SIL International, all rights reserved, unless otherwise noted elsewhere on this page.
Provided by SIL's Writing Systems Technology team (formerly known as NRSI). Read our Privacy Policy. Contact us here.