I am thinking to migrate from butterCMS to PayloadCMS. ButterCMS provide an option to export all posts as csv file. Can I import into PayloadCMS and use?
You could build a custom importer! So just a function which reads the csv and creates new documents using Payload's Local API
Here is an example of a collection csv import that you may be able to modify for your needshttps://github.com/payloadcms/payload/discussions/1660
Here is another example from Wordpress as another reference (not from csv, though)https://discord.com/channels/967097582721572934/1068171728028700802
Thanks for the resource and replies. I am using cloud and I have already converted csv to json online. So is there a way to import this json object via dashboard?
Not via the dashboard, no. You'd need to do a similar script but just read from a file with your json data.