topic Re: Problem when trying to import excel spreadsheet in 3D Part & Assembly Design

Problem when trying to import excel spreadsheet

NF_10609258 — Mon, 07 Aug 2023 11:09:57 GMT

When trying to import spreadsheet from excel to creo drawing, creo replaces rows with dash dots as you can see in picture. I saved excel file as CSV MS DOS

Re: Problem when trying to import excel spreadsheet

kdirth — Mon, 07 Aug 2023 12:44:41 GMT

I don't know what character you are referring to as "dash dots" in your excel file, but my guess is that it is a character not recognized by Creo.

Try saving it as a CSV comma delimited. I obtained different results for a variety of characters.

CSV MS DOS CSV comma delimited

Re: Problem when trying to import excel spreadsheet

MartinHanak — Mon, 07 Aug 2023 15:25:48 GMT

Hi,

Re: Problem when trying to import excel spreadsheet

ptc-4658280 — Thu, 16 Nov 2023 19:01:49 GMT

hello,

i have a similar problem, creo do not recognize the columns from excel, crating just a big list with semicolon separator just like the picture

Re: Problem when trying to import excel spreadsheet

kdirth — Thu, 16 Nov 2023 19:32:31 GMT

What format are you saving it as to import into Creo?

CSV Comma Delimited should work correctly.

Re: Problem when trying to import excel spreadsheet

ptc-4658280 — Thu, 16 Nov 2023 19:43:42 GMT

yes i am saving on both formats, bu still the same

Re: Problem when trying to import excel spreadsheet

kdirth — Thu, 16 Nov 2023 19:55:43 GMT

What does it look like if you open it in notepad?

Re: Problem when trying to import excel spreadsheet

ptc-4658280 — Thu, 16 Nov 2023 20:00:08 GMT

just like this, with semicolon, i tried to replace all the semicolon with colon and it do not recognise the file

Re: Problem when trying to import excel spreadsheet

ptc-4658280 — Thu, 16 Nov 2023 20:03:57 GMT

nevermind, just solved, exported it as .csv and opened in notepad, replaced all the semi colon with comma from the editor tab and saved it as whatever name.csv

Re: Problem when trying to import excel spreadsheet

TomU — Thu, 16 Nov 2023 21:05:24 GMT

Looks like you need to adjust Excel's delimiter.

https://www.ablebits.com/office-addins-blog/change-excel-csv-delimiter/