I have no idea what the purpose of the XY coordinate for pin1 or "upper left" it does seem quite common to be able to output it.
However what you want is component centres and if you can't seem to do that, that could be because you have defined those packages that way.
You could add an internal part number (and then reference multiple alternatives for that in the BOM) in the comment/description column, or add a part number column.
The manufacturer will have tools to hand ranging from suites dedicated to setting up lines, the software on the machine or just good old excel, as long as they have the data they should be able to work with it.
The software on my machine lets me choose which column contains what data, it can then create rules where it combines package & value to identify part numbers, but this can be dangerous if your value column isn't very accurate and the BOM has more specifics like a capacitor in multiple voltage but the same package.
So I can handle:
ID,Value,Package,X,Y,Rot
ID,PartNumber,X,Y,Rot
Sometimes I am supplied with ID,X,Y, Rot,Package and no part number, rather than manually adding the partnumber data on the machine I have a program that looks up each ID in the BOM file and copies the value/part number data across. This seems to be quite a common format so I presume some machines are setup to receive the data as two separate files.
Arguably an actual part number is better than value+package as package often means footprint which might cover several packages, also CAD packages sometimes use very weird package names that mean nothing to anyone who hasn't seen them before.
Some places using parts kitted by you might not even use part numbers, instead labelling the reels with a BOM line number and using that.
As to formats, its all plain text CSV, although I would avoid using commas as they are quite common to find in both part numbers and value descriptors semi-colon or pipe seem quite safe tho' & if for some reason they don't like it.. that is what Excel is for. It seems to be a good idea to stay away from the newer Excel format however as some tools don't seem to like it still (whats it been 10 years?!)
Once you have settled on a format, stick to it, on my setup I rely on a given client being consistent to let these automated tools build up their rules.