How to export .xls table in creo table format

[Yogesh.T]

How to bring .xls table in Creo10? Is there a simple way to do so. I have a big BOM i am working on and ita a pain to copy paste: ) 

Thx in Adv! Creo on Fly!!

[kdirth]

Use Save Table > Save as CSV.  Open in excel, comma delimited.

[KenFarley]

When we put a bill of materials on a drawing, we never have to enter any text into the table manually. Every component in the assembly has parameters (DrawingNumber, DescriptionBOM, etc.) that are used in the table. The BOM is "built" by the drawing - quantities are automatically added up.

If a component is gotten from an outside source, we just have to put the few parameters that matter in that downloaded part/assembly. If there's something that needs to be included but it's not an actual component, like paint or grease, it gets added to the assembly using a bulk part.

I do not miss the days of editing huge BOM tables to add all the entries, or being the person checking the drawing and having to count screws, dowels, or any other such components.

Possibly this might help? It's a bit of work up front, but it pays off a lot if you're going to be using parts and assemblies over and over.

[PBrulot · Accepted solution]

In Creo 10 you can import a table from a csv file so you have to save the excel file as csv file. In Creo, select "table from file" and in the open file box, select type csv.

From Creo 11 you can directly import an excel file.

... it is still a big question mark why you have to copy a BOM table from excel into a drawing.

[Yogesh.T]

It has 120 components many that are not even in the CAD but hardware., But your suggestion was worked on by me and optimized with a bit trial and error to get what was needed. 

CREO in need, can do it with community help!