Getting Started with Tables of Data

Overview

Entering tables is easy depending on what type of data you're looking to enter. To add a blank table, open the Add Item menu and choose Table.

Enter values into the table and use the arrow keys to easily maneuver through the table. You can also copy and paste data from an existing spreadsheet. Desmos will automatically generate a table. Note that the column header titles will not transfer and there is a maximum of 50 rows that are able to be copy and pasted in a table. Copying and pasting more than 50 rows will generate more than one table.

Click and hold the icon in the depending header to open the color, style, and drag menu. For more help on tables, check our our full Tables article.

 

Pro-Tip: Use Convert to Table to generate tables for expressions, equations and more.

 

More Resources

Have more questions? Submit a request

27 Comments

  • 0
    Avatar
    Mr. Pearce

    Hi Friends!

     

    Is there any way to "copy/paste" data into a table of values?  For example, if we collect data in a GForm, is there a way to paste the data directly into the table?

     

    Thanks!

  • 0
    Avatar
    Glenn Laursen

    Mr. Pearce,

    Were you able to find a way yet? I had pretty much the same idea.

  • 0
    Avatar
    Team Desmos

    We just added that feature (and regressions!) Try out the regressions tour in the help menu to get started.

    To copy/paste from a spreadsheet, copy the data and paste it into a blank expression box in the calculator.

  • 0
    Avatar
    Glenn Laursen

    Beautiful, thank you!

  • 0
    Avatar
    nin10dorox

    Hi. Sorry for the noob question, but how do you start a topic?

  • 0
    Avatar
    Wolfed

    I tried copying a table both from a Google Sheet and Excel and it won't paste into the expression box.  Is there a way I need to do it other than ctrl v?  Thanks!

  • 0
    Avatar
    Itmam Azad

    Hello Im new, but is there a way that after I put in my equation and it beconmes a graph, can I see the coordinates in a table form

  • 0
    Avatar
    Esther McKay

    When I cut and paste from Google Sheets, it works as one would hope.
    When I cut and paste from MS Excel, it become one long useless data string. Any ideas how to fix it? Going from Excel to Desmos would be great!

  • 1
    Avatar
    Tony Hooper

    How long can a table be? I copied an 2 columns from Excel which were about 200 lines long and only about 50 lines were actually pasted. Am I doing something wrong?

  • 0
    Avatar
    Team Desmos

    Esther - pasting from Excel is fixed! Let us know if you see any issues.
    Tony - we currently support pasting up to 50 data points, but are working on increasing that number :)

  • 1
    Avatar
    Esther McKay

    Hi! Excel and Numbers are working great to paste data into Desmos... from my laptop (which is still fantastic). However when I try to cut and paste data on an iPad, nothing seems to happen. Is this just how it (currently) is on the iPad? Thanks!
    ~Esther

  • 0
    Avatar
    Lee Trampleasure

    Is there any way to plot a new x column in a scatter plot? I want my students to be able to linearize data to find an exponential relationship. For example, given a set of x,y coordinates, students can fit a line to it, but I want them to be able to fit a line to x^2,y.

    Any way to do this automatically? I can square the x1 data, but then I can't put that on the horizontal axis.

  • 0
    Avatar
    Team Desmos

    Lee - one option to plot those points would be to write (x1^2,y1) on a new expression line. It will plot the squared x values and y values from the table you created. If you'd like to run a regression on these values, you can convert to table and then run the regression!

  • 0
    Avatar
    Lee Trampleasure

    Nice solution. I hadn't seen the Convert to Table yet; great feature.

  • 0
    Avatar
    Kuzoffn

    Is there any way to access a specific element or row in the table, like for example, x_1{0} or x_1[0]? Thanks!

  • 0
    Avatar
    Team Desmos

    You can use x1[1] to find the first element in the x1 column of a table!

  • 2
    Avatar
    Kuzoffn

    Thanks! I was also wondering if there was a way to get the index of the element currently being accessed in the list. Like, if this were a for loop in programming, x[i] or x[i-1]. Is there a way to do this?

  • 0
    Avatar
    P Bartman

    Having the same problem pasting using the ipad.  I have some data in google sheets but I cannot copy in into a desmos table using the paste feature.  Works fine on computer.

  • 0
    Avatar
    Sam Spedding

    Is there any way to sum up a set of data?

    I have x1 and y1 each equal to 10 values and I want to evaluate the sum of these, i.e.  ∑(x1) and ∑(y1).

  • 0
    Avatar
    Michael Fenton

    Hi Sam. Absolutely! There are a couple of ways to do that. Here's an example: https://www.desmos.com/calculator/anbmjc3rya

  • 0
    Avatar
    Dbaker

    Pasting data from Google Sheets is simply creating a single entry with all the data... not actually populating the table.

     

  • 0
    Avatar
    Lee Trampleasure

    Another tip: My students are using a table in Google Docs. If you try to paste this directly, you just get a string of numbers in one cell. But, if you first paste the values into a Google Sheet, then copy that table into Desmos, it works fine.

    They don't have to do anything to it in Sheets, just paste from Docs, copy, then paste into Desmos :-)

    If this can be 'fixed' in Desmos, that will be great, but in the mean time, this 'hack' works just fine.

     

  • 0
    Avatar
    Yassin Mellouki

    Is there a way to copy the values on the table?

     

  • 0
    Avatar
    Lee Trampleasure

    Wow, good question. I can't seem to do it; you'd think it would be possible :-(

  • 0
    Avatar
    David Crowley

    Hi Lee. For converting to table, in case you or others are still having trouble, you need to click on the gear icon at the top of the editing area. This will bring up extra icons in the expression area. One of them is convert to table! It took me a while to find it: I was looking for a gear directly in the expression area where I'd typed (x1^2,y1)

  • 0
    Avatar
    skylord a52

    I'm looking for something similar to Kuzoffn. I can emulate a list using a table with x1[n], getting the nth element of x1. What if I wanted to do something more along the lines of a numeric hash table or a function, getting the y1 value for a specified value of x1?

    For example, if I were tring to figure out how an unknown function behaved, I might put in various (x,y) pairs in a table to graph the relationship visually. But unless all the x points are ordered integers starting at one, I can't later access this table of values for use in other functions, because y1[1] doesn't necessarily mean the same thing as y1(x1=1)

  • 0
    Avatar
    Csullivan

    Can you sort your data by ascending values in Desmos?

Please sign in to leave a comment.
Powered by Zendesk