topic Re: Importing excel file in Inventor Forum

Importing excel file

priyada — Thu, 10 Mar 2022 22:15:38 GMT

Hello

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

rhasell — Thu, 10 Mar 2022 23:14:40 GMT

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 — Fri, 11 Mar 2022 16:39:44 GMT

for me that option is not getting highlighted.

Gabriel_Watson — Fri, 11 Mar 2022 16:49:48 GMT

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

priyada — Fri, 11 Mar 2022 16:57:35 GMT

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

Gabriel_Watson — Fri, 11 Mar 2022 17:29:32 GMT

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 — Fri, 11 Mar 2022 21:35:31 GMT

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

Many thanks!

priyada — Fri, 11 Mar 2022 22:27:16 GMT

okay I have attached the file

Gabriel_Watson — Fri, 11 Mar 2022 22:36:29 GMT

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 — Fri, 11 Mar 2022 22:48:49 GMT

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

rhasell — Fri, 11 Mar 2022 22:49:52 GMT

LOL, you beat me to it.

Gabriel_Watson — Fri, 11 Mar 2022 22:51:45 GMT

You beat me to it first =D

priyada — Fri, 11 Mar 2022 23:06:28 GMT

thank you all