Skip to main content
Troubleshooting your CSV import

Follow a few simple steps to get your CSV ready for mass uploads.

Jimmy Mooring avatar
Written by Jimmy Mooring
Updated over 2 months ago

Contents πŸš€



Introduction πŸ‘‹


Our bulk upload and create functions are great ways to execute mass actions for your contracts. The process is anchored in your CSV, which will contain the data points that populate the contracts in Juro.

If you have problems opening CSV files in Excel, the steps outlined in this article will have everything ready for upload in no time.

πŸ’‘ NOTE: Password-protected documents cannot be uploaded into Juro using the Bulk upload feature.


Step 1️⃣ Creating your upload 🎨


Once you've downloaded the Juro CSV sample to your desktop:

1. Starting with a blank workbook in Excel, go to the Data tab, select Get Data and then From Text and select the Juro CSV sample.


Step 2️⃣ Delimiting your Excel file πŸ‘


To delimit your Excel file:

1. Select Delimited > Next, check the Semicolon and Comma delimiters and click Finish.

2. In the Import Data pop-up, leave the default value unchanged and press OK.


Delimiting your MacOS Numbers file πŸ”©


If you're using Numbers instead of Excel:

1. Click File > Export to > CSV. From the Text Encoding dropdown, select Unicode (UTF-8)

2. Select Next and specify the file destination.


Managing special characters in CSV files πŸ”£


If your CSV upload contains special characters (e.g. !, @, #), you must save it as a UTF-8 file. To do this:

  1. Click Save as.

  2. From the file format dropdown, select CSV UTF-8 (Comma-delimited)(.csv).

  3. Select Save.

πŸ’β€β™€οΈ As always, our Support Team is happy to help you with anything further if needed. Start a chat with us right here by clicking the Intercom button in the bottom-right-hand corner of this page.

Alternatively, you can email your query to support@juro.com.

Did this answer your question?