Skip to main content
Feb 27, 2026 4:49 PM UTC
Solved

How to export .xls table in creo table format

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!!

 

PBrulotAnswer
Feb 28, 2026 1:57 PM UTC

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.

4 replies

Feb 27, 2026 6:53 PM UTC

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

CSV.png

Feb 27, 2026 8:38 PM UTC

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.

PBrulotAnswer
Feb 28, 2026 1:57 PM UTC

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.TAuthor
Mar 3, 2026 8:32 PM UTC

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!