How to export data from Magnetic

Magnetic has the ability to export your valuable data into easy to use formats.

You are able to export the following information:  

• Contacts / companies
• Opportunities
• Jobs
• Tasks 
• Users
• Item Types
• Accounts

The method for exporting data is the same throughout the system with one exception. Some exports can only be done by users with the Admin role. For example, exporting or importing users can only be performed by the Admin role.

Let's export all the tasks associated to a job as an example.

Follow these steps to export :

1. Click on Jobs from the left hand navigation menu
2. Once the list loads, find the job you want and click on it to open and go to the dashboard
3. Scroll down to tasks - This will show a list of tasks associated with that job.:

4. If you wish to manage the columns prior to the export, and select what you would like to include in the export of your data by clicking the right icon. Fields in bold will be included in your export.
   
   

5. Then click on the icon on the left, and select the format which you want the export to be. (PDF, CSV, or Excel)
   

6. Once downloaded, you can open your file in your application of choice.

Please note: If you exported a CSV file, you can still open it as an Excel spreadsheet.

See this link: http://blogmines.com/blog/how-to-import-text-file-in-excel-2013/

Steps to follow to change a CSV file into an Excel spreadsheet: 

1. Export data as a CSV file.
2. Open the CSV file as Excel spreadsheet.
3. Select column A.
4. Click on the Data tab.
5. Select "Text to columns".
6. Select "Delimited".
7. Select "Comma".
8. Click on "Finish".
9. Your text should now be organized in columns.