Import CSV Files
Learn how to import CSV files to create Zuora object instances, including saving CSV files in the correct format using Microsoft Excel on Mac OS.
If you are using Microsoft Excel on Mac OS, you must save the .csv file in MS-DOS Comma Separated (.csv) format.
To import a CSV file to create Zuora object instances:
- In the General tab, click Download to download the template as a CSV file.
- Complete the columns in the downloaded template. For the explanation for each column, see Template Fields for more information.
-
Complete the following settings in the
General
tab:
-
In the
Advanced
tab, complete the following fields:
-
If you selected
Scheduled
for the
Execution
field, complete the scheduler settings in the
Schedule
tab.
- Select the time zone from the Timezone drop-down list. Zuora strongly recommends you to select the same time zone as for your Zuora tenant to avoid payment errors.
- In the drop-down list next to Timezone , select the time frame of the schedule and complete the details of the selected time frame. The Timezone field and schedule builder are used to set how frequently the data is synchronized. It is recommended to set a Daily schedule and align the timezone to your Zuora tenant, which can align operations and ensure the app displays the latest data. The Interval field displays the specified schedules as a Cron expression and needs no further configuration.
- Click Create .