Exporting from the Commanders Report

[countrboy]

I tried to export data from the Commanders Report, but when I open the file in Excel it's largely unusable due to the formatting of the data. Is there a way around this?

[Chris21wen]

ORIGINAL: countrboy

I tried to export data from the Commanders Report, but when I open the file in Excel it's largely unusable due to the formatting of the data. Is there a way around this?

There's a huge amount of data and the export is a simple way of providing access to it by the designer. Once it's exported it's up to sort it. Use column A, which identifies the different section (tab reports), and copy and paste the bits you want to a separate sheet.

[countrboy]

The problem is that when I open the file all of the data is in Column A. Each line is simply one long string of characters, all in Column A. It's completely unformatted.
I would post a screenshot but don't know how.

[deep42]

countrboy,

the exportfile is a Tab seperated CSV file. If you use (a newer) Excel you should not use File > Open, but create a new empty Excel sheet, then use Data tab > From Text. Select the file and click import, then set data type to delimited and set delimiters to Tab.

More for example here: https://www.copytrans.net/support/how-t ... -in-excel/
https://www.hesa.ac.uk/support/user-guides/import-csv or check the Excel docs

HTH
Peter

[thedoctorking]

And if you are importing into an existing spreadsheet, open the export file in Notepad or some similar text editor and copy-paste.

[countrboy]

Thanks deep42, will give that a try, sounds like the fix.

[Chris21wen]

ORIGINAL: thedoctorking

And if you are importing into an existing spreadsheet, open the export file in Notepad or some similar text editor and copy-paste.

I use Libre and it asks you what separator you want to use whenever you open a CSV. I always thought excel did to!

[dmh0667FU]

Thanks, y'all, this helped, IMMENSELY![&o]

And now to some Data-Mining.....