Importing excel file

[priyada]

Hello

i am importing coordinates of point via excel file but inventor does not converts into sketch. Any suggestions?

[rhasell · Accepted solution]

Hi

The only options I know, is the "File Open options"

You can change the import options to Create lines or Splines.

This is available in both 2D and 3D sketch

[priyada]

for me  that option is not getting highlighted. 

[Gabriel_Watson]

Inside a sketch, you'll need to pick "Insert Points"

[priyada]

Yeah i tried that. but my points were not joined by line. is there something which i am missing?

[Gabriel_Watson]

1- create a sketch

2- Insert Points function

3- pick Excel sheet in the format where the first column has X values and second column has Y values

4- pick "Options" before you hit "Open" and select Create Lines (or Spline if preferred).

[johnsonshiue]

Hi! Please share your Excel spreadsheet. It should work both in 2D Sketch and 3D Sketch.

Many thanks!

[priyada]

okay I have attached the file

[Gabriel_Watson]

Create a 3D sketch

Insert points by pick the sheet with option to include lines between points:

FYI a few points were ignored since they were coincidental:

[rhasell]

Hi

I don't have any Screen-cast software installed, so I made a small video for you.

[rhasell]

LOL, you beat me to it.

[Gabriel_Watson]

You beat me to it first =D

[priyada]

thank you all