Exporting the Current Grid View to Excel

Export Current Grid View to Excel lets you send the products and columns you see in the Product Grid straight to an xlsx file in one click. It removes the manual attribute-mapping step from routine exports, so you get a file that matches the view you built.

This guide explains what Export Current Grid View to Excel does, how to set it up, and how to use it effectively.

What Is Export Current Grid View to Excel?

Export Current Grid View to Excel is an export option in the Product Grid that exports only the attributes shown, in the order the grid shows them, to a native Excel (xlsx) file. This is especially useful when:

• You regularly export the same filtered or saved view and don't want to re-map attributes each time.
• You need the exported columns in the same order as your on-screen view.
• You want to share a clean subset of product data with colleagues or third parties.
• You want product thumbnails to appear in the exported file.

Instead of mapping every attribute by hand on the Export Product Data screen, Pimberly now exports your current view in one step.

How It Works

1. Build the view you want in the Product Grid using facets, categories, or a simple or complex search (saved searches work too).
2. Select Export from the Product Grid navigation bar and choose your products.
3. Turn on the Export Current View to xlsx toggle and select Next.
4. Pimberly generates an xlsx file containing only the attributes shown, in the grid's order.
5. Where the Thumbnail column is shown, the image is rendered in-cell using the =IMAGE(url) formula, sized to 100 x 100 pixels, with the row height set to 100 to fit.
6. Media set columns export as a list of the underlying asset URLs, not the "assets" count shown in the grid.

Export Current View to xlsx is available for views of up to 10,000 products.

Setting Up Export Current Grid View to Excel

Step 1 — Build your view

1. Open the Product Grid.
2. Use facets, categories or search to filter to the products you want.
3. Add, remove and order the columns so the grid shows exactly the attributes you want to export.

Step 2 — Export the current view

1. Select Export from the Product Grid navigation bar.
2. Choose whether to export your selected products or all products in the current view.
3. Below Filtered Products, turn on the Export Current View to xlsx toggle (off by default).
4. Select Next. Pimberly generates and downloads the xlsx file.

If you leave the toggle off and select Next, you continue through the existing Export Product Data workflow as before.

Using Export Current Grid View to Excel

Once your view is set, exporting is a single action you can repeat whenever you need it:

• The export reflects the grid at the moment you run it, including filters and column order.
• Save the view as a saved search so you, or a colleague, can return to it and export again.
• Open the xlsx in Excel to filter, format or share without further setup.

Best Practices

• Order your columns before exporting — the export uses the on-screen order.
• Save frequently used views as saved searches to avoid rebuilding them.
• Keep the Thumbnail column in the view if you want images to appear in the file.
• Check large exports open as expected before sharing externally.

Troubleshooting

The export is missing columns or the order is wrong

• Confirm the columns are shown in the Product Grid before exporting — only visible attributes are included.
• Reorder the columns in the grid, then run the export again.

Thumbnails are not showing in the file

• Make sure the Thumbnail column is shown in the view before exporting.
• Confirm your spreadsheet application supports the =IMAGE() formula and that image URLs are accessible.
• When you first open the file, thumbnails may not load until you enable content in Excel and recalculate. Press Ctrl/Cmd + Option/Alt + Shift + F9 (add Fn on some keyboards) to recalculate the formulas.

I can't see the Export Current View to xlsx toggle

• Check you are on the Export step, below Filtered Products.
• Check your current view contains 10,000 products or fewer. The option is available for views up to this size.

Need Help?

If you have questions or your workflow requires a more advanced configuration, please contact Pimberly Support or speak to your Customer Success Manager.