---
title: Learning Sage X3- Day 8 of 14- How to Export Data from Sage X3
description: Exporting from data Sage X3
---

[RKL eSolutions | Technology Insights, Tips and Trends ](https://www.rklesolutions.com/blog)

# [Learning Sage X3- Day 8 of 14- How to Export Data from Sage X3](https://www.rklesolutions.com/blog/export-data-sage-x3)

 Written by [Devin Cenekofsky](https://www.rklesolutions.com/blog/author/devin-cenekofsky) | Nov 7, 2017 9:13:57 AM

This is the eighth lesson in the series [**Learning Sage X3**](https://www.rklesolutions.com/sage-erp-x3/system-requirements). As I was learning Sage X3, I came across a lot of users wanting to know how to get data out of Sage X3, so this lesson will cover how to export data from Sage X3. In this example, I picked the Products table because clients often want to do a cleanup of things related to the Product master or they want to export it to provide it to their customers or vendors.

1. Go to Usage: Imports/Export templates
2. Choose a template (For example, ITM)
3. Uncheck Chrono Management box
4. Choose whether to create the file on the server or the client. The selection determines where the data file path is located on the Sage ERP X3 Application server or on the client that is running the Export.
5. Click OK

Choose the location of the export file you are creating

The above was simply running an existing Export Template. To create an Import/Export template, go to Set up > Usage > Import/Export template. I will cover some of the tasks and window fields at a high level. You can find all of this information in the Help system.

A good practice to remember is if you create anything new or modify an existing Sage X3 function to use the Activity Field code. This helps you identify changes as well as prevent them from being overwritten by a future patch.

This same procedure will work for any left list.

## Stay Tuned for Lesson 9

This is the eighth post in Learning Sage X3. The next post (Lesson 9) will review, **How to Print a Report in Sage X3** will post on November 14th, 2017. Other lessons in this series can be viewed at:

**[Lesson 1 of 14 - Important Acronyms and Definitions](https://www.rklesolutions.com/blog/sage-x3-acronyms-definitions/)**

**[Lesson 2 of 14 - General Navigation and User Interface](https://www.rklesolutions.com/blog/x3-navaigation-user-interface/)**

**[Lesson 3 of 14 - Sage X3 PU 11](https://www.rklesolutions.com/blog/overview-of-sage-x3-product-update-11/) **

**[Lesson 4 of 14 - Setting up Chart of Accounts](https://www.rklesolutions.com/blog/sage-x3-chart-accounts-overview/)**

**[Lesson 5 of 14 - Sage CRM for X3](https://www.rklesolutions.com/blog/sage-x3-crm/)**

**[Lesson 6 of 14 - How to Add a Custom Report](https://www.rklesolutions.com/blog/custom-report-sage-x3/)**

**[Lesson 7 of 14 - How to Add a Column to a Left List in Sage X3](https://www.rklesolutions.com/blog/left-list-column-sage-x3/)**

### **Need Help with Learning Sage X3? **

Contact us if you have more in-depth question or want to **Learn Sage X3** or to request help with your system.

[Contact RKL eSolutions](https://www.rklesolutions.com/contact-us/)

[View full post](https://www.rklesolutions.com/blog/export-data-sage-x3)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Devin Cenekofsky"
  },
  "dateModified" : "2023-05-11T17:20:45.042Z",
  "datePublished" : "2017-11-07T09:13:57Z",
  "headline" : "Learning Sage X3- Day 8 of 14- How to Export Data from Sage X3",
  "image" : {
    "@type" : "ImageObject",
    "height" : 60,
    "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
    "width" : 60
  },
  "mainEntityOfPage" : "https://www.rklesolutions.com/blog/export-data-sage-x3",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60.0,
      "url" : "https://www.rklesolutions.com/hubfs/RKL%20Logos/0001-5330483477089761811-1.png",
      "width" : 236.84212
    },
    "name" : "RKL eSolutions "
  }
}
```