Import Excel-Tables into drawings

Axel_Kollmenter

How can I Import a table I created in Excel into my drawing?

I tried to export and imported it as an csv file and loaded it into OS but now I dont know how I import it into my drawing as a table.

Axel_Kollmenter

Hello everyone,

I got a mail from the support-team.

This function is currently not supported in OS but certainly up to a certain point. He said that an easy way is to take a screenshot of the table in excel and import the image.

Unfortunately you still have to make changes in excel and take a new screenshot. Quick table editing in OS is then not available.

I´m looking forward to the update where its going to work

bryan_lagrange

@Axel_Kollmenter they have a connection for google sheets, Don't know if this would help.

App Store:

Onshape BOM Google Sheets

https://appstore.onshape.com/apps/Data%20Management/F6U5XSR2NAJY2QW4VTB3GSPCUNOF42XYEAOHNQQ=/description

Forum posts:

https://forum.onshape.com/discussion/comment/83727#Comment_83727

 https://forum.onshape.com/discussion/6100/onshape-bom-for-google-sheets-export-any-table-selection

Axel_Kollmenter

Hello everyone,

I got a mail from the support-team.

This function is currently not supported in OS but certainly up to a certain point. He said that an easy way is to take a screenshot of the table in excel and import the image.

Unfortunately you still have to make changes in excel and take a new screenshot. Quick table editing in OS is then not available.

I´m looking forward to the update where its going to work

bryan_lagrange

@Axel_Kollmenter they have a connection for google sheets, Don't know if this would help.

App Store:

Onshape BOM Google Sheets

https://appstore.onshape.com/apps/Data%20Management/F6U5XSR2NAJY2QW4VTB3GSPCUNOF42XYEAOHNQQ=/description

Forum posts:

https://forum.onshape.com/discussion/comment/83727#Comment_83727

 https://forum.onshape.com/discussion/6100/onshape-bom-for-google-sheets-export-any-table-selection

Axel_Kollmenter

Hi @bryan_lagrange I will check it out! Thanks for your help.

Alex_Pitt

Hi, I've created a VBA script to export JSON from excel in the right format for Onshape. This is shared on another thread somewhere on the forum (I'm currently on my mobile so can easily find it)

MichaelPascoe

Reply from other post:

@Alex_Pitt, here is your post with the JSON exporter: https://forum.onshape.com/discussion/comment/92883#Comment_92883

Alternatively, Table - Custom Feature will let you take a CSV directly from an import which you can use in your drawing. Then if you update the imported file, the table will update.