Book a Demo

Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

Prev Next

CSV Data

Although your model contains a great deal of information on both project design and project management, you might want to check or present the status of some external spreadsheet data for comparison or for review before importing it into your model. A major benefit of the Chart feature is providing the facility to quickly paste in and display, in the appropriate Chart format, the contents of an external CSV file.

Before you start, copy the content of the CSV file to the clipboard.


Select a Chart element on a diagram or in the Browser window, then use any of the methods outlined here to open the Chart element's 'Properties' dialog.

On the Chart element's 'Properties' dialog, click on the 'Source' tab, then on the 'CSV' child tab.


Design > Element > Editors > Properties Dialog > Source > CSV

Context Menu

Right-click on element | Properties | Source| CSV

Keyboard Shortcuts

Alt+Enter | Source| CSV


Double-click on element | Source| CSV

Review External CSV Data



See also


Right-click on the panel and select the 'Paste' option to paste the contents of the CSV file.

If necessary, edit the data so that the first row defines the series name, in the format:


Edit the first column to represent the series object (the objects listed along the x-axis of the Chart). You need perform only very basic editing on the text.


Click on this button to process the data, close the dialog and generate the Chart.


Click on this button to abort the changes and close the dialog.


Using simple CSV input such as this, for two chart elements Fruit Sales (tonnes) and Fruit Sales (No Series), two bar charts were created.




A series chart used to convey a series.

The CSV data for Fruit Sales (tonnes) provides a label for the series, essentially the aspect being compared (the sales for each month). The data for Fruit Sales (No series) omitted the first line of information, so the chart defaults to an unnamed series set.

Learn more