Export to htm (Google Sheets) button

1

Here is a way to work with reports, both standard and custom, in Google Sheets

MANAGER
In Manager select a report to View and then click Copy button

NOTEPAD
Open Notepad an press Ctrl-V (In Mac a comparable software would probably be TextEdit but haven’t tested)
Select Save and when entering the file name add “.htm” to the end. For example Report.htm

GOOGLE SHEETS
Open Google Sheets in a browser
File / Import / Upload / Select a file from your device

you might need to turn Amounts into numbers to work with and this can be done usually by choosing Ctrl F and replace comma (,) with dot (.)

@Lubos, export to htm button would therefore most likely be a good option to have in Manager´s Report module, to skip Notepad and copy/paste chore, as Google Sheets has become a very capable spreadsheet software.

01 Custom report

02 Notepad

03 file name

-import

07
07780×644 30.6 KB

2

Exports are tab-separated-value (TSV) files. Why go through this multi-step process?

3

My suggestion was an export button “Export to htm” of standard htm files if possible, to get rid of multistep process with copy/paste, as such htm files can be uploaded straight away easily in Google Sheets for use.

Judging from posts in the forum about difficulty transporting data from reports into spreadsheets, just getting the data transferred successfully is probably the main concern for many users and maybe not so much how many steps it takes, but ofcourse fewer steps is always better

1 Like