FAQ – How can I edit the exported data?
You may edit and complement it just as you like and then re-import it to card2brain.
In the process, there are a few things you need to pay attention to – here goes the most important information:
Google Drive:
![](https://i.embed.ly/1/image?url=http%3A%2F%2Fcard2brain.ch%2Fdocs%2Farticles%2Fexport%2Fen%2Fsupport_import_gdrive_part1.png&key=afea23f29e5a4f63bd166897e3dc72df)
Open Google Drive in your browser und create a new spreadsheet.
![](https://i.embed.ly/1/image?url=http%3A%2F%2Fcard2brain.ch%2Fdocs%2Farticles%2Fexport%2Fen%2Fsupport_import_gdrive_part2.png&key=afea23f29e5a4f63bd166897e3dc72df)
Now, go to "File" > "Import". This opens the import dialog.
![](https://i.embed.ly/1/image?url=http%3A%2F%2Fcard2brain.ch%2Fdocs%2Farticles%2Fexport%2Fen%2Fsupport_import_gdrive_part3.png&key=afea23f29e5a4f63bd166897e3dc72df)
Click on "Choose File" and select the .csv file you exported from card2brain.
In the “Import action” section, you can decide for yourself: Selecting “Create new spreadsheet” will create a new file. With the "Replace spreadsheet" option, the data will be inserted into the currently open spreadsheet.
Finally, you can choose "Comma" as a separator character and then click on "Import".
![](https://i.embed.ly/1/image?url=http%3A%2F%2Fcard2brain.ch%2Fdocs%2Farticles%2Fexport%2Fen%2Fsupport_import_gdrive_part4.png&key=afea23f29e5a4f63bd166897e3dc72df)
If you want to re-import the modified data back to card2brain, you have to download them as .csv file.
"File" > "Download as" > "CSV (current sheet)"
Excel:
![](https://i.embed.ly/1/image?url=http%3A%2F%2Fcard2brain.ch%2Fdocs%2Farticles%2Fexport%2Fen%2Fsupport_import_excel_part1.png&key=afea23f29e5a4f63bd166897e3dc72df)
Create a new file in Excel.
Now, go to the "Data" tab and select "From Text" in the "Get External Data" group.
![](https://i.embed.ly/1/image?url=http%3A%2F%2Fcard2brain.ch%2Fdocs%2Farticles%2Fexport%2Fen%2Fsupport_import_excel_part2.png&key=afea23f29e5a4f63bd166897e3dc72df)
Excel then opens the Import Wizard.
Select "Delimited" as data type.
Start import at row: 1
Set the "File origin" to "65001: Unicode (UTF-8)".
Now, click on "Continue".
![](https://i.embed.ly/1/image?url=http%3A%2F%2Fcard2brain.ch%2Fdocs%2Farticles%2Fexport%2Fen%2Fsupport_import_excel_part3.png&key=afea23f29e5a4f63bd166897e3dc72df)
Choose "Comma" from the "Delimiters".
The "Text qualifier" has to be set as a (") (quotation mark).
Next, click on “Continue”.
![](https://i.embed.ly/1/image?url=http%3A%2F%2Fcard2brain.ch%2Fdocs%2Farticles%2Fexport%2Fen%2Fsupport_import_excel_part4.png&key=afea23f29e5a4f63bd166897e3dc72df)
You can keep the "Standard" setting in "Column data format".
Then click on "Complete".
![](https://i.embed.ly/1/image?url=http%3A%2F%2Fcard2brain.ch%2Fdocs%2Farticles%2Fexport%2Fen%2Fsupport_import_excel_part5.png&key=afea23f29e5a4f63bd166897e3dc72df)
If you want to re-import the modified data back to card2brain, you have to save it as .csv file.
"Data" > "Save as" > Choose any file name and set the file type to "CSV (character-separated) (*.csv)"
OpenOffice:
Go to "File" > "Open". Select the .csv file exported from card2brain.
OpenOffice will automatically open the import screen.
![](https://i.embed.ly/1/image?url=http%3A%2F%2Fcard2brain.ch%2Fdocs%2Farticles%2Fexport%2Fen%2Fsupport_import_oo_part1.png&key=afea23f29e5a4f63bd166897e3dc72df)
For the data to be imported correctly, you have to choose the following settings:
Character set: Unicode (UTF-8)
Language: Default
From row: 1
In the Separator options, select "Separated by" and tick "Comma". The Text delimiter has to be a " (quotation mark).
Complete importing by clicking on "OK".
![](https://i.embed.ly/1/image?url=http%3A%2F%2Fcard2brain.ch%2Fdocs%2Farticles%2Fexport%2Fen%2Fsupport_import_oo_part2.png&key=afea23f29e5a4f63bd166897e3dc72df)
If you want to re-import the modified data back to card2brain, you have to save it as .csv file.
"Data" > "Save as" > Choose any file name and set the file type to "CSV (character-separated) (*.csv)"