That's a good point. I know sometimes when you copy it'll contain a special character or hidden formatting that causes an issue. I usually use Notepad to see if I picked up any extra or odd characters, it resets to plaintext, and then I paste into Apptio.
------------------------------
Justin Kean
Apptio
Sr Instructor
------------------------------
Original Message:
Sent: 04-25-2022 08:01
From: Justin Hazelrigg
Subject: Weird Import Error Occurring...
My instinct is that something table format wise is coming over when you copy and paste. I would try opening another instance of excel, copy the values from one workbook and then Paste Special Values Only(Home > Paste > Paste Special) , then save as a csv to see if you are getting the same error. Good Luck!
Original Message:
Sent: 04-23-2022 12:18
From: Jenny Franklin
Subject: Weird Import Error Occurring...
So I copy the data from a sheet (values only), save as CSV and load it, but inevitably, I get this weird import error π. Anyone see anything like this before?
When I do a search on Google (after putting it in quotes), I see this in the results: Excel [Content_Types].xml file generated by C# OpenXML.
This is after I copy/paste values only, though. How can I copy/paste the data and not run into this mess? ππ€·ββοΈ
//schemas.openxmlformats.org/package/2006/content-types"><Default Extension="bin" ContentType="application/vnd.ms-excel.sheet.binary.macroEnabled.main"/><Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml"/><Default Extension="xml" ContentType="application/xml"/><Override PartName="/xl/worksheets/sheet1.bin" ContentType="application/vnd.ms-excel.worksheet"/><Override PartName="/xl/worksheets/binaryIndex1.bin" ContentType="application/vnd.ms-excel.binIndexWs"/><Override PartName="/xl/worksheets/sheet2.bin" ContentType="application/vnd.ms-excel.worksheet"/><Override PartName="/xl/worksheets/binaryIndex2.bin" ContentType="application/vnd.ms-excel.binIndexWs"/><Override PartName="/xl/externalLinks/externalLink1.bin" ContentType="application/vnd.ms-excel.externalLink"/><Override PartName="/xl/externalLinks/externalLink2.bin" ContentType="application/vnd.ms-excel.externalLink"/><Override PartName="/xl/externalLinks/externalLink3.bin" ContentType="application/vnd.ms-excel.externalLink"/><Override PartName="/xl/theme/theme1.xml" ContentType="application/vnd.openxmlformats-officedocument.theme+xml"/><Override PartName="/xl/connections.bin" ContentType="application/vnd.ms-excel.connections"/><Override PartName="/xl/styles.bin" ContentType="application/vnd.ms-excel.styles"/><Override PartName="/xl/sharedStrings.bin" ContentType="application/vnd.ms-excel.sharedStrings"/><Override PartName="/xl/printerSettings/printerSettings1.bin" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.printerSettings"/><Override PartName="/xl/tables/table1.bin" ContentType="application/vnd.ms-excel.table"/><Override PartName="/xl/queryTables/queryTable1.bin" ContentType="application/vnd.ms-excel.queryTable"/><Override PartName="/xl/printerSettings/printerSettings2.bin" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.printerSettings"/><Override PartName="/xl/tables/table2.bin" ContentType="application/vnd.ms-excel.table"/><Override PartName="/xl/queryTables/queryTable2.bin" ContentType="application/vnd.ms-excel.queryTable"/><Override PartName="/customXml/itemProps1.xml" ContentType="application/vnd.openxmlformats-officedocument.customXmlProperties+xml"/><Override PartName="/customXml/itemProps2.xml" ContentType="application/vnd.openxmlformats-officedocument.customXmlProperties+xml"/><Override PartName="/customXml/itemProps3.xml" ContentType="application/vnd.openxmlformats-officedocument.customXmlProperties+xml"/><Override PartName="/customXml/itemProps4.xml" ContentType="application/vnd.openxmlformats-officedocument.customXmlProperties+xml"/><Override PartName="/docProps/core.xml" ContentType="application/vnd.openxmlformats-package.core-properties+xml"/><Override PartName="/docProps/app.xml" ContentType="application/vnd.openxmlformats-officedocument.extended-properties+xml"/><Override PartName="/docProps/custom.xml" ContentType="application/vnd.openxmlformats-officedocument.custom-properties+xml"/></Types>
#ApptioforAll