HI Guys
When we export the data to clean it from the dashboard, it comes out nicely,
When I open the spreadsheets in Open OFfice I have a few parsing issues, but it’s because my data wasn’t clean to begin with.
QUESTION — IN THE CSV I’m going go to import
1. Do the column head have to be in the order of the sample or can the be in a different order as long as they are present?
2. Do I have to reimport the data with all the columns present, I think so, right? I can’t delete them if they are empty.
3. If the column is empty, should I just leave it or maybe put in a neutral placeholder?
4. As long as the Post ID is the same, If I reimport and there is new data in other columns, will it update the listings with the new data, meaning it will add it to the record?
Had some trouble with Open OFfice collapsing empty cells. pain in the b t
Cleaning lots of data.