Welcome to the Onshape forum! Ask questions and join in the discussions about everything Onshape.

First time visiting? Here are some places to start:
  1. Looking for a certain topic? Check out the categories filter or use Search (upper right).
  2. Need support? Ask a question to our Community Support category.
  3. Please submit support tickets for bugs but you can request improvements in the Product Feedback category.
  4. Be respectful, on topic and if you see a problem, Flag it.

If you would like to contact our Community Manager personally, feel free to send a private message or an email.

Picking co-ordinates from sketch to dump to csv file

Stuart_TodStuart_Tod Member Posts: 64 PRO

Has anyone written a way of picking co-ordinates from a sketch that can be written to a .csv file or similar (ideally straight into Excel spreadsheet!)? I find myself needing to extract all the co-ordinate X,Y pairs from points along a curve (preferably with a mouse click) and having them recorded in a useable format for me to analyse in a spreadsheet. I'm presently doing it manually by clicking on each point and copy/paste the x,y from the measure tab at the bottom of the screen, one at a time. I have over 3000 data points to collect….

Comments

  • eric_pestyeric_pesty Member Posts: 2,284 PRO

    I've use the "points to table" FS a few times for similar workflows, but only for a small number of items:

    https://cad.onshape.com/documents/81cac0c3f1a3b3ac209c70d6/v/305b9fa86d6700be596736aa/e/5bcdafea538762bf6f6e89bc

  • GregBrownGregBrown Member, Onshape Employees, csevp, pcbaevp Posts: 336
    edited August 16

    I can imagine a lot of ways this might be done, and especially for the hint you gave us "extract all the co-ordinate X,Y pairs from points along a curve"
    I am assuming you want to sample that edge (or curve) and extract those coordinates at the sampled points.

    Here is a simple implementation that works for sketch entities as well as 3D curves. Coordinates returned are x,y,z.
    https://cad.onshape.com/documents/0cffa5477715a66fdbb82f8f/w/f580449b2189f854cea8f3a7/e/1891b92a55e54f21c73c0024


    image.png
  • Stuart_TodStuart_Tod Member Posts: 64 PRO
    edited August 17

    @GregBrown Thanks! I'll try it out this morning. Looks very close to what I want.

  • Stuart_TodStuart_Tod Member Posts: 64 PRO

    @eric_pesty , exactly what I needed! Thanks.

Sign In or Register to comment.