• Show convenient version of this site
  • Deutsch
  • English
Contact
Newsletter
  • Products
    • ALS
      • Across Language Server
        • Translation Management
        • Terminology Management
        • Translation Memory
      • Editions
      • Interfaces
    • ATE
      • Across Translator Edition
      • Editions
      • Download
      • Across Account
    • Elanion
      • Overview
      • Login
  • Solutions
    • Customers
      • Enterprises
      • Language Service Providers
      • Translators
    • Industries
      • E-Commerce & Trade
      • Pharmaceuticals & medicine
      • IT & Software
    • Departments
      • Marketing & E-Commerce
      • Technical Documentation
      • Software User Interfaces
  • Services
    • Hosting
    • Training
    • Consulting
  • Partners
    • Language Service Providers
    • Universities
  • Company
    • Across Systems
    • News
    • Events
    • Career
    • Contact
  • Knowledge
    • Blog
    • Video Library
    • Case Studies
    • White Papers
    • Fact Sheets
    • File Formats
    • Expert Features
  • Support
    • Online Help
    • FAQ
    • Support Request
    • Updates
    • New Functions
Schedule Consultation
  • Online-Help
  • ALS
  • Terminology Management
  • crossTerm Import
  • Importing Terminology
  • The CSV Format
  • Import
  • Release Notes v7.0
    • Across v7 15960
    • Across v7 15954
    • Across v7 15934
    • Across v7 15921
    • Across v7 15918
    • Across v7 15911
  • Getting Started
    • Structure and Architecture
      • TMS Functionality
      • Across Support and Across Services
      • Toolbox
      • Modules
        • crossBoard
        • crossDesk
        • crossTerm
        • crossTank
      • Tasks/Roles
      • Using Across
        • Wizards
        • Module Icons
        • Keyboard Shortcuts
        • Context menus
        • Profiling mode
      • Customization
        • Across
        • Toolbars
      • Matches
      • Repetitions
    • Basic Decisions
      • Rich Translation Memory
      • Storing Multiple Translations
      • Permitting Multiple Translations
      • Segmentation
      • Splitting
    • Logging in
      • Online Client
      • Windows Authentication
    • crossBoard
      • Dashboard
        • Adding Dashlets
        • Customizing Dashlets
      • My Tasks
        • Confirming/Rejecting Tasks
        • Concurrently Opening Multiple Tasks
        • Closing Tasks
        • Finishing Tasks
    • Change username/password
    • Confirming and Opening Tasks
    • Internal Communication
      • Message Administration
    • Rights System: Default Settings
      • Projects
      • Documents
      • Target Languages
      • Paragraphs
      • Users
      • Cockpit
      • Groups
      • User Settings Templates
      • Languages
      • Fonts
      • Relations
      • crossTank
      • crossTerm
      • User Settings
      • System Settings
      • Tools
      • Workflows
      • LSCM
      • Windows Resources
  • System Management
    • General Information
    • Users
      • Context Menu
      • Creation with Across Login
      • Creation with Windows Authentication
      • Properties
    • Groups & User Crowds
      • Groups
        • Creation
      • Attribute-Specific Rights
      • User Crowds
        • Creation
    • Softkeys
      • Creation
      • Management
    • Reports for User and Group Information
    • User Settings Templates
      • Creation
    • Workflows
      • Standard
      • User-Defined
      • Assignment or Change
      • Configuration
        • Quality Management (QM v6.3)
    • Relations
      • Creation
    • Languages
      • Sublanguages
      • Right-to-Left Languages (RTL Languages)
    • Fonts
      • Missing Fonts
      • Assignment of Master to Trusted Server
    • User settings
      • The "General" Section
        • Alignment
        • General
        • Notification
        • crossSearch
          • Customization and Extension
        • Dialog Settings
        • E-Mail
        • Progress
        • Review
        • Project Wizard Options
        • Project Filters
        • Spell-Check
          • Adding a Hunspell Dictionary
        • Fonts
        • Languages
        • Preview
      • crossDesk Area
        • Auto-Propagate
        • crossTank
        • crossTerm
        • crossView
        • Contrast Formatting
        • Quality Management
        • Source/Context View
        • Target Editor
      • Customizing Shortcut Keys
    • System settings
      • Editing States
      • User Dictionary
      • crossGrid
        • TS Properties - General
        • TS Properties - Languages
        • TS Properties - Data Usage
        • TS Properties - Rights
          • crossTank
          • crossTerm
        • TS Properties - Contacts
        • MS Properties
      • crossGrid Packaging Templates
        • General
        • crossTank
        • crossTerm
      • crossTank
      • crossWAN Packaging Templates
        • General
        • crossTank
        • crossTerm
      • Subjects
      • Information
      • Machine Translation
        • Configuration
      • Project Settings Templates
        • General
        • crossTank
          • Storing Settings
          • Penalties
          • Pre-Translation
        • crossTerm
      • Quality Management v6.3
        • Configuring the crossTerm Check
        • Managing QM Lists (QM v6.3)
      • Quality Management v7.0
        • QM Check with Regular Expressions
      • Reporting
      • Segmentation
      • Language Settings
        • Date, Time, and Number Formats
          • Adding new format
          • Define Alphanumeric Dates
          • Sentence detection
          • Adding new abbreviations
          • Creating Sentence Rules
          • Editing Sentence Rules
          • Wildcard
      • Structure Attributes
      • System Attributes
        • User-Defined Creation
      • Search Center
      • Concordance Search Results
      • Stopwords
      • Term Extraction
      • Document Settings
      • Document Associations
      • Display Text
      • .NET Resources
      • Excel 2000-2003
      • Excel 2007-2016
      • IDML
      • MIF 7
      • MIF 8-2019
      • PDF
      • PowerPoint 2000-2003
      • PowerPoint 2007-2016
      • QuickSilver
      • Tagged HTML
        • The Element Properties Window (Tagged ML)
        • The Attributes Tab (Tagged ML)
        • The Formatting Tab (Tagged ML)
        • Tagged ML Formats – Configuration
      • Tagged SGML
      • Tagged XML
      • Tagged XML v2
        • Conditionally Mapping an XML Element to a Structure Attribute
        • Display Internal Elements Depending on the Attributes
      • Visual XML
      • Windows Resources
      • Word 2000-2003
        • Show/Hide Style Elements
      • Word 2007-2016
      • XLIFF
      • Regular expressions
        • Application Examples
        • RegEx QM Criteria for Software Localization
    • System attributes
      • crossTank Entries
  • Project Management
    • Projects
      • Project View
      • Project settings
      • Functions of the Module
      • Project Search
        • Search and Replace
      • Project creation
        • Execution
      • Adding attachements
      • Releasing Projects
      • Document and Project Updates
        • Execution
      • Project status
      • Exporting projects
      • Importing projects
      • Activating/Deactivating Projects
      • Duplicating Projects
      • Archiving Projects
      • Change workflow
      • Changing Workflows (Several Documents)
    • Documents
      • Adding a document
      • Adding a target language
      • Aligning Existing Translations
        • Execution
        • Manual corrections
        • Intermediate States
      • Document Formats and Programs
        • Supported Windows Document Formats
        • Supported macOS Document Formats
        • Details of Software Localization
      • Partitioning Documents
      • Locking and Hiding Text
      • Redoing Document Versions
      • Deleting a Document Version
      • Pre-translations
      • Machine Translation
        • Machine Pre-translation
        • Configuration of the Systems
      • Document Settings Templates
        • Creation
          • Configuring a DST for Word
          • Configuring a DST for XML
          • Configuring a DST for Conditional XML
        • DST for Converted Documents
        • Assigning DST
      • Checking out Documents
    • Reports
      • Reports
      • Price Calculation
        • Example 1
        • Example 2
        • Example 3
        • Example 4
      • Word Count in Across
      • Report Types
      • Creation
        • Creating an Edit Distance Report
        • Creating a Comments Overview Report
      • Update Report
      • Customization
    • Tasks
      • Priorities and Due Dates
      • Reports
      • View
      • Assignment
        • Assignment to Crowds
      • Non-Matching Users
      • Unassignment
    • Quality management
      • Quality Management View
      • QM Criteria
        • QM Criteria (QM v7.0)
        • QM Templates (v7.0)
        • General (QM v6.3)
        • SGML, XML, and XLIFF (QM v6.3)
        • Windows Resources (QM v6.3)
        • .NET Resources (QM v6.3)
        • Display Text (QM v6.3)
      • Manage QM Criteria
      • Integrating QM criteria
      • Expanding the QM Check (QM v7.0)
      • Deactivating QM Criteria
      • Connecting External QM Tools
    • Formats
      • View
      • Creating Templates
      • Editing Templates
    • The Project Archive
      • Restoring
    • crossGrid
      • View
      • Reporting
      • Rights Control
      • Transmission History
      • Availability of Entries
      • Package delegation
        • Assembling Data
        • Packaging Templates
          • Provide Entries
        • Creation and Delegation
          • Delegation
        • Retrieval
          • User-Defined Workflows
        • Delivery
        • Importing Data (v6.3)
    • Project Management Cockpit
      • Context Menus
      • Customization
      • Functions
      • Queries
    • The Filter Editor
    • crossAnalytics
    • Linguistic Supply Chain Management (LSCM)
      • Basic Information
      • Opening LSCM
      • User Interface
      • Generating Price Lists
      • Mapping Price Lists
      • Creating a Report
      • Generating Price Comparisons
    • crossWAN Project Management
      • Data Preparation and Export
      • Data Processing
      • Task Export
      • Task Import
      • Importing Data (v6.3)
    • Partitioning
    • Relay Translations
      • Assignment
      • Execution
    • Document preparation
    • Term Extraction and Term Translation
      • Term Extraction
        • Icons and Keyboard Shortcuts
      • Term Translation
        • Icons and Keyboard Shortcuts
    • External Editing of Documents
      • Execution
    • The EN 15038 Standard Workflow
    • The ISO 17100 Standard Workflow
    • crossConnect for External Editing
      • Activation
    • Finishing pre-translated tasks automatically
  • Task Processing
    • Working in crossDesk
      • Using crossWeb
      • Text Display
      • Editable Fields vs. Placeables
      • Using Tags
      • Translating Documents
    • Paragraph States
      • Change
    • Empty Paragraphs
    • Modes
      • Correction Mode
    • Customizing crossDesk
    • Tasks in Across
      • Confirming/Rejecting Tasks
      • Customizing the Module
    • Comments
    • Bookmarks
    • Paragraph Numbering
    • Sorting Paragraphs
    • Context View/Source View
      • Date, Time, and Number Formats
      • Number Control
      • Joining Paragraphs
    • crossTerm Window in crossDesk
    • crossView
      • Modes
      • Change History
        • Restoring Old Paragraph Versions
    • Fuzzy search
    • Concordance search
    • crossSearch
    • Spell-check and User Dictionary
    • Pre-translations
    • Store Translations Wizard
    • The Target Editor
      • Automatically Inserting crossTank Entries
      • Automatically Inserting Repetitions
      • Adding Translations to crossTank
      • Creating a Term During Translation
      • Auto-completion
      • Fields
      • Objects and Images
      • Special Characters and Symbols
      • Sentence Detection and Segments
        • Editing Segments
    • Preview
    • QM Check in crossDesk
      • Usage (QM v7.0)
      • Mandatory Criteria
      • QM Batch Mode
    • Search and Replace
    • Correction
      • Correcting Translations
    • Reviews
    • Redelegation to the Translator
    • Quick Translate
      • Translating with Quick Translate
      • Finishing Quick Translate Tasks
    • Local Data in the Offline Client
  • crossWAN
    • About crossWAN
      • crossWAN Online
      • crossWAN Load
      • crossWAN classic
      • crossWeb for Offline Users
    • Retrieving Tasks
    • Delivering Tasks
  • TM Management
    • The crossTank Manager
      • Rich Translation Memory
        • Exchange Formats
      • Context matches
      • Structure Matches
      • Context-Independent Translations
      • Usage History
      • Auto-Changes and Auto-Adjustments
    • Adding Translations
    • Editing Translations
    • Changing the Status of Translations
    • Merging Translations
    • Deleting Translations
    • Protecting Translations
      • Translation Units
      • Paragraphs in Connection with Pre-Translations
      • Protected Paragraphs in Across Reports
      • Rights Control
    • Searching for Translations
      • Search and Replace
    • Generating a crossTank Summary
    • crossTank Import
      • Mapping Import Data
      • Import Templates
      • Import Statistics
      • TMX Import and Server Context
      • Importing translation memories
        • TM Import Functions
    • crossTank Export
      • Exporting translation memories
    • crossTank Maintenance
      • Changing Attributes
      • Deleting Entries
      • Removing Redundant Translations
      • Changing the Attributes of Multiple Entries
      • Removal of Duplicates
  • Terminology Management
    • Concept-Oriented Terminology System
    • Definitions
      • What is an entry?
    • The crossTerm Manager
    • crossTerm settings
      • crossTerm Instances
        • Management
      • Entries
        • Indexes
        • Text fields
          • Standard text fields
        • Picklists
          • Standard picklists
        • System attributes
        • Attachments
        • Groups
          • Creation
      • Terms
      • Template Management
        • Entry templates
        • Term templates
      • Tooltip Administration
        • Data Categories
        • crossTerm Instances
        • Administrative Index Information
        • Definitions
    • crossTerm Manager User Interface
      • Modes & Layouts
        • User-Defined Layouts
      • Search Area and Hit List Display
      • Concept-Oriented Information
      • Source-Language Terms
      • Target-Language Terms
      • Additional Information
    • Searching for Entries/Terms
      • Search Types
        • Term search
        • Fuzzy search
        • Entry search
        • Keyword search in definitions
        • Concordance search
        • Index search
      • Display of Search Suggestions
      • Quick Filters
      • Filters and Filter Sets
        • Creating User-Defined Filters
        • Creating Filter Sets
        • Public and Non-Public Filters and Filter Sets
        • Search Criteria
        • Logical Operators and Groupings
      • Stemming
        • Language Administration
    • Entry and term elements
      • Add entry and term
        • Superscript & Subscript
      • Homographs
      • Quick Add Terms
      • Indexes
        • Index usage
        • Standalone Entries
          • Creation
        • Index Duplicates
        • Index set up
        • Creating bibliographic entries
        • Creating cross-references to bibliographic entries
      • Cross-References
        • Index Cross-References
        • Entry IDs
        • Check
      • Hyperlinks
    • Editing Entries/Terms
    • Delete Entries/Term(s)
    • Merging Entries
    • Duplicating Entries
    • Manual correction
    • crossTerm Reports
      • Terminology Reports
      • Entry Reports
      • Summaries
        • Generating Entry Summaries
        • Generating Term Summaries
    • crossTerm Import
      • Mapping
      • GUID mapping
      • Templates
      • Log file
        • Creation
      • Exclusion Files
      • Existing Terminology
      • Importing Terminology
        • The TBX format
          • Import
        • The CSV Format
          • Import
          • Preparations
          • Mapping
        • Star Martif import
        • The MultiTerm format
          • Import
    • crossTerm Export
      • Templates
      • Exporting Terminology
    • crossTerm Data Maintenance
      • Execution
    • crossTerm Web
      • Homographs
      • Sending Comments
      • Logging of Unsuccessful Searches
      • Opening crossTerm Web
        • Anonymous access
        • Login via Windows Authentication
      • Working with crossTerm Web
        • Creating an entry
        • Edit entry
        • Delete entry
        • Search
          • Concordance search
          • Search for entry
          • Search for terms
          • Keyword search in definitions
          • Auto-completion
        • Settings
      • crossTerm Web Rights
        • Editing
        • Interaction of Rights
      • crossTerm Web Suggestion Module
        • Controlling the Access
        • Suggesting terms
        • Further processing of term suggestions
      • crossTerm Web Skins
    • crossMining
    • crossSearch
  • Browser-based Work
    • Working Browser-based with crossWeb
      • Browser Settings
      • Login
      • Customization
      • User Settings
        • General
        • crossDesk Web
      • My Tasks
      • Terminology
      • crossView
    • Project Management
      • Projects
      • Tasks
      • Creating Projects
      • Document Check-out
    • Translation
      • crossDesk Web
        • Customization
    • Review
      • Review Mode
      • Standard Mode
      • Reviewing Translations
    • External Document Editing
  • Editing of Special Formats
    • HTML Documents
      • Tagged HTML
    • XML Documents
      • Visual XML vs. Tagged XML
      • Tagged XML v2
      • Consideration of DTDs and XSDs
      • Encoding
      • XHTML Documents
    • SGML Documents
    • FrameMaker Documents
      • MIF Documents
      • Translating MIF Documents
        • MIF Elements
        • Creating Previews
      • Font Mapping
        • Font mapping
    • Word Documents
      • Editable Fields vs. Placeables
      • Linked Objects
      • Bookmarks
      • Change tracking (DOCX)
        • Usage
      • Hidden Text (DOCX)
      • Document Properties (DOCX)
    • TXT Documents
      • Encoding
    • Excel Documents
      • Processing
      • Formulas, Numbers, and Dates
    • PowerPoint documents
    • InDesign and InCopy Documents
      • Conversion
      • Translations of special formats
      • Kerning and Tracking
      • Tagged XML or Visual XML
      • Set Visual XML
      • Previews
    • QuickSilver documents
      • Translation
      • Icons
      • Centrally Defined Components
      • Sanity Check of Prefix Components
    • PO Documents
      • Processing
      • Extraction of Translation Units
    • MC Documents
    • XLIFF Documents
      • Bilingual XLIFF Files
      • Cloneable Elements
      • Paired Elements
      • QM Check (QM v6.3)
    • crossTransform
      • Extension
      • Setup
      • Adding Formats
    • Software Localization
      • Quality Management (QM v6.3)
      • Customizing Shortcut Keys
      • Localizing Dialog Boxes
        • Customizing Dialog Elements and Buttons
      • Localizing Menus
      • Localizing String Tables
        • Displaying String IDs
    • Localization of mobile apps
    • Localizing Display Texts
      • The Across-Specific DTXML Format
      • Localizing Display Texts in crossDesk Web
  • Menus, Icons, and Keyboard Shortcuts
    • Reference: Icons
      • Across Client
      • crossDesk
        • crossView
          • Software Localization
          • MIF Documents
          • QuickSilver Documents
        • Context View/Source View
        • Target Editor
        • Search Center
        • crossTerm
        • Status Bar
      • crossTank Manager
      • crossTerm Manager
      • crossWeb
        • Paragraph States
        • crossView
        • Context View/Source View
        • Target Editor
        • Search Center
        • crossTerm
      • Alignment
      • Term Extraction & Translation
    • Reference: Keyboard Shortcuts
      • General
      • crossDesk
      • crossTank
      • crossTerm
      • crossDesk Web
      • Finishing Tasks
      • Source Languages as Reference
    • Reference: Menus
      • File
      • View
      • Tools
      • Help
      • crossTank Manager
      • crossTerm Manager
    • Reference: Context Menus
      • Projects and Tasks
      • Users
      • crossDesk
      • crossTerm Manager
      • crossWeb

