Forum Discussion
Device Magic to Excel
One thought: try just importing into an existing workbook the data from that Device Magic exported file.
On a very regular basis I export data from Fidelity having to do with an investment portfolio. It is exported as an Excel file (although the option exists to do it as CSV). I open that file in Excel, but then use the FILTER function to import the data into a formatted section of my active workbook where I can do whatever analyses of specific elements I wish.
The single formula that brings in the data is this:
=FILTER([filename.xls]Worksheet1!$A$5:$T$99,[filename.xls]Worksheet1!$A$5:$A$99<>"")
Which basically says FILTER in all rows and columns from $A$5 to $T$99 where the cells in column A are not blank. "filename" only contains data in a subset of those rows, I just specify up to 99 rows to allow for the file to change in size.
In other words, I don't try to format the exported file; I do all the processing and formatting on a stable workbook sheet into which I've brought (via that formula) the data from the exported data.
So that's just a possibility. (Or did I misunderstand what you wrote, and that's actually what you've been trying?)
