Walsin Export Column Order: Column 8 Holds 14 Different Names, and a Tolerance Read by Position Is Wrong in 30 of 114 Files

Walsin export column order is not a schema. We read the header row of all 114 export files that hold parts: 89 distinct names, and only Part Number sits in the same column in every file. Column 8 carries 14 different names. A loader that reads column 6 as tolerance is right in 84 files and wrong in 30.

Venatech Limited, an authorised Walsin distributor in Hong Kong, holds all 203 parametric export files published by Walsin Technology (Walsin). This post is written from the 114 files that hold part numbers: 64 chip resistor, 18 MLCC, 11 thin film, 14 RF, 2 each for inductor, varistor and antenna, and 1 disc capacitor. We read each header with a spreadsheet library and recorded the column number of every name. Every part number below is real. If you read these files by column number, what are you reading?

Does the same column sit in the same place in every Walsin export file?

No. Only Part Number does. We read the header row of all 114 files and recorded the name at each column number. There are 89 distinct header strings. Column 1 holds one name in all 114 files. Column 2 holds two, columns 3 and 4 hold eight each, and column 8 holds 14. Of the 89 names, 62 sit at one column number and 27 at more than one.

We have not seen this counted anywhere. Of the first ten column numbers, nine carry between 2 and 14 different names, and the chip resistor layout is right for all 114 files at column 1 and for no more than 84 at any other. The files are 14 distinct ordered header lists: one for chip resistor, two for MLCC, one for thin film, six for RF and one each for the other four families.

What does a tolerance read by column number actually return?

Something other than a tolerance in 30 of the 114 files, covering 106,665 of 390,463 rows (27.3%). We took column 6, the position where the chip resistor, MLCC and varistor files all hold Tolerance, and recorded what the other files hold there. It is right in 84 files and 283,798 rows. In 30 files it returns a different quantity, in 11 of them a temperature coefficient: all 93,914 thin film rows. We counted rows after excluding the Test123999 QA row from the inductor files.

Sixteen of the 30 files, 14 RF and 2 antenna, publish no tolerance at all. The other 14 publish one at column 5 in 12 files and column 9 in 2. A script that parses column 6 as a number fails on 1805~1880 MHz but succeeds on 1 and 0.32, and carries on.

Why do the chip resistor and thin film exports agree on one position out of nine?

Because the 64 chip resistor files carry a column the 11 thin film files lack. The families share nine header names, and we counted each position. Chip resistor files have ten columns and thin film files nine; the missing one is Series Group at column 2, so eight of the nine shared names sit one column to the left in thin film. Only Part Number stays put.

The consequence is concrete. A loader built on the 64 chip resistor files, 234,815 rows, and pointed at the 11 thin film files, 93,914 rows, reads column 6 expecting Tolerance and gets TCR, reads column 5 expecting Resistance and gets Tolerance, and finds no column 10. WF25H1R00BTL, a chip resistor, and SF12T1R00ATL, a thin film part, are both resistors with all nine shared fields filled, and they disagree about where each field lives. For the part-number side of the same boundary, see thick film or thin film: 6,836 pairs differ by one character.

Does a column name shared by several families keep its place?

Almost never: 14 of 15. Fifteen header names are used by more than one family, and we listed the column number each occupies in every family that uses it. One of the 15, Part Number, holds the same column number in every family. The other 14 move.

Seventeen names also move inside one family: 13 in RF, whose six layouts differ, and four in MLCC. In the 173-row sample 00_ALL_MLCC_combined.xlsx, Remark is column 11 and Termination, Packing and SPQ sit one place later than in the 17 other MLCC files, where Remark is column 14.

Is one quantity ever called by several names?

Yes: 8 quantities carry two or three names, and the split between names often follows a split between filled and empty. We counted the non-blank rows in the files that declare each name.

The pattern is the useful part: the name that is filled is the one the chip resistor and thin film exports use, and the alternative is empty on every row. We counted that directly, not from the header. One variation is cosmetic but breaks a string match: 12 header strings put a space before a bracketed unit, as in Insertion Loss (dB), and 10 do not. Three names, Insertion Loss (dB) and Impedance for Frequency 1 (Ω) and 2 (Ω), each have a twin without the space, all six in the RF exports.

What should a loader key on instead of a column number?

The normalised header string and the product family, never a column number. Across 114 files, 89 names and 14 ordered layouts, a column number is dependable for exactly one name, Part Number. Four rules follow from the counts.

1. Read by name, never by number. A column number is right for Part Number and, for a chip resistor layout, for nothing else across all 114 files.
2. Key the schema on the file family before the column. The same name sits in different places across 14 layouts.
3. Collapse the space-before-bracket variants before comparing, and keep the original string.
4. Check that a column is filled. Packing, SPQ, MOQ, T.C., TCC and Thickness are declared and empty on every row we counted.

Our earlier join-key count of 90 header names came from a reader that renames the second Pin Description in Walsin_Multiplexer.xlsx to Pin Description.1. Read raw, the headers are 89 distinct strings and the multiplexer repeats one in columns 12 and 19. The correction changes none of the conclusions here. For the offset in that file, see the multiplexer export is offset by one column.

We hold 28 Walsin datasheets, 451 pages, and none for thin film, inductor, varistor, disc capacitor, RF or antenna, so for six families the export header is the only definition of a field we can show you. Our free cross-reference tool reads by name and family. What is in Hong Kong is on ready stock: 1,125 part numbers as at 23 September 2026, a dated snapshot and not a live feed. The resistor range is on the chip resistor page.

The short version

Across 114 Walsin export files there are 89 distinct names, 14 ordered layouts and one column that never moves. Column 8 carries 14 names; column 6 is Tolerance in 84 files and something else in 30, covering 106,665 of 390,463 rows. Chip resistor and thin film share nine names and agree on the position of one. Of 15 names used by more than one family, 14 move. A column called Thickness is empty on all 48,225 MLCC rows while T holds the thickness, and Packing is empty on 49,912 rows while Packaging is filled on 328,729. We will not tell you a field matches because the column number does. Qualification stays with you.

Send us the import script and one row from each family you load, and we will tell you which columns it reads from the wrong place. And a question back: when your thin film tolerance column came back as ≦±50, did you conclude the parts were loose?

Frequently asked questions