# Is it possible to create a deck from an Excel spreadsheet
**URL:** https://forums.ankiweb.net/t/is-it-possible-to-create-a-deck-from-an-excel-spreadsheet/3394
**Category:** Help
**Created:** [September 15, 2020, 6:01am UTC](https://forums.ankiweb.net/t/is-it-possible-to-create-a-deck-from-an-excel-spreadsheet/3394 "2020-09-15T06:01:10Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@djoliver920](https://forums.ankiweb.net/u/djoliver920)
#### Post date: [September 15, 2020, 6:01am UTC](https://forums.ankiweb.net/t/is-it-possible-to-create-a-deck-from-an-excel-spreadsheet/3394/1 "2020-09-15T06:01:10Z")
Hi: I’m learning German and I’ve got a 2,000 row Excel spreadsheet with 3 columns: German word; English translation; Notes. I’d like to know if it’s possible to load this into anki and automatically create a simple deck with 3 fields: Question: German word; Answer: English word(s); Notes. It seems like many people could benefit from such an add-on loading tool. Is anyone aware of one? Thanks in advance for any suggestions!
---
### Author:  [@guillempalausalva](https://forums.ankiweb.net/u/guillempalausalva)
#### Post date: [September 15, 2020, 8:00am UTC](https://forums.ankiweb.net/t/is-it-possible-to-create-a-deck-from-an-excel-spreadsheet/3394/2 "2020-09-15T08:00:54Z")
You would need to create a custom note type with 3 fields then import from a text file which you can generate by exporting the Excel file as csv.
---
### Author:  [@djoliver920](https://forums.ankiweb.net/u/djoliver920)
#### Post date: [September 15, 2020, 2:57pm UTC](https://forums.ankiweb.net/t/is-it-possible-to-create-a-deck-from-an-excel-spreadsheet/3394/3 "2020-09-15T14:57:30Z")
thanks for answering. I’m very new to this, so please bear with me. are you saying that the standard, default question and answer fields can’t be used. all 3 fields would have to be custom note type fields?
then I’d need to export the Excel file to a csv and import the csv into anki? What are the exact steps involved? 1. create an empty deck? 2. create three custom note fields in that deck? 3. export Excel to csv file. 4. import csv into deck. Do you think it would work?
---
### Author:  [@dae](https://forums.ankiweb.net/u/dae)
#### Post date: [September 16, 2020, 12:19am UTC](https://forums.ankiweb.net/t/is-it-possible-to-create-a-deck-from-an-excel-spreadsheet/3394/4 "2020-09-16T00:19:04Z")
If you wish to use the existing Front/Back fields you can do that. The important point is to set up the number of fields that matches the file you want to import. Don’t be afraid to experiment - you can create a separate profile from the File menu to play around in.
---
### Author:  [@djoliver920](https://forums.ankiweb.net/u/djoliver920)
#### Post date: [September 16, 2020, 6:17am UTC](https://forums.ankiweb.net/t/is-it-possible-to-create-a-deck-from-an-excel-spreadsheet/3394/5 "2020-09-16T06:17:42Z")
thanks. I’ll do that.
---
### Author:  [@system](https://forums.ankiweb.net/u/system)
#### Post date: [May 1, 2023, 5:31am UTC](https://forums.ankiweb.net/t/is-it-possible-to-create-a-deck-from-an-excel-spreadsheet/3394/6 "2023-05-01T05:31:12Z")