Hello,
I’m a beginner with Strapi and I need to import data in bulk from CSV/XLS files. Can anyone guide me on how to set up this functionality for importing large datasets efficiently?
Any help or examples would be greatly appreciated!
Thanks in advance!
That’s also a bit of an issue for me, I’ve got my data organised in a large Excel file. At the moment I export individual sheets (column names matching the field names in strapi) as csv files.
I’ve written a very simple converter that turns them into json files with the required structure, examples of which can be generated by exporting existing data from your strapi instance and then make sure that your generated json structure matches it.
Then I import that file using the import/export plugin (I’m still on strapi 4, in version 5 there is a newer version of the pluigin that doesn’t work though, unfortunately without error message indicating what is wrong).
There might be more streamlined approaches that I’m not aware of, so I’m also interested if there are better ways to do it.