How to Import Files
When you import data into DataGraph, the program interprets your data files to identify column separators and headers and determine the data types for each column.
To import a file, click Data > Import File on the menu bar to select a file from the Finder. You can also Drag and Drop a file, as shown below.
- Copy and Paste
- Drag and Drop
- Importing from the Finder
- Right-clicking on CSV or Excel files in the Finder
See File Formats for a description of the file you can import.
File Formats: Some file formats, such as CSV, contain data in a tidy format and are easy to import. Other formats, such as spreadsheets, are often messy and require data manipulation to be in the proper format.
DataGraph has many built-in actions to help tidy your data, including:
You can also filter your data dynamically using Masks, so you don’t have to spend a lot of time rearranging and preparing data before you import.
When the default import settings are not quite right, use Import Special to create a custom data parser.
Learn More: See Data Types Explained.
Drag and Drop
Drag and drop is a quick way to import data from one or more selected files on the desktop or in the Finder. This method can be used with every file format that DataGraph understands.
Example – Data Table:
Try to drag and drop a file on the data table.
- Download the following file: Airmiles
- Drag and drop it onto the data table.
Example – Data Side Panel:
Drag and Drop onto the data side panel to import as a Column Group. The group name is set equal to the file name. Expand the group to see the columns listed.
- Use the same file as above
- Drag and Drop onto the data side panel
- Click the group to expand and see the column objects
Column Groups: DataGraph uses Column Groups to organize data. Groups are similar to sheets in a spreadsheet but have many advantages, including:
- Nest groups within groups,
- View multiple groups at once,
- Easily hide a group from view, and
- Click and drag to reorder multiple columns at once.
Select from Finder
To select a file using the Finder, click on the Data menu or click the Gear on the top left of the data table.

From there, you can access several import options, including:
- Import File (Shift-⌘-I )
- Import File Portion
- Import Excel Sheet
- Import Special (Option-⌘-I )
Import File
Select this option (or type Shift-⌘-I ) to open the Finder menu to select a file. The selected file will be imported in the same way as using drag and drop.
Exercise:
- Download the following Excel file: Temperature data
- Select Data > Import File OR click Gear at the top of the data table.
- Find the file in your download folder.
The three worksheets in the file are separated into groups where the group name is the name of the worksheet tab.

Import File Portion
Select this option to access a simple interface to select rows to import. Click and drag to select multiple rows. Use ⌘-Click to select individual rows.

Only the rows selected are imported.

Import Excel Sheet
Select this option to get a preview of an Excel file, and an interactive interface to click and drag a section to import.
NOTE: You do not need to use this option to import from excel. Excel files can be imported using drag and drop, just like any file format that DataGraph understands.

The selected cells are imported.

If a file has multiple sheets, they will be listed on the left side of the importer. You can only import from one sheet at a time.
NOTE: If you have multiple sheets, a quick option is to drag and drop on the column list. A group is created using the Excel file name. Each sheet becomes a nested group.

Import Special
The Import Special option lets you preview your data while specifying how the data should be imported.
This interface is itself a small program within DataGraph that has powerful functionality for creating custom data import methods or data parsers that can be saved and reused.
To learn more, see How to Create an Import Method.