Target group: Enterprise, Essentials
Last updated: December 2020
Table of Contents
Importing Data into PatentSight
Important Points to Keep in Mind
CN – Chinese Publication and Application Numbers
DE - German Publication and Application Numbers
EP – European Publication and Application Numbers
JP – Japanese Publication and Application Numbers
KR – Korean Publication and Application Numbers
US – US Publication and Application Numbers
WO – PCT Publication and Application Numbers
Importing Data into PatentSight
Overview of Import Functions
Users can import their own lists of patent numbers and internal information regarding these numbers into the PatentSight BI. The sets of patents imported and the information mapped to them can be used in various analyses. To import your patent data, you can choose from the three import options below:
- Quick import search results
"Quick import search results" is a convenient option to directly apply a list of patent numbers to the PatentSight search filter. Your tag will be automatically created and saved in a folder called "Quick imports" which can be found in your user folder. Once imported, you can always rename the tag or save it in a different folder.
NOTE: The option "Quick import search results" does not allow you to review and/or edit mismatched patent numbers during the import process. We therefore only recommend this option if you are working with a list of patent numbers that is importable into the PatentSight BI. If you want to make sure if and how a list of patent numbers imported has been matched, we recommend using one of the other import options. - Import patents to Tag
The option "Import patents to Tag" allows you to review numbers that could not be matched or have resulted in ambiguous matches. In many cases, the numbers can be matched correctly in the import dialogue by changing the format according to the PatentSight guidelines as outlined below. Moreover, you can export an overview of the matching results via the import dialogue.
Note that the option "Import patents to Tag" does not create a tag fully automatically. In the final step of the import process, you will have to name your tag and save it in a folder of your choice. Click HERE for more details on Tags and Tagging. - Import data to Custom Fields
Similarly to Tags, Custom Fields also allow you to import sets of patents of your choice. In contrast to tags, Custom Fields can be used not only as filter elements and groupings in charts and tables – they can also be used as measures, e.g. on chart axes. Click HERE for more details on Custom Fields.
Important Points to Keep in Mind
- The list of patent numbers to be imported
In general we recommend importing only publication numbers (or registration numbers). If your list contains both application and publication numbers, there is an increased risk of mismatches. Therefore, we highly recommend importing either a list with application numbers only or a list with publication numbers only. - Recently filed patents
Please note that patents that have been only recently filed or published at a local patent office might not yet be available in the PatentSight database. - Other IP rights
Please note that if you import other IP rights, such as utility models or design patents, even if these documents are matched correctly, they might not be available for analysis. - Difference between the number of patent documents imported and the import results in PatentSight
There may be a difference between the number of patent documents (rows) you have imported and the number of patent families your documents have been matched to. This can happed for the following reasons:- If you import a list of patent documents, in most cases, several documents will be matched to and aggregated into one patent family (Simple Patent Family) in the PatentSight BI.
- If your list contains inactive patents and utility models, these rights will not be automatically included in your analysis per default. If you want to include these rights, turn on "Incl. inactive" and/or "Incl. other IP rights" at the top of the search filter.
CN – Chinese Publication and Application Numbers
In general, Chinese publication numbers (公开号; 授权公告号) can be imported in the same format as they are stated in the original patent specifications.
To import Chinese patent numbers (专利号), "ZL" needs to be replaced by "CN". If the kind code is ".X", this kind code needs to be deleted.
When importing Chinese application numbers (申请号), the country code "CN" needs to be added. If the kind code is ".X", this kind code needs to be deleted.
CN (China) – Overview of Importable Number Formats
Unexamined patent publication numbers(公开号) |
Importable Format |
Comments |
CN t123456A |
CNt123456A |
|
CN t12345678.A |
CNt12345678A |
|
Examined patent publication numbers(授权公告号) |
Importable Format |
Comments |
CN t123456n |
CNt123456n |
|
CN t12345678n |
CNt12345678n |
|
Patent numbers(专利号) |
Importable Format |
Comments |
ZL yy123456.n |
CNyy123456.n |
|
ZL yyyy12345678.n |
CNyyyy12345678.n |
|
*"ZL" is an abbreviation for the Chinese term for "patent" (专利; zhuānlì). |
||
Application numbers(申请号) |
Importable Format |
Comments |
yyt12345.n |
CNyyt12345.n |
|
yyyyt1234567.n |
CNyyyyt1234567.n |
|
yyt12345 |
CNyyt12345 |
|
yyt1234567. X |
CNyyt1234567 |
|
yyt12345. X |
CNyyt12345 |
|
|
||
Chinese International Application Numbers |
Importable Format |
Comments |
PCT/CNyyyy/012345 |
WOyyyyCN12345 |
|
PCT/CNyyyy/1234 |
WOyyyyCN01234 |
|
PCT/CNyy/00012 |
WOyyyyCN00012 |
DE – German Publication and Application Numbers
In general, German publication numbers can be imported in the same format as they are stated in the original patent specifications. However, we recommend deleting all spaces.
DEtyy12345(.)Xn (until 2003) country code (DE) + type of right (2 digits) + application year (4 digits) + serial number (6 digits) + kind code |
German application numbers can also be imported in the same format as they are stated in the original patent specifications. However, here too, we recommend deleting all spaces.
DEtyy12345.n (until 2003) country code (DE) + type of right (2 digits) + application year (4 digits) + serial number (6 digits) + check digit |
Note: Please make sure to import either a list of only publication numbers or a list of only application numbers! Mixing different kinds of numbers can result in mismatches. |
DE (Germany) ― Overview of Importable Number Formats
Publication Numbers |
Importable Format |
Comments |
Type of right “t” until 2003: Type of right “tt” since 2004: |
||
1 234 567 |
DE1234567A |
|
1 234 567 |
DE1234567B |
|
123 456 |
DE123456C |
|
DE yy 12 345 A 1 |
DEyy12345A1 |
|
DE tyy 12 345 A 1 |
DEtyy12345A1 |
|
DE tyy 12 345 B 4 |
DEtyy12345B4 |
|
DE tt yyyy 123 456 A1 |
DEttyyyy123456A1 |
|
DE tt yyyy 123 456 B4 |
DEttyyyy123456B4 |
|
DE tt yyyy 123 456 T5 |
DEttyyyy123456T5 |
|
* The two digits indicating the application year (yy) in DE publication numbers from 1968 to 1994 result from the last two digits of the application year minus 50. E.g.: 1968 → 18; 1990 → 50 ... |
||
Documents with the Kind Code “T1” |
Importable Format |
Comments |
DE/EP 1 234 567 T 1 |
DE1234567T1 |
|
DE/EP 0 123 456 T 1 |
DE123456T1 |
|
DE yy 123 456 T1 |
DEyy123456T1 |
|
DE tyy 12 345 T1 |
DEtyy12345T1 |
|
|
||
Application Numbers |
Importable Format |
Comments |
Type of right “t” until 2003: Type of right “tt” since 2004: |
||
X n X 12345 VIII/nnan |
― |
|
P yy 12 345.n |
DEyy12345.n |
|
tyy 12 345.n |
DEtyy12345.n |
|
tt yyyy 123 456.n (since 2004) |
DEttyyyy123456.n |
|
* The two digits indicating the application year (yy) in DE publication numbers from 1968 to 1994 result from the last two digits of the application year minus 50. E.g.: 1968 → 18; 1990 → 50 ... |
EP – European Publication and Application Numbers
EP publication numbers can be imported using the following number format:
EP1234567(.A1) country code (EP) + serial number (7 digits) (+ kind code) |
EP application numbers can be imported using the following number format:
EPyy123456.X (before 2000) country code (EP) + year (4 digits) + serial number (6 digits) + "." + kind code |
EP (European Patent Office) ― Overview of Importable Number Formats
Publication Numbers |
Importable Format |
Comments |
0 123 456 |
EP0123456 EP0123456.A |
|
0 000 123 |
EP0000123 EP123 |
|
EP 1 234 567 A1 |
EP1234567.A1 |
|
|
||
Application Numbers |
Importable Format |
Comments |
yy123456.X |
EPyy123456.X OR EPyyyy0123456.X |
|
JP – Japanese Publication and Application Numbers
If converting into Latin transcription, in general, Japanese patent numbers can be imported using the following number format:
country code + serial number + kind code |
Here, "serial number " refers to either the publication number or the application number. However, we recommend importing publication numbers. If you also want to import application numbers, we recommend making two separate lists (one with publication numbers and one with application numbers) and importing them separately.
Note: Depending on the publication or application number, several different documents may be matched (ambiguous match). To obtain more accurate matching results, we therefore recommend adding the kind code of the document following its serial number.
JP (Japan) – Overview of Importable Number Formats
Publication Numbers |
Importable Format |
Comments |
特開昭yy-123456 |
特開昭yy-123456 |
Chinese characters (kanji):
Latin characters (romaji):
|
特開昭yy-1234 |
特開昭yy-1234 |
|
特開平yy-123456 |
特開平yy-123456 |
|
特開平yy-001234 |
特開平yy-001234 |
|
特開平y-123456 |
特開平y-123456 |
|
特開平y-001234 |
特開平y-001234 |
|
特開yyyy-123456 (since 2000) |
特開yyyy-123456 |
Chinese characters (kanji):
Latin characters (romaji):
|
特開yyyy-001234 (since 2000) |
特開yyyy-001234 |
|
Patent Numbers |
Importable Format |
Comments |
特許第1234567号 |
特許1234567 OR JP1234567B |
Chinese characters (kanji):
|
特許第1234567号 |
特許1234567 OR JP1234567B2 |
Chinese characters (kanji):
Latin characters (romaji):
|
Application Numbers |
Importable Format | Comments |
特願平yy-123456 |
JPyyyy0123456 |
|
特願平y-123456 |
JPyyyy0123456 |
|
特願平yy-1234 |
JPyyyy0001234 |
|
特願平y-1234 |
JPyyyy0001234 |
|
特願yyyy-123456 |
JPyyyy0123456 |
|
Japanese International Application Numbers | Importable Format | Comments |
PCT/JPyyyy/012345 | WOyyyyJP12345 |
|
PCT/JPyyyy/1234 | WOyyyyJP01234 |
KR – Korean Publication and Application Numbers
When importing Korean documents into the PatentSight BI, we highly recommend using a list of publication numbers. It is necessary to add the country code "KR" and the kind code "A". Moreover, the serial number must consist of 7 digits.
To import Korean registration numbers, it is necessary to add the country code "KR" and the kind code "B1". Moreover, just like for publication numbers, the serial number must consist of 7 digits.
Although it is possible to import Korean application numbers into the PatentSight BI, we strongly recommend importing publication numbers instead. Since the application number of one Korean document can also exist as publication number of a different Korean document, PatentSight might interpret a list of application numbers as publication numbers. If you only have a list of Korean application numbers, we recommend the following workaround.
Workaround to import Korean application numbers:
- Make sure that your list only contains application numbers
- Add one application number of a different format (e.g. the PCT application number WO1978US00001) to your list, so that our system will recognize that you are importing application numbers (and not publication numbers).
- During the import process, uncheck the additional application number (WO1978US00001), so that it will not be added to your tag (see picture below).
KR (Korea) – Overview of Importable Number Formats
Publication Numbers |
Importable Format |
Comments |
yy-1234567 |
KRyy1234567A |
|
yy-12345 |
KRyy0012345A |
|
yy-123 |
KRyy0000123A |
|
yyyy-1234567 |
KRyyyy1234567A |
|
yyyy-1234 |
KRyyyy0001234A |
|
yyyy-123 |
KRyyyy0000123A |
|
tt-yyyy-1234567 |
KRttyyyy1234567A |
|
tt-yyyy-0001234 |
KRttyyyy0001234A |
|
tt-yyyy-0000001 |
KRttyyyy0000001A |
|
Registration Numbers |
Importable Format |
Comments |
yy-1234567 |
KRyy1234567B1 |
|
yy-1234 |
KRyy0001234B1 |
|
1234567 |
KR1234567B1 |
|
0123456 |
KR0123456B1 |
|
tt-1234567 |
KRtt1234567 |
|
tt-0123456 |
KRtt0123456 |
|
Application Numbers |
Importable Format |
Comments |
Since the application number of one Korean document can also exist in exactly the same format as the publication number of a different Korean document, we highly recommend importing publication numbers instead of application numbers. When importing application numbers, please use a list that only contains application numbers and double-check your matching results. |
||
yy-1234567 |
KRyy1234567A |
|
yy-1234 |
KRyy0001234A |
|
yyyy-1234567 |
KRyyyy1234567A |
|
yyyy-123456 |
KRyyyy0123456A |
|
YY-12345 |
KRyyyy0012345A |
|
tt-yyyy-1234567 |
KRttyyyy1234567A |
|
|
||
Korean International Application Numbers |
Importable Format |
Comments |
PCT/KRyyyy/012345 |
WOyyyyKR12345 |
|
PCT/KRyyyy/1234 |
WOyyyyKR01234 |
|
PCT/KRyy/00012 |
WOyyyyKR00012 |
US – US Publication and Application Numbers
In general, US publication numbers can be imported in the same format as they are stated in the original patent specifications:
USyyyy123456(7)(A1) country code (US) + year (4 digits) + serial number (6-7 digits) (+ kind code) |
US patent numbers can also be imported in the same format as they are stated in the original patent specifications:
US1234567(Bn) country code (US) + serial number (1-7 digits) (+ kind code) |
US application numbers can be also imported into the PatentSight BI – however, we strongly recommend importing publication numbers instead. In order to import US application numbers, the year (4 digits) must be added and, in some cases, the series code (≠ serial number) needs to be deleted.
US (United States) – Overview of Importable Number Formats
Publication Numbers |
Importable Format |
Comments |
1,234,567 (until 14/03/2001) |
US1234567 OR US1234567A |
|
US yyyy/1234567 A1 (since 15/03/2001) |
USyyyy1234567 OR USyyyy1234567A1 |
|
US yyyy/0012345 A1 (since 15/03/2001) |
USyyyy012345 |
|
Patent Numbers |
Importable Format |
Comments |
1 (until 01/01/2001) |
US1 |
|
1,234 (until 01/01/2001) |
US1234 |
|
1,234,567 (until 01/01/2001) |
US1234567 OR US1234567A |
|
US 1,234,567 B1 (since 02/01/2001) |
US1234567 OR US1234567B US1234567B1 |
|
US 1,234,567 B2 (since 02/01/2001) |
US1234567 OR US1234567B2 |
|
Application Numbers tt = series code* * For details click here |
Importable Format | Comments |
123,456 (no series code) |
USyyyy0123456 |
|
tt/123,456 (series code is 12 or below*) * until 16/12/2010 |
USyyyy0123456 |
|
tt/123,456 (series code is 13 or above*) * since 17/12/2010 |
USyyyytt123456 |
|
Note regarding the filing year (4 digits; yyyy) to be added to US application numbers: In case of PCT applications, do not use the filing year of the PCT application (“PCT filed”) but the year when the document was filed in the US (“Filing Date” of the USPTO). You can find this information in the Public Patent Application Information Retrieval of the USPTO Pubic Pair. |
||
Other Numbers | Importable Format | Comments |
Re. 12,345 (Reissue Patent) |
USRE12345 OR USRE12345E |
|
US RE12,345 E (Reissue Patent) |
||
H1234 (Statutory Invention Registration) |
USH1234 OR USH1234H |
|
US H1234 H (Statutory Invention Registration) |
||
US D123,456 S (Design Patent) |
USD123456 OR USD123456S |
|
Plant 1,234 (Plant Patent) |
US1234P |
|
Plant 12,345 (Plant Patent) |
US12345P | |
US PP12,3456 Pn (Plant Patent) |
USPP123456Pn | |
US yyyy/0012345 P1 (Plant Patent Application Publication) |
USyyyy012345 |
|
WO – PCT Publication and Application Numbers
WO (PCT) publication numbers can be imported using the following number format:
WOyyyy12345(6) international code (WO) + year (4 digits) + serial number (5-6 digits) |
WO (PCT) application numbers can be imported using the following number format:
WOyyyyXX12345 international code (WO) + year (4 digits) + country code (XX) + serial number (5 digits) |
WO (PCT) – Overview of Importable Number Formats
International Publication Numbers |
Importable Format |
Comments |
WO yy/12345 |
WOyy12345 |
|
WOyy/00001 |
WOyy00001 |
|
WO yy/123456 |
WOyy123456 |
|
WO yy/000123 |
WOyy000123 |
|
WO yyyy/012345 |
WOyyyy012345 |
|
WO yyyy/000001 |
WOyyyy000001 |
|
International Application Numbers |
Importable Format |
Comments |
PCT/JPyyyy/001234 |
WOyyyyJP01234 |
|
PCT/CNyyyy/012345 |
WOyyyyCN12345 |
|
PCT/USyyyy/012345 |
WOyyyyUS12345 |
|
PCT/JPyy/00012 |
WOyyyyJP00012 |
|
PCT/CNyy/00123 |
WOyyyyCN00123 |
|
PCT/USyy/12345 |
WOyyyyUS12345 |