Exported results are unordered

Problem: My exported results to a CSV are unordered. The child elements are not grouped together in their respective parent element. All I get is a jumbled mess.

Url: https://app.buzzsumo.com/projects/83579/influencers

Sitemap:
{"_id":"attempt2","startUrl":["https://app.buzzsumo.com/projects/83579/influencers"],"selectors":[{"id":"Parent-wrappers","type":"SelectorElementAttribute","parentSelectors":["_root"],"selector":"table","multiple":true,"extractAttribute":"","delay":0},{"id":"Name","type":"SelectorText","parentSelectors":["_root"],"selector":"td h4","multiple":true,"regex":"","delay":0},{"id":"Twitter handle","type":"SelectorLink","parentSelectors":["_root"],"selector":".text-left a.d-inline-flex","multiple":true,"delay":0},{"id":"Website","type":"SelectorLink","parentSelectors":["_root"],"selector":".text-left a:nth-of-type(2)","multiple":true,"delay":0},{"id":"Bio","type":"SelectorText","parentSelectors":["_root"],"selector":".ax-text span","multiple":true,"regex":"","delay":0},{"id":"Twitter followers","type":"SelectorText","parentSelectors":["_root"],"selector":"td:nth-of-type(6) h5","multiple":true,"regex":"","delay":0}]}

Screenshot of CSV:

This problem is generally related to Excel, you have wrong configuration when importing the csv files, for me i just use libre office it auto detect the csv and correct some missing quotes

This is not an Excel issue, it is a common sitemap mistake. You can fix it by creating a wrapper element (container) for your scrapers - See this posting Data doesn't match up

1 Like