Home

Contact Us

General

Initiative B@bel

WSI Guidelines

Encoding

Principles

Unicode

Training

Tutorials

PUA

Conversion

Resources

Utilities

TECkit

Maps

Resources

Input

Principles

Utilities

Tutorials

Resources

Type Design

Principles

Design Tools

Formats

Resources

Font Downloads

Gentium

Doulos

IPA

Rendering

Principles

Technologies

OpenType

Graphite

Resources

Font FAQ

Links

Glossary


NRSI: Computers & Writing Systems

SIL HOME | SIL SOFTWARE | SUPPORT | DONATE

You are here: Encoding > Resources
Short URL: http://scripts.sil.org/ExcelUnicodeData

Unicode Character Properties Excel Workbook

Peter Constable and Bob Hallissy, 2015-04-26

Updated 2015-04-26

Unicode 7.0 workbook is now available.

Introduction

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.

COPYRIGHT AND PERMISSION NOTICE

Copyright © 1991-2015 Unicode, Inc. All rights reserved. Distributed under the Terms of Use in  http://www.unicode.org/copyright.html.

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 7.0
Bob Hallissy, 2015-04-26
Download "Unicode70UCD_Excel.zip", ZIP archive, 2MB [2028 downloads]
Unicode 6.1
Bob Hallissy, 2012-02-10
Download "Unicode61UCD_Excel.zip", ZIP archive, 2MB [5825 downloads]
Unicode 6.0
Bob Hallissy, 2010-11-29
Download "Unicode60UCD_Excel.zip", ZIP archive, 1MB [3036 downloads]

(with  Corrigendum #8)

Unicode 5.2
Bob Hallissy, 2009-10-10
Download "Unicode52UCD_Excel.zip", ZIP archive, 2MB [2892 downloads]
Unicode 5.1
Bob Hallissy, 2008-04-05
Download "Unicode51UCD_Excel.zip", ZIP archive, 1MB [3351 downloads]
Unicode 5.0
Bob Hallissy, 2007-07-16
Download "Unicode50UCD_Excel.zip", ZIP archive, 1MB [3238 downloads]
Unicode 4.1
Peter Constable, 2005-04-29
Download "Unicode41UCD_Excel.zip", ZIP archive, 1MB [4224 downloads]
Unicode 4.0
Peter Constable, 2003-05-01
Download "Unicode4UCD_Excel.zip", ZIP archive, 1015KB [4127 downloads]
Unicode 3.2
Peter Constable, 2003-04-24
Download "Unicode32UCD_Excel.zip", ZIP archive, 605KB [3280 downloads]
Unicode 3.1
Peter Constable, 2003-04-24
Download "Unicode31UCD_Excel.zip", ZIP archive, 551KB [2882 downloads]
Unicode 3.0.1
Peter Constable, 2003-04-24
Download "Unicode301UCD_Excel.zip", ZIP archive, 454KB [2634 downloads]
Unicode 3.0
Peter Constable, 2003-04-24
Download "Unicode30UCD_Excel.zip", ZIP archive, 451KB [2840 downloads]
Unicode 2.0
Peter Constable, 2003-04-24
Download "Unicode20UCD_Excel.zip", ZIP archive, 351KB [2814 downloads]

© 2003-2017 SIL International, all rights reserved, unless otherwise noted elsewhere on this page.
Provided by SIL's Non-Roman Script Initiative. Contact us here.