CSV import

  1. Proceed as follows:
  2. Open the crossTerm Manager and click icn_wiz_cTerm-import-wizard.
  3. Once the wizard has started, click Next.
  4. Select CSV as import format.
    wiz_cTerm-import-wizard_p02_csv_formatauswahl
  5. Select an import template if required and if one already exists.
    Attention

    Use an import template only for another import of the same data, e.g. during the creation of the import template or for an import of other data with the same entry structures and data categories.

  6. Click Next.
  7. Select the file you want to import.
  8. Select the mode with which you want to import the terminology file.
    Tip

    In the mode without user interaction, all ambiguous terminology entries that would require interaction (e.g., when importing homographs) are saved to a separate TBX file. These terminology entries can later be imported en bloc.

  9. Activate the option Create import log and click Next.
    Tip

    The log file will be stored locally in the log directory of the respective Windows user. It can also be saved locally by means of a button in the final step of the wizard.

    Apart from the selected import settings, the log file contains detailed information on the imported terminology data and on their processing (e.g. information on the successful import of entries and terms and, if not imported, information on why the import did not take place).

  10. Click Next.
    wiz_cTerm-import-wizard_p04_csv_trennzeichen-auswahl
  11. Select the character to be used as data delimiter.
  12. If the CSV file you want to import contains entry and/or term GUIDs, you can activate GUID mapping option.
  13. Click Next.
  14. Select the instance that the terminology is to be imported to and click Next.
    wiz_cTerm-import-wizard_p06c_csv_erste-zeile-enthaelt-keine-spaltenueberschriften

    If the first line of your CSV file contains the column headers of the associated table, Across sorts them out and inserts them in the left side of the window under CSV fields.

    wiz_cTerm-import-wizard_p06a_csv_erste-zeile-enthaelt-spaltenueberschriften
  15. If the first row of your CSV file does not contain column headings and is filled with terminology entries, disable the option The first line is a CSV header.

    The columns along with the contents of the first line will then appear in a list on the left-hand side of the window.

  16. Assign the corresponding information types.
    Attention

    Column headings that are not mapped to any Across category will not be imported.

  17. Click Next.

    The next step is the mapping of the languages. In this process, the languages and sublanguages of the terms from the import file need to be mapped to those in Across.

  18. Check the specified languages and sublanguages and change them if necessary.
    Attention

    Languages from the import file that were not mapped to any Across language will not be imported.

  19. Click Next.
    wiz_cTerm-import-wizard_p08_csv_datenkategorie-mapping
  20. Map the data categories as required.
    Attention

    Data categories that are not mapped to any Across data category will not be imported.

  21. If a data category is missing, click crossTerm Settings and create it.
  22. Click Next.

    If you have assigned picklists in the course of the previous mapping, you need to map the individual values from the columns of the CSV file to the Across values.

  23. Assign the corresponding information types.
  24. If a value is missing, click crossTerm Settings and create it.
  25. Click Next.

    The dependencies between individual columns of the CSV file are defined. The columns of the CSV file that do not contain any terms, but other terminology information (such as attributes) are mapped to the respective terms.

    Example: The CSV file contains a column with German terms, a column with English terms, and a column with gender details for the German terms. In the following step, the column with the gender information is mapped to the column with the German terms, so that the gender details are added to the respective German terms during the import.

    Attention

    Columns with other terminology information that was not mapped to any column with terms will not be imported.

  26. Select a column of the CSV file that contains terms and click the icn_mehr_drei-punkte icon in the respective row.
    wiz_cTerm-import-wizard_p10a_csv_termdatenkategorien_dialog
  27. From the list on the left-hand side, select the columns with other terminology information that are to be mapped to the selected column containing terms.
  28. Then click > in order to transfer the columns to the right-hand area of the dialog, thereby mapping the columns to the selected column containing terms.
  29. Repeat this for all desired information.
  30. Click OK.
  31. Continue until you have mapped the columns containing other terminology information and, if applicable, the term type, for all columns containing terms.
  32. Click Next.
  33. Define how you would like to proceed if entries and/or terms that should be imported already exist in crossTerm.
    Tip

    The dialog window will only be displayed if the file to be imported contains GUIDs (e.g. for a reimport) and if GUID mapping has been activated.

  34. Click Next.
  35. Determine whether entries or terms that cannot be imported for various reasons are to be written to an exclusion file.
  36. Click Next.
    wiz_cTerm-import-wizard_p14_csv_importparameter
  37. If required, add further attributes to the termbase you would like to import.
    Attention

    These attributes are used if the relevant attributes have not yet been assigned in the mapping.

  38. If required, enable the Check for already existing terms and show manual correction dialog option.

    In the case of duplicate terms, this will cause you to be asked whether you want to merge the information from the two terms. After activating this option, you can also determine that the manual correction is to take place only if both terms are associated with the same relation or the same subject.

    Tip

    This option is available if the import file does not contain any GUIDs.

  39. If required, specify that the terms to be imported are set to Released.
  40. If required, save your settings in an import template (Save import template).
  41. Click Import to start the import.

    The import process will start.

    If you activated the option Check for existing terms and show manual correction dialog and a term to be imported already exists in crossTerm, a dialog window will appear.

    cTeM_bereits-existierender-eintrag
  42. Determine how the term to be imported is to be processed.
  43. Confirm by clicking OK.
  44. Click Finish to complete the import.
  45. The terminology contained in the import file has now been imported to crossTerm and is available for your translation work.
Additional Information
Importing existing translations
Manual correction
Register for our Newsletter now

Our newsletter provides you with exclusive news about the Across Language Server, often even before the official announcement. The newsletter also provides you with early information on events, webinars, and training sessions.

  • Legal Notice
  • GTC
  • Privacy Statement
  • Cookies
  • info@across.net