📝 Overview
Learn how to export database information from the software using the Export tool. Each selection is saved as its own tab-delimited (.txt) file that can be opened in Microsoft Excel.
🛠️ Exporting Database Information
Your software has the ability to export many tables in the database using the Export function.
⚠️ Please Note: To open the exported file in Excel, use Excel's import feature (Data > From Text/CSV) and select Tab as the delimiter to ensure data displays in the correct columns.
⛔ Disclaimer: The Export function is accessed through the Tools menu. If you do not see this option, contact your account administrator to confirm your user permissions.
Select the Tools pull-down menu then click Export to Text File.
On the Export Database Information to a File screen, select the data that you would like to export. Each selection will be saved as its own text (.txt) file.
Click Export. You will be prompted to select a file name and location for each file. These files are tab-delimited text files and can be opened with Microsoft Excel.
❓ Frequently Asked Questions (FAQs)
Find answers to common questions, edge cases, or additional details that may not be covered in the main instructions.
What file format does the export produce?
Click the arrow to view the answer
Click the arrow to view the answer
Each exported table is saved as its own tab-delimited text (.txt) file.
Can I open the exported file in Excel?
Click the arrow to view the answer
Click the arrow to view the answer
Yes. If columns don't display correctly when opening the file, use Excel's Data > From Text/CSV import option and select Tab as the delimiter.
Can I export multiple tables at once?
Click the arrow to view the answer
Click the arrow to view the answer
Yes. On the Export Database Information to a File screen, you can select multiple tables. Each will be saved as its own separate .txt file.
Where is the exported file saved?
Click the arrow to view the answer
Click the arrow to view the answer
When you click Export, you will be prompted to choose the file name and save location for each file.
Who can access the Export function?
Click the arrow to view the answer
Click the arrow to view the answer
Access depends on your user permissions. If the option is unavailable, contact your account administrator.