All Collections
Manage your account
How to accommodate any CSV format with Apimio?
How to accommodate any CSV format with Apimio?
Written by Zahwa Nadeem
Updated over a week ago

In today's data-centric world, working with CSV files is a common task for businesses and individuals alike. Yet, handling diverse CSV formats efficiently can be a daunting challenge. This guide will walk you through the straightforward process of accommodating any CSV format using Apimio.

Steps to Accomodate any CSV Format With Apimio

Step 1: Begin by logging into your Apimio account.

Step 2: Locate the "Import CSV" option in the top right corner of the screen and click on it.

Step 3: Opt for the "Drag and Drop CSV File" method to upload your CSV file. Follow by clicking the "Next" button.

Step 4: In this step, you'll map your CSV attributes to Apimio attributes. Adjust the necessary attributes and, if needed, apply formulas.

Step 5: If you need to split, merge, or apply custom formulas, access the formula options via the dropdown menu in the "Formula" tab.

Step 6: For instance, if you have a discount offer, set the formula to "Calculate" and specify the discount amount (e.g., -10%) in the "With (e.g.)" field. The formula will be automatically applied.

Step 7: Click on "Save Template" to preserve your configuration.

Step 8: A popup will appear. Select additional options such as language preferences and other relevant settings. Then, save the template.

Step 9: Congratulations! Your template has been successfully created. This will save you the hassle of making repeated edits in tools like Google Sheets.

Did this answer your question?