How to export listing of all reports from QuickBase
I would like to export a list of all reprots in QB in order to perform a cleanup of used/unused reprots that I would hand out to users? Thanks in advance
Forum Discussion
To save a list of all reports to Excel (I had no issues, but you can test first using backup copy of your App)--
1. In QB, go to Settings>App Management>Manage Reports, place cursor at beginning of list (not the column headings) and hold your mouse down to select all rows and columns on the page.
2. It will highlight the selections (mine shows up as Blue color). I am using Windows 10, Chrome.
3. In Excel, Paste Special (as Text). It will place data into rows and columns.
4. Go back to QB and go to the next page of reports and repeat process.
5.When I paste into Excel, the first row's columns do not line up with remaining columns so I insert a cell to shift to right. After I line up columns, I type column headings into my Excel file.
Note: In Excel, your Last Used column will show blanks for reports where Used Count=0, and some Dates will not Format to Date when you Format Cells in Excel - Reason is QB has entered a period "." to abbreviate Feb to Feb. so Find/Replace the "." to delete the "." and your date will format in Excel.
1. In QB, go to Settings>App Management>Manage Reports, place cursor at beginning of list (not the column headings) and hold your mouse down to select all rows and columns on the page.
2. It will highlight the selections (mine shows up as Blue color). I am using Windows 10, Chrome.
3. In Excel, Paste Special (as Text). It will place data into rows and columns.
4. Go back to QB and go to the next page of reports and repeat process.
5.When I paste into Excel, the first row's columns do not line up with remaining columns so I insert a cell to shift to right. After I line up columns, I type column headings into my Excel file.
Note: In Excel, your Last Used column will show blanks for reports where Used Count=0, and some Dates will not Format to Date when you Format Cells in Excel - Reason is QB has entered a period "." to abbreviate Feb to Feb. so Find/Replace the "." to delete the "." and your date will format in Excel.