CSV Import & Export
In this video, you will learn how to use two features in Postradamus - import from CSV and export to CSV.
If you master the CSV format, you will realize that you can use it for many different purposes:
- Quickly edit or schedule hundreds of posts
- Assign Post Categories to your posts in bulk
- Duplicate your posts or duplicate entire lists
- Export the images in your posts, and archive your data
CSV (or comma-separated values) file is a file that represents your data in columns and rows. That sounds familiar, right? Well, yes! You can open CSV files with any spreadsheet app, such as MS Excel, Google Sheets, OpenOffice Calc, etc.
You can also open and edit the file with any text editor of your choosing (even Notepad), but opening it with a spreadsheet software makes it the easiest to edit.
Send to CSV
We will start with the export option, because that one is simpler. We're assuming that you already have at least one list with posts in Postradamus.
Go to Send and select CSV option from the menu.
Download Your Lists
The list you select for export will be downloaded to your computer as a CSV. This means you are downloading your entire list as a spreadsheet - each post in your list will be a new row in the spreadsheet, and the following data will be downloaded for every post:
- Text of the posts
- URL/link to images in posts
- URL/link from the "Link" field in posts
- Origin of the post (where you found the content, e.g. Facebook, Twitter, Pinterest)
- Post Category
- Date and time when the post was/is scheduled
- Date when the post was last updated
- Date when the post was created
You can also check the box Include Images - this will download all of the images from your posts into a separate folder on your computer.
How neat is that?!
Edit Your Lists
Now that you have downloaded a list, you can edit it. Open the CSV file with a spreadsheet app like MS Excel or Google Sheets.
Here is what you can do:
- Edit the texts of existing posts by editing the data in "text" column
- Change the images of your posts by providing different URLs in the "image_url" column (keep in mind that these images need to be hosted online. If you want to use images that you have locally on your computer, you will need to upload them online first. You can do that on sites like Imgur)
- Make your posts "link posts" by adding a URL to a website or an article in the "link" column
- Assign Postradamus categories to your posts by adding a Category name in the "post_category" column
- Schedule your posts by adding a date and time in the "scheduled_time" column
Important: First column contains "column headings" and these should not be modified. Even if you're not using a certain column (for example, if your entire "post_category" column is empty), just leave the column and its heading as it is.
Make sure you save the file as CSV when you're done making edits.
Ok, so you have edited a bunch of posts now, but how will Postradamus know you did this?
Import from CSV
Now, you need to import your CSV file to Postradamus.
Start by going to Find Content -> From a CSV File. Simply drag and drop your CSV file in the window that opens, or click and select the file to upload.
Postradamus will convert every row (except the first one with column headings) into a new post.
Select the posts you would like to add to new lists and select the lists you would like to add them to.
Create New Lists
(You can delete the second row which contains instructions, and fill out the template with your posts.)
Each row will be added as a new post in Postradamus.
When you're done, just import the CSV back into Postradamus and add your posts to a list.