Brainscape supports "importing" a .csv file for more rapid flashcard creation. These files are typically created in a spreadsheet program such as Microsoft Excel or Google Sheets or Numbers, where the creator clicks "Save As → CSV".
To import a .csv file, visit the Brainscape website, and navigate to your Class on the My Classes screen. Then click the Import button at the top of the Decks list. You will be asked a few questions about the desired Deck's information, and you will be asked to upload a valid .csv file before submitting. Additionally, you can click on the ellipsis at the top of the class screen and choose ‘Import CSV’ from the dropdown. This advanced functionality is currently available for free with your regular subscription.
Tips for preparing your .csv file
To ensure your .csv file is valid, and not rejected by our system, please follow the guidelines below:
- Include only two columns -- Question and Answer -- with no headings row In it
- Ensure there are not more than 500 rows in the sheet you are importing
- Make sure there are no "stray marks" in any additional columns or rows in the file, besides the rows and columns that you want for your flashcards. It may help to highlight all other rows and columns in your spreadsheet program, and delete them
- Avoid copying and pasting content from a web browser or another program (such as Microsoft Word) directly into your spreadsheet. That often brings in funky formatting like "smart quotes" (i.e. curly quotation marks) which are not recognized by web technology. If you have already created content using such a copy/paste method, then try either "removing formatting" (in your spreadsheet program) and/or saving in a .txt file and then re-pasting back into your spreadsheet program
- If you wish to create flashcards with ¡spéciål cháractérs! (e.g. for foreign languages), then you cannot create your CSV file from Excel. (Blame Microsoft, not us!) You must use either:
- Google Sheets
- OpenOffice -- a free open source spreadsheet program that you can download on the internet. When you select Save As CSV in OpenOffice, be sure to check the box "Edit Filter Settings." Then choose character set UTF-8."
- Go to “File → Save As → CSV”, and then they can import those files into Brainscape.
Still have questions and can't find the answer? Be sure to email our Tech Support Team (firstname.lastname@example.org), or join our Discord channel where you can discuss all things learning, meet others studying for the same exams, and upvote features you'd like to see us add to our tool.
And for more FREE study advice don't forget to check out the Brainscape Academy.