Import Data

A step-by-step guide for entering or importing data into the Chart Studio Workspace.

Step 1

Option 1 - Enter the Data directly into the Grid

The first step to making any Chart Studio graph is adding data to the grid. You can type your data directly into the grid, or copy it from a spreadsheet and paste it in.

You can also type directly into the cells, or use your keyboard shortcuts to paste in clipboard content.

Enter data in grid

Step 2

Option 2 - Import a Data File

You can import .xls, .xlsx, or .csv files directly into Chart Studio. Head to Chart Studio Workspace and click on the 'Import' button next to your username in the top-right corner of the workspace.

Import button

The 'Import' modal will appear, where you can upload your local data-file saved in the above mentioned format under the 'Upload' tab. You can either click the 'Upload' button or simply drag and drop the file into the window within the modal.

Upload files

Step 3

Option 3 - Import Data from a URL

You can upload data by entering the URL of an online data set. Please note that Chart Studio supports only secured URLs (HTTPS) and accepted file formats are same as mentioned above: .xls, .xlsx, or .csv.

Enter data by URL

Step 4

Option 4 - Import Data via Falcon SQL Client

You can import data by connecting to your SQL database through the Falcon SQL client. To learn more about how to connect your databases to your chart via Falcon, check out this section.

Import from SQL

Step 5

Option 5 - Import Data from the Examples

You can also use the example data provided under the 'Examples' tab in the 'Import' modal. Choose any of these examples to get started!

Import from Examples

Step 6

Option 6 - Import Data from a URL using Chart Studio's External Endpoint

Additionally, you can upload data from a URL using Chart Studio's external endpoint. Entering https://plot.ly/external/?url=YOUR_URL in your browser will open your data in Chart Studio's workspace. This method for uploading and parsing your data doesn't impose the same SSL restrictions that you may encounter with the above import method. For example, open this link to load data from Chart Studio's dataset repo into Chart Studio's online workspace: https://plot.ly/external/?url=https://raw.githubusercontent.com/plotly/datasets/master/2011_us_ag_exports.csv.

Step 7

Update Data

When you edit the data in the grid, your plot will update automatically.

The folowing video illustrates a simple use case where the plot updates when a data point is typed directly into the grid.

Update data

Step 8

Work with Multiple Grids

You can also work with multiple grids with each grid containing data imported from any of the above mentioned sources. After adding all the necessary data required for the chart, click on the '+ Trace' button at the top right-hand side of the Chart Studio Workspace panel and then choose the 'Type' of trace you'd like to work with.

Add Trace

When you select the X and Y values from their dropdown, make sure to select them under their specific grid. In the image below, you'll see that we've added 'X' values from Grid 2 and 'Y' values from Grid 1.

Grid dropdown

In addition to adding your data from different grids to the trace, you can also associate them to the trace's style attributes such as marker size, marker color, colorscale, etc.

Style Attributes

Note that if you want to save your plot with all your grids, you must include data from each grid into a trace. If not, your saved plot will open with only the grids that are associated to it.

Don't forget to save your plot and name your file!

Save Plot