When exporting data from the platform, you can do so from the product list, the dashboard, or via your output feed. PriceShape supports several file formats, giving you flexibility in how you work with your data. This article provides a detailed overview of each available export option.
File type | What it does: | What to use it for: |
CSV | Downloads a CSV file to your PC every time you click "Open feed". | Further processing in Excel. |
JSON | Opens a link to a JSON file that is automatically updated. |
|
XML | Opens a link to an XML file that is automatically updated. |
|
Google Shopping XML |
| Can be integrated into the Google Merchant Center |
Google Sheets | Creates a CSV file in Google Sheets that is automatically updated. | It can easily be accessed by sharing the link. |
CSV
CSV is a simple file format used to store tabular data, such as a spreadsheet or database. Each line in a CSV file corresponds to a row in the table, and the columns are separated by commas (or other delimiters like semicolons).
How to create a CVS file?
You can create a CSV file using any text editor or spreadsheet software like Microsoft Excel or Google Sheets. To create a CSV file, open a text editor or spreadsheet program, enter your data in rows and columns, and then save the file with a .csv extension. Make sure to separate each value with a comma.
EXCL/Excel
Excel is a spreadsheet program developed by Microsoft. It allows users to create, edit, and manipulate spreadsheets containing data in rows and columns. Excel files can have the extensions .xls or .xlsx.
How to create an EXCL/Excel file?
To create an Excel file, you typically use Microsoft Excel or a similar spreadsheet program:
Open Excel and input your data into the cells of the spreadsheet.
Once you have entered your data, you can save the file by clicking on "File" > "Save As" and selecting the desired format (.xls for older versions of Excel, .xlsx for newer versions).
JSON
JSON is a lightweight data-interchange format that is easy for humans to read and write and for machines to parse and generate. It is based on a subset of the JavaScript programming language.
How to create a JSON file?
JSON files can be created using any text editor.
Simply write your data in JSON format, which consists of key-value pairs separated by colons and items separated by commas. Remember to enclose the entire structure within curly braces
{}.Save the file with a .json extension.
XML
XML is a markup language that defines a set of rules for encoding documents in a human-readable and machine-readable format. It's designed to be self-descriptive and platform-independent.
How to create an XML file?
XML files can also be created using any text editor.
Write your data using XML tags, which consist of an opening tag, content, and a closing tag enclosed in angle brackets <>.
Save the file with a .xml extension.
Google Shopping XML
Google Shopping XML is a specific format of XML used for uploading product data to Google Merchant Center for use in Google Shopping Ads. It contains detailed information about products, such as their title, description, price, availability, and more.
How to create a Google Shopping XML file?
To create a Google Shopping XML file, you need to structure your product data according to Google's specifications.
Typically, this involves creating a root element <rss> containing <channel> and <item> elements for each product.
Populate the <item> elements with relevant product information such as title, description, price, and availability.
Save the file with a .xml extension.
Google Sheets
Google Sheets is a web-based spreadsheet application developed by Google. It allows multiple users to collaborate on and edit spreadsheets in real-time over the internet.
How to create a Google Sheets file?
To create a Google Sheets file, you need to use Google Sheets itself.
Open Google Sheets in your web browser and start a new spreadsheet.
Input your data into the cells of the spreadsheet.
Google Sheets automatically saves your work as you go, so there's no need to manually save the file.