...
Description: In In this topic you , the user will learn how to export and download entries into Excel from the Entries entries table into Excel.This This allows the user to total the units using the sum formula in Excel.
Role Required: Employee (base user)
Permission Required: N/A
Export/Download Entries Table
- Log in to
...
- personal profile
- Select Entries from the submenu
- Use the filters to
...
You can also leave the table unfiltered and use filters in Excel (see the Excel Help Tutorials in the Videos section).
...
- locate specific entries and click Search OR click the Export button to download the table to a CSV
...
- file and use Excel filters to locate specific entries
- The name of the document will be the date,
...
- ID number, and a brief description of the table (
...
- e.
...
- g.
...
- , 06012023-
...
- 14558-puncheslist.csv)
...
It will most likely be saved in your computer’s Downloads folder.
...
- Locate the document in the computer's Downloads folder
- Open a blank Excel document and click cell A1
...
...
- Click the
...
- Data
...
- tab
...
...
- Click
...
- From Text
...
...
- /CSV
- Locate the exported file and click Import
9. On the Text Import Wizard, click Finish.
10. Click OK.
...
- Click Load
- Use the sum formula to
...
- determine the total of the units
See the article How do I download/export, sort, filter, and sum data in Microsoft Excel in the Help Center for more information. (see the Excel Help Tutorials in the Videos section).You can also highlight the entries table and then copy and paste it into a blank Excel document.
Related articles
Content by Label | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...