Skip to content

Full-Service Firms

TOTAL PRACTICE SOLUTIONS

Litigation Services

Concordance is flexible and works the way we want it to. It is very powerful.

Steven Loble
Collyer Bristow LLP
 

Email This Page

 * Required fields

Concordance®

FAQs: Import/Export

 
I have data in MS Excel that I want to convert over to Concordance, what is the procedure to get the data into Concordance?
Typically, each "row" in the Excel file is a different document. Also, each "column" of data in Excel is representative of a different field of data in a Concordance document. Choosing the correct delimiters is important in loading the data into the proper fields in Concordance. Excel offers two of the more common delimited formats, Tab and Comma delimited. These are also presets available in the Concordance Import/Export Wizards.

We have a reoccurring problem with font/format and exporting from Concordance. Many times when we export from Concordance, font coding instructions (example: {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;}) are exported too.
The font coding that you are seeing is the Rich Text Font ("RTF") embedded coding that Concordance stores from the data inputted. You can easily disable the RTF coding by de-selecting the "Export Rich Text" option in the Export Wizard/Export Dialog Box. The option appears in the "Field" select Window of the Export Wizard. For your reference, you can disable RTF for any field in "Edit| Validation". Check the "Data Validation" criteria and look for "Disable Rich Text".

How can I send another user my data from Concordance? Do they have to have Concordance to view the data? Conversely, how do I view data in Concordance that was sent to me by another user?
Data can easily be imported and exported in Concordance using the Import and Export Wizards available under "Documents | Import/Export | Delimited Text". Data from a Concordance database can be exported into ASCII Delimited files (using an array of delimiters including Comma or Tab delimiters), which can then be opened in virtually any other program. ASCII is a basic format that is accessible by all standard applications. Similarly, once data is saved as an ASCII text file, it can be imported easily into a Concordance database structure.

How can we help your firm? For more information about our solutions for law firms:

For more information

To obtain product pricing and licensing information contact a Discovery Services Specialist today.

For technical support contact our Technical Support team at (866) 495-2397.

Call a Discovery Services Specialist at (800) 421-TEXT
or email us now

For more information

To obtain product pricing and licensing information contact a Discovery Services Specialist today.

For technical support contact our Technical Support team at (866) 495-2397.

Call a Discovery Services Specialist at (800) 421-TEXT
or email us now

Special Offer!

Special Offer

Recently published, LexisNexis offers two comprehensive, workflow-oriented training workbooks—Using Concordance and Administrating Concordance.  Now you can teach others how to use Concordance with our official LexisNexis curriculum, or use them to support your own learning.  Order them here!

Want a preview before you buy? Take a look inside our Using Concordance workbook.

Download a free, 30-day trial of Concordance 2007