--- title: Using delimited textfiles description: Using delimited textfiles --- [Skip to content](https://help.intuitivebusinessintelligence.com/using-delimited-textfiles#main-content) English Show submenu for translations ![Intuitive logo RGB-1.png\]](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20RGB-1.png?height=40&name=Intuitive%20logo%20RGB-1.png) Open main navigation Close main navigation - English Show submenu for translations - [Go to weareintuitive.com](https://weareintuitive.com/) [Go to weareintuitive.com](https://weareintuitive.com/) Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Help Center](https://help.intuitivebusinessintelligence.com/?hsLang=en) 2. [Intuitive Dashboards Core Software](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en) 3. [Connections](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#connections) # Using delimited textfiles Delimited textfiles are commonly written and read by Windows and Unix systems – they consist of data arranged into columns separated by a character such as comma (,), pipe (|) or tab. A delimited textfile of suitable format for Intuitive Dashboards might look like this:    1,DR MARKUS & PARTNERS (C81649),Derbyshire County PCT,East Midlands, SHA,1,3,0,0,0,0,0,0,0,1,3,0,0,451,236,0.52**CRLF** 2,THE DENSHAM SURGERY,North Tees PCT,North East, SHA,19,15,0,0,1,5,3,7,5,1,5,5,2,624,333,0.53**CRLF** 3,QUEENS PARK MEDICAL CENTRE,North Tees PCT,North East, SHA,46,93,0,1,0,11,19,22,13,17,31,18,7,669,343,0.51**CRLF** 4,THE GUPTA/ GALLAGHER PRACTICE,Hartlepool PCT,North East, SHA,5,5,0,1,1,2,0,2,1,1,2,0,0,693,261,0.38**CRLF** 5,WOODLANDS ROAD SURGERY,Middlesbrough PCT,North East, SHA,10,12,0,0,20,0,3,3,3,1,6,6,0,653,321,0.49**CRLF**    Bear in mind that files written by Windows and Unix systems frequently have different end of line terminator characters shown here as **CRLF**. For example files written from an Oracle database on Linux may need to have characters changed using a utility such as sed. In this case refer to the following article:[http://en.wikipedia.org/wiki/Newline](http://en.wikipedia.org/wiki/Newline)    Each delimited text file must be named **yourfilename.txt** and be accompanied by a format file called **yourfilename.format.xml**. For example the format for the above file looks like this:    \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ - [Intuitive Dashboards Core Software](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#main-content) - [Getting Started](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#getting-started) - [Viewing Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#viewing-dashboards) - [Interacting with dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#interacting-with-dashboards) - [Filters](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#filters) - [Connections](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#connections) - [Datafeeds](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datafeeds) - [Datasets](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datasets) - [Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#components) - [Creating Dashboards and Components - Overview](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-dashboards-and-components-overview) - [Creating Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-components) - [Creating a Dashboard](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-a-dashboard) - [Administering the System](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-the-system) - [Administering Users](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-users) - [Administering Groups](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-groups) - [Security Filters - V5.2 and earlier](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-2-and-earlier) - [Security Filters - V5.3 Onward](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-3-onward) - [Embedding Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#embedding-dashboards) - [Configuration File](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#configuration-file) - [Installation & Configuration Guide](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#installation-configuration-guide) - [Version History](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#version-history) - [Intuitive for PaperCut V2](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#main-content) - [Installing Intuitive for PaperCut](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#installing-intuitive-for-papercut) - [Viewing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#viewing-papercut-dashboards) - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#editing-papercut-dashboards) - [Intuitive for PaperCut Demonstration Videos](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-demonstration-videos) - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-faqs) - [Intuitive for PaperCut MF V3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#main-content) - [Installing Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#installing-intuitive-for-papercut-version-3) - [Viewing the dashboards - Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-version-3) - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#editing-papercut-dashboards) - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#intuitive-for-papercut-faqs) - [Intuitive for SAFEQ](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#main-content) - [General Help](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#general-help) - [Software Installation](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#software-installation) - [Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#solution-expertise) - [Intuitive For Managed Print Services (MPS)](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#main-content) - [Intuitive for MPS - Overview](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-overview) - [Intuitive for MPS - Installation Steps](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-installation-steps) - [Intuitive for MPS - Import File Layouts](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-import-file-layouts) - [Intuitive For MPS - Loading the Data Warehouse](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-loading-the-data-warehouse) - [Intuitive Cloud Services](https://help.intuitivebusinessintelligence.com/intuitive-cloud-services?hsLang=en) - [Intuitive for PaperCut Hive V1](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#main-content) - [Viewing the dashboards - Intuitive for PaperCut Hive](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-hive) - [Intuitive for SAFEQ Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#main-content) - [Intuitive Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-solution-expertise) - [Intuitive Software Provisioning](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-software-provisioning) - [Intuitive for Docuware](https://help.intuitivebusinessintelligence.com/intuitive-for-docuware?hsLang=en) - [Intuitive for Print Management](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#main-content) - [Solution Knowledge](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#solution-knowledge) - [Technical Information](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#technical-information) - [Intuitive for e-BRIDGE Global Print](https://help.intuitivebusinessintelligence.com/intuitive-for-e-bridge-global-print?hsLang=en) - [Intuitive for e-FOLLOW Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-e-follow-cloud?hsLang=en) - [FAQ](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#main-content) - [Connections](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#connections) - [General Enquiries](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#general-enquiries) - [Datafeeds](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datafeeds) - [Datasets](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datasets) - [System Compatability](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#system-compatability) - [Software Installation](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#software-installation) [![Chill listening crop-3](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20BLACK.png?width=102&height=24&name=Intuitive%20logo%20BLACK.png "Chill listening crop-3")](https://help.intuitivebusinessintelligence.com?hsLang=en) weareintuitive.com Help Center Copyright © 2026, Intuitive Business Intelligence Limited