Now with the Excelify app, you can customize your export to specify what columns to export and in what order!
Let’s go through how you can do that!
1. Creating new Shopify data export
Go into the Excelify app and in the Home page Export section press the “New Export” button.
The app will open a new page where you can set up and configure your export.
2. Select the data export format
First section of the new export is selecting your export format.
Click on the dropdown menu to select your preferred format.
Adjustable columns are available in both Excelify formats:
- Excelify: Excel – exports to Excel XLSX file
- Excelify: CSV – exports to CSV file
Select one of these formats.
3. Choose what to Shopify data to export
In the next section, you can select checkboxes of what to export, for example, I will select to export the Shopify Products.
You can also select and the same way adjust other exportable entities, such as Orders, Collections, etc.
4. Customize Shopify columns to export
Now is time to select exactly what data to export from Shopify and customize it.
You can see two tabs available under the entity selection “Simple” and “Advanced“.
Both tabs work together, so if you select a group of fields in the Simple tab, then those fields will be visible in the Advanced tab, and the same the other way around.
The “Simple” tab allows you to select groups of fields you might wish to export.
You can find what fields are under each group in Excelify template sheets documentation.
Selecting a group will display how many columns are under this group.
The advanced tab allows you to select, remove individual columns, or change their positions.
If you have any groups already selected in the Simple tab than you will see all those fields in this tab.
You can also see all available fields, including from different groups, by pressing on the “Add | Remove” button which will open drop-down of all fields.
You can add or remove fields by checking or unchecking them in this dropdown, or you can click on the field tags “X” button to remove it.
To change exported field order you can drag the columns by the 6-dot symbol of each field.
5. Start the export
Once you have selected columns you wish to export, you can click on the “Export” button to start the Export.
While export is going you will see the progress of how many items are exported and estimated time remaining to finish.
At this stage, you are free to close your browser as everything is happening on our servers.
6. Download and enjoy your export
One the export is finished, click on the “Download exported file” to download your custom file.
What to do next?
- Read Excelify “How it works” page to learn other important aspects and features of the Excelify app.
- Reach out to us if you have any questions!