while True: if 'next' in json_out['paging'].keys(): print('===============Next Page==================') url2 = json_out['paging']['next'] resp = requests.get(url=url2) json_out = resp.json() output2 = nested_json(json_out) output = output.append(output2) else: break output.to_excel('facebook.xlsx')