Attention: This guideline only relates to the import function of CSV/Excel-Files for creating an "unsynced" Depot. If several "Exchange" depot offers a CSV/Excel import as well, a different guideline needs to be followed.
- Click the menu item Depots in your Blockpit account.
- Click on the button Add Depot.
- Insert a Depot Name.
- Click on the button Add Transaction in the created Depot and select CSV/Excel-File.
- For a correct implementation, CSV/Excel files must have a certain structure. Therefore download the displayed Excel template. Enter your data according to the table template. Use Microsoft Excel or Google Spreadsheets to open the file. Both programs will show you the supported transaction types and the mandatory fields. It's important that all required fields are filled with data, otherwise, an error will occur during upload. In the figure below, you can see the required fields for each transaction type.
- Save the filled table as a .xlsx file (Excel format) or as a CSV file. We recommend saving it as a .xlsv file. In case you save the file as CSV, use a semicolon; as a separator.
- Upload your CSV/Excel file by clicking the Browse button or by dragging the file into the window.
- In the next step, the uploaded file will be displayed and you can click on the button Process File.
- In the next step, you have the possibility to double-check the automated currencies and their assigned currency. If there are any discrepancies, please correct the appropriate currency and click on the Submit button.
- If the CSV/Excel file as well as the currency assignment does not contain any errors, the transactions will be entered into the securities account. Otherwise, you will receive an error message - in this case, check if your data matches the Excel template and repeat the process starting from step 4.
For splitting your CSV/Excel data into multiple columns, this GUIDE can help you!
Why does the upload not always work?
Common reasons for errors that block an upload are:
- Wrong date format: Select the whole column H and format all cells as follows:
Microsoft Excel: Right click -> Numbers -> User-defined -> DD.MM.YYY hh:mm:ss
Google Sheets: Select "Format" -> Number -> Date/Time from the menu bar.
- Wrong decimal separator: Only use "dot" as decimal separator.
- Blanks: Blanks/Spaces have been used in columns B-F. Use the "Search and Select" function of your spreadsheet program to display invisible blanks/spaces.