Import and export data

Plaky supports CSV import and export, allowing you to bring in data from spreadsheets, migrate from other tools, and export your Board data for reporting. 

Import CSV data #

CSV import works the same way whether you’re creating a brand new Board from your file or adding data into an existing one. There are two steps when importing a CSV file: file setup and column mapping. The only difference is where you start.

Create a new Board from CSV #

Pour créer un nouveau tableau à partir d'un fichier CSV :

1. Cliquez sur le bouton + dans la barre latérale gauche
2. Survolez Nouveau tableau
3. Select Create from file
   
4. Upload a CSV file
5. Choose a delimiter
6. Toggle if your file has headers or not
7. Click Proceed
   

Now that you have imported your file, you can move on to mapping.

1. Select the destination group
   1. Create a new Item group
   2. Select a CSV column for group name
2. Map to which Board Fields you want to import the data from the CSV
3. Cliquez sur Terminer l'importation pour achever l'action

If the CSV column contains more columns than the allowed number of Fields on the Board (a limitation exists on the Free plan), you can map the CSV columns up to that limit, and additional column mapping will be disabled. If some column’s data is not that important for you, you can always choose to skip the mapping for that column by choosing the option None.

To import a CSV file to an existing Board:

1. Cliquez sur les trois points à droite
2. Select Import from CSV
   
3. Upload a CSV file 
4. Select the delimiter
5. Toggle if the first row should be headers
6. Select which column shows the Item name
7. Click Proceed to move on to mapping
   

Once the file is uploaded, you can proceed to map the columns.

1. Select the destination group
   1. Create a new Item group
   2. Select a CSV column for group name
2. Map to what Board Fields you want to import the data from the CSV (updateovati prema novom master fields feature-u)
3. Click on Finish import to complete the action

Format CSV requis #

• Plaky uses a comma as the default delimiter. However, you can change it to a tab, a pipe, a space, or a semicolon.
• If the file is not marked as having headers, the first row is treated as item data, and for CSV, column names are generic: Column 1, Column 2, etc.
• The maximum CSV file size is 10MB.

Remarques #

• If you don’t select which column defines the Item name, the first column from your CSV file will be used by default as the Item name.
• The maximum number of rows in the CSV file is 1001.
• Character limits within the app also apply to CSV files.
• A CSV file can contain up to 18 values for the Status field; any additional values will be skipped during the import.
• The maximum number of Item groups to import is 20; any additional Item groups will be mapped to the last Item group on the Board.
• The content of the CSV file does not need to be in English.
• You can upload only one CSV file to a Board at a time; a new CSV file can be uploaded only after the import of the first file is complete.
• Each Field on the Board can be mapped to only one column from the CSV (1 column = 1 Field).
• CSV columns containing letters or numbers can be mapped to textual fields. However, if you attempt to map textual columns to timeline, date, or number fields, they will be skipped during the import.

Export CSV data #

If you need to analyze your project progress, share information with stakeholders, or perform further data analysis, you can export a Board in CSV format in Plaky.  

Here’s how you can export a Board:

1. Open the Board you would like to export
2. Click on the three dots in the top right corner
3. Sélectionnez Exporter vers CSV

Choose the data to export. You can select if you want the following:

• Inclure le groupe d'éléments comme première valeur
• Contenir les noms de champs dans le fichier CSV
• Inclure les données du journal
• Inclure les liens éléments/sous-éléments
• Inclure les sous-éléments
• Export only visible data (Filters and Field visibility will affect the display)

Personnalisez l'exportation selon vos besoins. Toute vue de tableau (Tableau, Kanban, Gantt) peut être exportée au format CSV.

Click on Export to complete the action.

Le nom du fichier CSV aura le format suivant : boardName_viewName_date_time.csv.