Generate report to CSV to XLS

[Syksy]

Hello everyone, i am using the Generate Report Tool so much,
in a fast workflow, but im still strugglin with the fact that it only exports it on CSV, and then i have to open it, it cames out in a messy way… then deleting all that… import data as CSV… and then save it as an XLS.

Then i put that XLS file into a intern database where it is "processed "and so on, this part doesnt matter.

The thing is, is there a way to make this procedure faster? like an extension or anything or a tood to export it directly in XLS?

[Elmtec-Adam]

Can you post an example report?

an XLS shouldn’t in theory be any different beyond supporting all of the Microsoft Excel specific functions (which isn’t needed for a simple sketchup report)

If I open a CSV in excel it appears as such, which is what I would expect

[rtches]

If your steps are always the same why don’t you record a macro in excel? Then, the next time only by running the macro all the steps are done.

[Syksy]

if i open the file just made from sketchup report, i see it like this:

i must delete all this, and insert data as CSV

[Elmtec-Adam]

That looks like you have a setting in excel wrong somewhere - they just open like my screenshot for me.

[Elmtec-Adam]

I noticed your excel is in italian - this may be why.

Press the start button/windows key and search the “control panel”
Clock and Region

additional settings

Make sure that “list seperator” is a comma ,

[rtches]

It’s not neccesary… (I hope you can understand Spanish… )

[Syksy]

Si lo hago jaja, gracias!