Dear Team,
i am generating BOM from my Kicad Schematic.What I can see is all fields are coming in one column.
Please see the below images
Could you please help me
What program is that, Excel? Looks like you didn’t tell it comma is the separator. Sometimes a spreadsheet program assumes other separators like tab or semicolon. LibreCalc usually guesses correctly though.
I am using excel for generating BOM:could zou please tell me how to configure the fields
I tried with the below settings but result is same.
Excel sucks bigtime at importing CSV files!
What usually works is to open a new sheet, then on the Data tab, in the Get & Transform Data group, click From Text/CSV.
2 Likes
Sorry I don’t have Excel or Microsoftware.
1 Like
CSV is a quite horrible format for transporting information between programs.
Using semicolons or tabs is slightly less worse.
Maybe it would be nice if you could get the whole word to agree to reserve a specific UTF code for this, so text strings can be parsed by spreadsheet programs unambiguously.
1 Like
But you see commas in it.
So there are commas, but when loading were not detected as field delimiters.
I don’t use Excel, I prefer open source.
Are you sure you told Excel that commas are field delimiters?
1 Like
Newbie - To fix the current spreadsheet, use Excel’s Text to Columns dialog/wizard : https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7
For the future, you might try importing it into Excel: https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba
1 Like
Thank you.I can process the BOM as mentioned by you.
But why Kicad is not separating it.Is it a bug or a mistake from my side.
KiCad IS separating the fields, with commas. CSV stands for Comma Separated Values.
3 Likes