Show Sidebar Hide Sidebar

How to Add Data in Plotly 2.0

A step-by-step guide to entering or importing data.

Step 1

Option 1 - Enter Your Data in the Grid

The first step to making any Plotly 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 Your Data File

You can import .xls, .xlsx, or .csv files directly into Plotly. Upload a file using the IMPORT DATA tab.

Import data second shot

You have the option to drag and drop your file, or select “click to upload”.

Upload files

Step 3

Option 3 - Import Data from a URL

You can also upload data by entering the URL of an online data set. Please note we only support cdv and excel files at this time.

Enter data by URL

Step 4

Option 4 - Import Data from a URL Using Plotly's External Endpoint

You can also upload data from a URL using Plotly's external endpoint. Entering https://plot.ly/external/?url=YOUR_URL in your browser will open your data in Plotly'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 Plotly's dataset repo into Plotly's online workspace: https://plot.ly/external/?url=https://raw.githubusercontent.com/plotly/datasets/master/2011_us_ag_exports.csv.

Step 5

Option 5 - Import Using our Samples

Additionally, you can use the examples provided here at Plotly. Choose any of these to get started!

Import with examples

Step 6

Update Your Data

Did you know that when you edit your data, your plot automatically updates?

You can see in the image below that we want to add two more rows of data, and we do so by typing directly in the grid. It's that simple!

Update data

Step 7

Working with Multiple Grids

If you're working with multiple grids, there's a specific way to select your values. Let's say you have two grids open, each with their own dataset. Click on GRAPH, then 'Create'. When you select the X and Y values from their dropdown, select them under their specific grid (the grid label is grayed out). In the image below, you'll see that we've added values from Grid 2.

Grid dropdown

Another important thing to remember if you want to save your plot with all your grids is that you must include data from each grid into a trace. If you miss this step, your saved plot will open with certain grids missing.

Click the blue '+ Trace' button at the top right-hand side of that panel; this will add another trace to your plot. Select the X and Y values using the data from another grid. Since we've already selected Grid 2 values, we'll now add them from Grid 3. Repeat these steps until you've added values from all your grids.

grid 3

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

We're currently busy adding new features to our Plotly 2 workspace. At the moment, the option of deleting grids isn't available. Both these features will be available in the near future, so check back soon!

Still need help?
Contact Us

For guaranteed 24 hour response turnarounds, upgrade to our Premium or Enterprise plans.