Do you know, that… ?

If you have data from external programs, e.g. hole coordinates in Excel – you can use them in SOLIDWORKS.

Unfortunately, the program does not read Excel formats directly, but can export data to text format.

And today I will write a bit more about it.

The hole coordinate data is two X columns,Y. To save this data in text form, select Text (delimited by tabs). In much older versions of Excel, saving was possible by selecting a command Export of external data.

It is still necessary to check the decimal separator from Excel. For me it is by default “,” – unfortunately it cannot stay that way. Therefore, by editing my data already from the level notebook, I replace the separator “,” on “.” (comma to dot). If fractions do not contain dots – SOLIDWORKS does not load the file slowly!

In SOLIDWORKS itself, I choose Chic leaning on table. Prior insertion is required to use this pattern Coordinate system.

After selecting the operation to be duplicated and the coordinate system, I point to my text file. As you can see, the coordinates have been loaded and new holes have appeared in the preview.