Export a scheduled report to Excel

DCIM_Support · ‎2020-07-05

Is there a way to get a scheduled report to run in excel instead of coming through as a text file?

DCIM_Support · ‎2020-07-05

Dear Todd Walters,

Hopefully Steven Marchetti answer from topic will help you:

...That is correct, we do not export in an XLS format. Exports are formatted in a comma delimited file which Microsoft Excel is capable of opening and formatting. Simply open the file in Excel. If it does not automatically format itself (mine does in CSV format), you should get a text import wizard popup in Excel. Simply choose delimited, hit next, then choose the delimiter which in this case is a comma. You can do some formatting if you would like during the import but then hit finish and it be properly aligned in rows and columns.

If you have more questions, please ask.

With respect.

See Answer In Context

DCIM_Support · ‎2020-07-05

Dear Todd Walters,

Hopefully Steven Marchetti answer from topic will help you:

...That is correct, we do not export in an XLS format. Exports are formatted in a comma delimited file which Microsoft Excel is capable of opening and formatting. Simply open the file in Excel. If it does not automatically format itself (mine does in CSV format), you should get a text import wizard popup in Excel. Simply choose delimited, hit next, then choose the delimiter which in this case is a comma. You can do some formatting if you would like during the import but then hit finish and it be properly aligned in rows and columns.

If you have more questions, please ask.

With respect.

DCIM_Support · ‎2020-07-05

Thanks alot. The data does copy and paste into excel just fine.

DCIM_Support · ‎2020-07-05

Ok, very thanks for the good feedback 😀.

DCIM_Support · ‎2020-07-05

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.