Supported files

Supported file types

 

The following file types are supported by the latest version of Omniscope for import and/or export of cell data.

Also see:  Supported databases (includes OLAP)   Supported feeds 

 

Extension Description and notes Capability 
IOK

Omniscope file containing data, tabs, views, settings, formulae, etc.  

Can be considered a "project file" or a "report".  Unless secured otherwise, can be opened and explored in the free Viewer.

 

Open, save 
IOM

As per IOK, but cannot be opened in the free Viewer.  

Requires a licensed edition of Omniscope Desktop or Server to open. 

 

Open, save  
CSV, TSV, etc.

Delimited text file, such as comma, semicolon or tab separated.  

By default, CSV files are imported following the same rules regarding separators, delimiters and special character escaping as Excel.  

Any text file containing delimited data, regardless of filename extension, can be configured for import.

 

Import, export 
TXT, etc. 

Fixed-width text file, with columns of data padded with spaces.  

Any text file containing fixed-width data, regardless of filename extension, can be configured for import. 

 

Import, export 
XML, etc.

XML text file, with data in the Visokio XML data schema.  

XML data in other schemas can be converted into the Visokio schema using an appropriate XSL transformation file, which Omniscope can be configured to apply for you, allowing other schemas effectively to be imported directly.  XSL translation is only supported for importing.  When exporting, only the Visokio XML data schema is supported.

Any text file containing XML data in the correct schema, regardless of filename extension, can be configured for import.  

 

Import, export 
XLS, XLSX, XLSM, XLSB

Microsoft Excel workbook containing multiple worksheets (supporting Excel versions 97 and higher).

Omniscope supports importing a single worksheet, or multiple worksheets appended together.  Only the displayed values are imported; styles and formulae are not imported.

 

Import, export 
MDB, ACCDB 

Microsoft Access database file containing multiple tables.  

Omniscope supports importing either single tables or multiple tables using either an SQL join or by merging multiple Access sources in Omniscope.  

In Omniscope 2.6, MDB/ACCDB files require Microsoft Access to be installed (version 2007 or greater for ACCDB files), and require Omniscope to be running under the same architecture as Microsoft Access (so if Omniscope is 32-bit, Access must be 32-bit; if Omniscope is 64-bit, Access must be 64-bit).  

In Omniscope 2.7, MDB and ACCDB files can be imported without any requirement to have Microsoft Access installed, so is available on 32-bit and 64-bit Windows, and Mac. 

Omniscope treats MDB and ACCDB files as database connections, allowing arbitrary SQL on import, and exporting to a single table using insert/update.

Other supported databases

 

Import, export (via SQL SELECT, INSERT/UPDATE) 
PST, OST 

Microsoft Outlook data file ("Personal Storage Table" / "Off-line Storage Table" / Personal Folder File) containing emails, notes, calendar entries, contacts, etc.

 

Import 
QPW 

Quattro Pro spreadsheet 

 

Import, export
LOG 

Web Access log containing a web server's HTTP request access log data, in either the common or extended log formats.

 

Import