Having trouble with viewing your results CSV? This article should help you!
- My spreadsheet is too big
- All my data is in one column
- Data/special characters are not displayed correctly
- I don't see all my data
1. My spreadsheet is too big
Often with scraping, you're dealing with pretty large numbers when it comes to output data. You may have encountered this problem when you've tried to scrape thousands of Twitter followers from an account and haven't been able to open your results file to actually see them no matter the program:
- The IMPORTDATA function in Google Sheets has a relatively low maximum capacity
- Google Drive can't open an imported file over a certain size
- Apple Numbers can't handle spreadsheets over a certain amount of cells
In our experience, the best solution is to use Apache OpenOffice - it will allow you to open large files super easily and without any distortion!
2. All of my data is in one column
If you're a Mac user you might have experienced this particular problem. If your file is too large, Apple Numbers merges all of your data into one column. So again, if this is the case for you, try using Apache OpenOffice instead.
You might have also come across this problem when using Zapier to send your output data to a Google Spreadsheet. If so, please check our how-to Zapier article for help in setting up your Zap correctly.
3. Data/special characters are not displayed correctly
When opening CSV files with Microsoft Excel, the data does not convert cleanly. Problems can include cells being separated in the wrong places and special characters such as accents (e.g. â, é, ö) being distorted.
To correctly display CSV files on Excel, you should go to Data -> Get Data -> From File -> From Text/CSV, then import the file using the UTF-8 Format with the Comma as Delimiter. You can find many online tutorials to open your CSV smoothly if you're having trouble with this.
Alternatively, special characters will be well handled if you use the IMPORTDATA function in Google Sheets.
4. I don't see all of my data
With certain Phantoms, you may not see all the data you were expecting in your output CSV (such as a user's previous jobs as extracted by LinkedIn Profile Scraper). In instances such as these, your CSV file may only display a couple of the most recent pieces of data, but your JSON file will display all of the data.
If you would like these in spreadsheet form, you can use a JSON to CSV converter.