How to export data into a CSV file | Targetprocess - Visual management software

How to export data into a CSV file

Targetprocess provides several easy ways to export data to a delimited format suitable for import into such tools as Microsoft Excel.

Export Views

Export option can be found under Actions menu on any View. Just click the Export button to download a .CSV file. No matter how many types of cards are shown on the View - all the cards from the View will be exported to the .CSV file.

Export Views. Image 1

Export Views

Attachments and images can not be exported from Targetprocess. You can only save them manually to your local drive using "Save" button for every single file / image or request whole attachments storage from Support Team. Comments can be exported by REST API only.

If you have your board filtered or focused on a particular set of rows and columns and then export it, you will see the same set of cards in the CSV file as the board shows.

It is not possible to customize columns in the exported file.

Hierarchical lanes in list views are not exported at the moment. Only entities selected as Cards in view setup are exported.

It is also not possible to export comments and requesters.

If you need customized export, please build and export a Tabular Report instead.

Count Limit

By default, the number of exported entities is limited to 5000.

For on-premise (on-site) customers this limit can be changed in configuration file on the hosting server. Open the file:


Modify the following line:

<add key="CsvSlice.TakeLimit" value="1000" />

Known workaround for this issue is to use filters and export data in small batches up to 1000 items each.

Export Tabular Reports

Export To Excel functionality is available from your Tabular Reports.

Open Reports → Tabular Reports page. Run an existing report or create a new one. Then please click the Export To Excel button.

Export Tabular Reports

If you use Inner Lists within the Tabular Report (such as User Stories → Tasks, Bugs; Features → User Stories; Assignable → Assignments, Times, Comments, Requests → Requesters), the data from the inner lists will also be exported.

Tabular reports cannot export assigned users into a column like View Export does. Inner Lists is the only supported form.

Calculated custom fields cannot be displayed and exported within Tabular Reports.

Export Visual Reports

A Visual Report can be exported using an icon in top right corner of a report. It is possible to export a report into CSV and JSON formats. Also screenshot of a report can be saved as PNG file and printed.


For example, we have a report that shows how much effort (7.5 man-hour work days) was completed by each team. Each color represents a different project:

When we export this report in .png format, we have a screenshot of the report:

Export Visual Reports

Exporting in .csv format displays Project names, Team Names, and the sum of effort divided by 7.5 as the report specifies:

How to export data into a CSV file. Image 6

When exporting in JSON we generate a file written  in the format below:

How to export data into a CSV file. Image 7

Export Custom Graphical Reports (Obsolete)

It is possible to export Custom Graphical Reports in various formats. To export your reports or print them, the 'export' UI element can be found above the report on the right:

Export Custom Graphical Reports (Obsolete)

Export Descriptions and Rich Text Custom Fields

Content of Descriptions and Rich Text Custom Fields is exported in form of plain text. The markup, styling of the font and complex elements such as tables are not exported. The following workarounds can be used for export of text fields with markup preserved:

  • REST API queries. More information can be found here: REST API, Integration with Excel
  • Print View feature which generates HTML or PDF copy of a single entity. The feature is accessible within Actions > Print View menu item in detailed view of an entity.

Delimiter (separator) settings for CSV files

Four symbols are supported as delimiters for CSV files produced by Targetprocess:

  • , (comma)
  • ; (semicolon)
  • |
  • Tab

Comma is selected in the account settings by default.

Troubleshooting issues with delimiter

Sometimes it may happen that your Excel editor is not able to parse CSV file properly. It may happen when delimiter used in files build by Targetprocess does not matches the one expected by Excel. Here is how problematic the imported file may look like in Excel:

Troubleshooting issues with delimiter

It is possible to change delimiter (separator) symbol settings in two places so that they start to match each other.

Check and change delimiter settings in Targetprocess

In Targetprocess, you'll need to login as Administrator. Then open Settings → General Settings → CSV Export delimiter.

Check and change delimiter settings in Targetprocess

When settings are saved, please re-export Targetprocess data to CSV file once again.

Check and change delimiter settings in Windows Excel

Default delimiter (separator) for Windows Excel is configured in local settings of your machine. In Windows, press Run → Control Panel → Region and Language → Additional Settings... → List separator.

Check and change delimiter settings in Windows Excel

You should have same symbol set in your system settings and in Targetprocess.

When delimiters do not match, we recommend to change Targetprocess settings rather than the ones on your local machine.

Here is how the same CSV file is opened by Excel editor when delimiter (separator) settings match:

How to export data into a CSV file. Image 12

Export REST API queries

REST API allows you to extract data from Targetprocess account in the XML and JSON formats. We created quick guides that describe how to fetch Targetprocess data to commonly used spreadsheet editors:

Still have a question?

We're here to help! Just contact our friendly support team

Email us
The more details you can give us the better
Live chat
Prefer instant messaging? Try our live chat
Service Desk
Add tickets, comments and track status in our Helpdesk
Slack Community
Shape the future direction of Targetprocess

Find out more about our APIs, Plugins, Mashups and custom extensions. Join our community of passionate users and even discuss directly with our developers.

Start your free trial

Enter your email
By clicking "Continue", you acknowledge and agree that we will process your personal data in accordance with our Service Privacy Policy and Terms of Service.

We’ve sent you a confirmation e-mail — please, go check it.

Or get a live
product demo