Back to
Products / Inventory

How to export information from Nex to Excel (XLS)

It is possible to export various information present in Nex to an Excel file in XLS format.

Important

  • It is often possible to create filters and subfilters of the information that is appearing in Nex. The export procedure will take into account the way the information appears on the screen. Click here and see how to use filters in Nex.

Shall we learn how to export information to an Excel spreadsheet?

1. Go to the Nex screen where you want to export the information. Here we will export the PRODUCTS list.

‍2. Click on the ARROW icon next to the search field, then go to LAYOUT and click on ADD/REMOVE COLUMNS.

3. Check the information you need to export about your products.

The deselected information will be momentarily removed from the screen and ignored on export, but you can select it again later.

4. Click on the THREE DOTS (...) in the upper right corner and select EXPORT.

You can also export using the keyboard shortcut, just press the SHIFT + F5 keys at the same time.

5. Choose the NAME and LOCATION to save the file and click on SAVE.

Done! The information selected in Nex was exported to an Excel spreadsheet in the chosen location.

Extra: If you need, it is also possible to PRINT the products list directly from Nex. Click on the THREE DOTS (...) icon and select PRINT.

See also:

Fale com nossos atendentes!

para clientes PRO e PREMIUM, inclusive "em teste"
INICIAR CHAT
para clientes FREE (grátis)

Links úteis:

Onboarding

  1. Controlar Estoque
  2. Venda Caixa (venda comum)
  3. Cadastrar Cliente
  4. Formas de Pagamento
  5. Troca ou Devolução
  6. Impressão de Etiquetas
  1. Primeros Passos: Vendas, Estoque, Clientes, Caixa, Débitos e Formas de Pagamentos
  2. Conheça Melhor: Vendas, Estoque, Clientes, Caixa, Débitos e Formas de Pagamentos

1. How to Start

Sales, stock control, customer registration, register...

2. Next Steps

Backup, Parked Sales, loyalty system, change currency and more...

3. Everything

Print templates, printing labels, commission report and more...

Todas as Categorias

Lista completa de Tutoriais

See more Tutorials of  

Products / Inventory

How to enable a product registration

See how simple and practical it is to enable a disabled product. This way, you can start selling a product that was previously registered but inactivated.

How to enable the advanced search

In this tutorial you will learn how to activate the advanced search to be able to search for a product by any word in its name.

How to delete product registration

See how to delete a product on Nex.

How to register a shipment return

See how practical it is to register the return of a shipment on Nex.

Learn more about shipment transactions

See what they are and what types of shipments can be registered on Nex.

How to register a demo shipment

Need to send your products to a fair or exhibition? See how easy it is to register a shipment for demonstration using Nex.

How to register a repair shipment

See how quickly it is to create a shipment record for repair using Nex.

How to register an output transaction via other outputs

See how quickly it is to record an stock transaction like other outputs.

How to register an output transaction for gift

See how practical it is to register the delivery of a gift via Nex, without cash handling.

How to register a return to supplier transaction

See how simple and practical it is to register a return to the supplier.

Learn more about output stock transactions

Check which different types of output stock transactions can be carried out in Nex.

Learn more about input stock transactions

Check which different types of stock input transactions can be registered in Nex.

How to register a stock input adjustment

The stock intput adjustment can be very useful to correct input records and maintain Nex always updated.

How to register a stock output adjustment

The stock output adjustment can be very useful to correct output records and maintain Nex always updated.

How to configure to not allow sale of out-of-stock products

See how to configure Nex so that you don't allow the sale of out-of-stock products.

How to register a stock transaction by other outputs using Nex on the Web

See how simple it is to record the stock output of a product consumed on a daily basis in your store using Nex on the web.

How to register an output transaction for internal use and consumption using Nex on the Web

See how simple it is to record the stock output of a product consumed on a daily basis in your store using Nex on the web.

How to register a return to supplier transaction from Nex on the web

See how simple and practical it is to register a return to the supplier using Nex on the web.

How to register a stock output adjustment using Nex on the web

The stock output adjustment can be very useful to correct output records and maintain Nex always updated.

How to register a stock input adjustment using Nex on the web

The stock input adjustment can be very useful to correct entries records and maintain Nex always updated.

How to record a purchase transaction (stock purchase) through Nex on the web

Understand the importance of registering your purchases and the means to do so through Nex on the web.

What to do when there are products not appearing on the sales screen?

In this tutorial you will see what to do to show all products on the sales screen. There is a filter that allows you to show or not show products that have no more stock available in their registry.

How to configure the product to allow changing the price at the moment of the sale

See how to configure product registration so that you can change the price at the time of sale.

How to activate stock control

This tutorial shows how to activate the stock control on the product registration. It allows you to control the product inputs and outputs on Nex.

How to check and print product inventory

See how to print a list of your products, along with the quantity in stock of each item.

How to create a transaction of transfer between stores - Stock Input

See how to carry out a stock input transaction from a transfer between stores in Nex.

How to create a transaction of transfer between stores - Stock Output

See how to carry out a stock output transaction from a transfer between stores in Nex.

How to generate the sales price by markup percentage

See how you can generate the sales price based on the cost price through markup percentage.

How to clear the available stock of all products

Find out how to reset the available stock of all products, in a practical way, keeping track of your products.

How to check and print the products stock

See how to check and print a list of your products, along with the stock quantity of each item. It is useful to count the inventory.

How to link a supplier to the product

See how simple it is to link a supplier to your products and improve your stock organization.

How to configure the product to not control stock

See how to configure Nex not to control product stock.

How to record a purchase transaction (stock purchase)

Understand the importance of registering your purchases and the means to do so through Nex.

How to configure minimum and maximum stock limits

See how simple it is to set the minimum and maximum inventory for each of your products in Nex.

How to filter products with stock below the minimum

See how to filter all products that have stock below the registered minimum stock.

How to adjust the price of products by percentage (%)

See how practical it is to adjust the price of certain products by a percentage value.

How to round prices

In this tutorial you will learn how to massively round the cost and sale prices of all the products registered on your Nex.

How to access the stock transactions tab

Learn how to access the Stock Transactions screen and check product movement records.

How to control the expiration date of a product

See how simple it is to control the expiration date of your products with Nex.‍

How to allow registration of products with the same code

See how to configure it to allow the registration of two or more products with the same code.

How to configure automatic code creation when registering a product

Find out how to configure it so that your product code is generated automatically.

How to set a default markup for products prices

See how simple and practical it is to define a standard markup that can be used to automatically generate the selling price of products based on the cost price.

How to generate a purchase suggestion

See how Nex can help you check how many and which products need replacement.

How to show only products currently available in stock when selling

See how to configure Nex to only show products with available stock at the moment of the sale.

How to readjust the prices massively

In this tutorial you will learn how to massively alter the cost and sale prices of all the products registered in the stock that do not have the markup option activated on its register.

How to set a promotional price

See how practical it is to set a promotional price on a Nex product.

How to disable products

See how easy it is to disable that product that you no longer sell on Nex. This tool can be used when the program does not allow deleting the product.

How to create a bundle

See how practical it is to create a Bundle on Nex, increasing your sales possibilities by combining different products in a single combo.

How to register a product and stock

See how to register a product to start controlling your store's inventory.

How to configure a product to calculate the profit

See how easy it is to configure your products, allowing the system to calculate profit when they are sold.

How to change the current stock by product registration

See how simple it is to change the current stock of a product through the product registration.

How to clone a product registration

See how to clone a product, generating a second product identical to the one previously registered on Nex.

Nextar POS Software
‍www.nextar.com